Release Note 12.4.7 - 2.4.6

Release Date

2nd July 2021

HO Version

12.4.7

POS Version

2.4.6

Web Database Compatibility Version

1.16

Features & Enhancements

14

Bug Fixes

26

Navigation

1

105750

GIN-1570-1

105750 E-Way Bill Report is now available in Web Report for uploading in EMG portal

Module:

Inventory > Register > #EMG E-Way Bill Upload Register#

Enhancement Summary:

A new Report of E-Way Bill is now available in Web Report. This Report can be used for uploading E-Way Bill in EaseMyGST Portal. In this report, only those records will be available which do not have E-Way Bill No.

2

105732

GIN-1568-1

105732 UDF Fields has been added in Web Report data source to be used in Report creation

Module:

Ginesys Web Report

Enhancement Summary:

UDF Fields has been added in Web Report data source so that it can be used in Report creation.

Data Sources are available in the following locations - 04-Procurement > 02-Transaction > Goods Return > GRT Header, 03-Inventory > 02-Transaction > Inter Stockpoint Transfer >, 04-Procurement > 02-Transaction > PO Cancellation >, 07-Production > 02-Transaction > Job Order Cancel > Job Cancel Header, 07-Production > 02-Transaction > Job Order > Job Order Header, 07-Production > 02-Transaction > Job Receipt > Job Receipt Header, 07-Production > 02-Transaction > Planning Master > MPlan Header, 07-Production > 02-Transaction > WIP Material Transaction > WIP Material Header, 07-Production > 02-Transaction > Working Plan > WPlan Header, 03-Inventory > 02-Transaction > Requistion Entry > Requisition Header, 06-Retail > 02-Transaction > Retail Sale >, 05-Sales and Distribution > 02-Transaction > Order Cancellation >, 05-Sales and Distribution > 02-Transaction > Sales Order > SO Header.

3

27783

GIN-1291-1

27783 Delivery Challan Remarks Details has been added in Transfer Out Reference Document

Module:

Ginesys Web Report

Enhancement Summary:

Delivery Challan Document Remarks has been added in following Data Source Sales & Distribution > 02-Transaction > Transfer- OUT > TR-OUT Ref Documents.

4

27784

GIN-1291-2

27784 Delivery Challan Remarks Details has been added in Sales Invoice Reference Document

Module:

Ginesys Web Report

Enhancement Summary:

Delivery Challan Document Remarks has been added in following Data Source Sales & Distribution > 02-Transaction > Sales Invoice > SI Ref Documents.

5

105647

GIN-1567-1

105647 Third Party Response String of Card/UPI Payment is now available for Report creation purpose

Module:

Ginesys Web Report

Enhancement Summary:

Integrated Third Party Payments' i.e. Card, UPI, Wallet response string along with Wallet reference number now available in data source under following location 06-Retail > 02-Transaction > POS Bill > Bill MOP with column name TPEDC_RESPONSE for using in Report preparation.

6

105635

GIN-1564-1

105635 UDF fields have been added in the Miscellaneous Data Source to be used in any Report

Module:

Ginesys Web Report

Enhancement Summary:

UDF fields have been added in Miscellaneous Data Source available in following  location 03-Inventory > 02-Transaction > Miscellaneous Entry > Miscellaneous Entry Header.

7

105636

GIN-1564-2

105636 UDF fields have been added in the Miscellaneous Cube Data Source to be used in any Report

Module:

Ginesys Web Report

Enhancement Summary:

UDF fields have been added in following Miscellaneous Data Source available in following  location 03-Inventory > 01-Cube > Miscellaneous Issue Analysis.

8

105649

GIN-1560-1

105649 Bifurcation for different Sales Channel has been added in Store Sale Achievement Report

Module:

Sales And Distribution > Retail Sale > #Retail Sale Achievement#

Enhancement Summary:

Bifurcation for different Sales Channel has been added in Store Sale Achievement Report. User will get a filter option so that user can see Online Sale, Offline Sale, Both (Online/Offline) (default value) by selecting them one by one.

9

105578

GIN-1563-1

105578 Cost Rate column has been added in Retail Sale Data source to be used for Margin Calculation

Module:

Ginesys Web Report

Enhancement Summary:

Cost Rate column has been added in following Data source 06-Retail > 02-Transaction > Retail Sale. This new column can be used for Margin Calculation of Online Sale and POS Sale (Except Wholesale/HO Sale) for Managed Stores.

10

105572

GIN-1561-1

105572 Cancel Quantity and Pending to Packed Quantity columns are now available in Pick List Status Report

Module:

Inventory > Status > #Pick Pack Status#

Enhancement Summary:

Cancel Quantity and Pending to Packed Quantity columns are now available in Pick List Status Report to get Item's Pick list status. From this report it can be identified whether the item is packed or stuck in any other state.

11

105503

GIN-1559-1

105503 Online Sale of Managed Site is now available in Composite GST Report

Module:

Finance > Register > #Composite GST Report#

Enhancement Summary:

Online Sale of Managed Site is now available in Composite GST Report so that user can view POS Online sale information. The details will reflect under Entry Source Type 'SND: RETAIL SALE'.

12

102626

GIN-1468-1

102626 Price Control Master Report in now available in Web Report Platform

Module:

Retail >  Master > #Price Control (Site wise)#

Enhancement Summary:

Price Control Master Report in now available in Web Report Platform to get Site wise Price Control Master Information along with effective date. 

13

102565

GIN-1515-1

102565 Consolidated Sales Register (Summary) Report is now available in Web Report

Module:

Sales and Distribution > Register > #Consolidated Sale Summary#

Enhancement Summary:

Consolidated Sales Register (Summary) Report is now available in Web Report. It will display Store wise Sale across all platform.

14

102566

GIN-1515-2

102566 Consolidated Sales Register (Detail) Report is now available in Web Report

Module:

Sales and Distribution > Register > #Consolidated Sale Detail#

Enhancement Summary:

Consolidated Sales Register (Detail) Report is now available in Web Report. it will display Store wise Sale across all platform at item description level.

1

105170

 N.A.

105170 Open Goods Return (Debit Note Pending) report is showing wrong Invoice Details

Module:

Procurement - Register - Open Goods Return (Debit Note Pending)

Reported Version:

12.2.0             

Scenario:

1. Go to Procurement > Register > Open Goods Return (Debit Note Pending).

2. Run the report.

3.  Observed that the report is showing wrong Invoice Details

2

105206

N.A.

105206 VMI reports is not showing all the Vendors name

Module:

Inventory > Register > VMI Goods Receive Register

Inventory > Register > VMI Sale(Retail) Register

Inventory > Register > VMI Stock Status Register

Reported Version:

11.153.10         

Scenario:

1. Run the reports.

2. Observed that all the Vendor names are not showing in Vendor Parameter LOV.

3

105477

N.A.

105477 Different Opening balance is showing for different Working Dates though Report Date range is same in Ledger & Subledger Confirmation

Module:

Finance - Register - Subledger Confirmation

Finance - Register - Ledger Confirmation

Reported Version:

12.2.0             

Scenario:

1. Run Ledger Confirmation & Subledger Confirmation.

2. Observe that Different Opening balance is showing for different Working Dates though Report Date range is same.

4

105509

N.A.

105509 Debit Note Analysis Report is showing NULL for POS

Module:

POS Utilities - Analytic Designer - Sale - Debit Note Analysis

Reported Version:

12.4.1             

Scenario:

1. Go to POS Utilities > Analytic Designer> Sale > Debit Note Analysis.

2. Run the report.

3.  Observed that data is not showing for POS. 

5

105512

N.A.

105512 Omni Channel Sales Entry is not reflecting in Composite GST Report

Module:

Finance - Register - Composite GST Report

Reported Version:

12.4.1               

Scenario:

1. Go to Finance > Register > Composite GST Report.

2. Run the report.

3. Observed that Omni Chanel Sales Entry is not reflecting in the report.

6

105515

N.A.

105515 "DBConnect Exception ORA-01489 ..." - Error message is displaying while trying to run Sales Order Report

Module:

Custom Report - Sales & Distribution - Sales Order

Reported Version:

11.153.10         

Scenario:

1. Go to Custom Report > Sales & Distribution> Sales Order.

2. Run the report.

3. Observe that following error message is being displayed - "DBConnect Exception ORA-01489 ...".

7

105562

N.A.

105562 Output is not showing for POS: Goods Return entry type in Component GST Register report

Module:

Finance - Register - Component GST Register

Reported Version:

11.150.0          

Scenario:

1. Go to Finance > Register > Component GST Register.

2. Run the report.

3. Observe that the output is not showing for POS: Goods Return entry type.

8

105574

N.A.

105574 '#POS Customer Outstanding#' Report description is not showing correctly 

Module:

Retail - Register - POS Customer Outstanding

Reported Version:

12.3.1           

Scenario:

1. Go to Retail > Register > #POS Customer Outstanding#.

2. Check Description filed.

3. Observe that the description is not showing correctly.

9

105619

N.A.

105619 Component GST Register Report is not showing data sometimes while To Date and From Date is given

Module:

Finance - Register - Component GST Register

Reported Version:

12.2.0              

Scenario:

1. Go to Finance > Register > Component GST Register.

2. Run the report.

3. observe that data is not showing sometimes while To Date and From Date is given.

10

105622

N.A.

105622 "ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-01422: exact fetch returns more than requested number of rows" - Error message is displaying while trying to run the Ledger Detail Report

Module:

Finance - Register - Ledger Detail

Reported Version:

12.4.1             

Scenario:

1. Go to Finance > Register > Ledger Detail.

2. Run the report.

3. Observe that following error message is being displayed - "ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-01422: exact fetch returns more than requested number of rows".

11

105625

N.A.

105625 "DBConnect Exception ORA-03113: end of file of communication channel..." - Error message is displaying while trying to run the 

Module:

Inventory - Status - #Inventory Status Summary - Image Wise#

Reported Version:

11.153.10        

Scenario:

1. Go to Inventory > Status > #Inventory Status Summary - Image Wise#.

2. Run the report.

3. Observe that following error message is being displayed - "DBConnect Exception ORA-03113: end of file of communication channel...".

12

105631

N.A.

105631 "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" - Error message is displaying while trying to run Sub Ledger Detail (Printable) report

Module:

Sales And Distribution - Register - Customer History

Reported Version:

12.4.1             

Scenario:

1. Go to Sales And Distribution > Register > Customer History.

2. Run Sub Ledger Detail (Printable) report.

3. Observe that following error message is being displayed - "ORA-06502: PL/SQL: numeric or value error: character string buffer too small ".

13

105637

N.A.

105637 "ORA-12899: Value too large for column ..." - Error message is displaying while trying to run WIP Valuation report

Module:

Production - Register - WIP Valuation report   POS Analytic Report - Category - Sale - Credit Note Analysis

Reported Version:

12.4.0             

Scenario:

1. Go to Production  > Register > WIP valuation report.

2. run the report.

3. Observe that following error message is being displayed - "ORA-12899: Value too large for column ..."

14

105651

N.A.

105651 "Show Blanks" option is showing in Credit Note Analysis Analytics report

Module:

POS Analytic Report - Category - Sale - Credit Note Analysis

Reported Version:

11.153.3          

Scenario:

1. Go to POS Analytic Report > Category > Sale > Credit Note Analysis.

2. Run the report.

3. Observe that "Show Blanks" option is showing.

15

105679

N.A.

105679 Cost Rate column is not showing in GINVIEW.LV_MISC_ENTRY_RECEIVE Report

Module:

GINVIEW - GINVIEW.LV_MISC_ENTRY_RECEIVE

Reported Version:

12.4.3           

Scenario:

1. Go to GINVIEW > GINVIEW.LV_MISC_ENTRY_RECEIVE Report.

2. Run it.

3. Observe that Cost Rate column is not showing.

16

105709

N.A.

105709 POS Customer with same name but with different code is getting grouped in the POS Customer Outstanding Ageing Report

Module:

Retail - Register - POS Customer Outstanding Ageing

Reported Version:

12.4.3          

Scenario:

1. Go to Retail > Register > POS Customer Outstanding Ageing.

2. Run the report

3.  Observed that data is getting grouped, if Customer name is similar.

17

105712

N.A.

105712 Opening Balance is not matching with previous day's Closing Balance in POS Customer Outstanding Ageing

Module:

Retail - Register - POS Customer Outstanding Ageing

Reported Version:

12.4.3           

Scenario:

1. Go to Retail > Register > POS Customer Outstanding Ageing.

2. Run the report

3.  Observed that Opening balance is not matching with previous day's Closing balance.

18

105787

105787 Date format of #Sub Ledger Detail# Reports changed after exporting to Excel 

Module:

Finance - Register - #Sub Ledger Detail#

Reported Version:

12.4.4           

Scenario:

1. Go to Finance > Register > #Sub Ledger Detail#.

2. Export the report to excel.

3. Observe that Date format is changed.

19

105818

105818 Two columns are missing in EMR Submit Status Reports

Module:

Retail - Transaction - POS Bill - Bill Header - #EMR Submit Status#

Reported Version:

12.4.4         

Scenario:

1. Go to 

2. Run the report.

3. Observe that two columns are missing.

20

105830

105830 Net amount is showing wrong in Composite GST Report when Entry Source is service Debit Note

Module:

Finance - Register - #Composite GST Report#

Reported Version:

12.4.1             

Scenario:

1. Go to Finance > Register > #Composite GST Report#.

2. Run the report.

3. Observe that Net amount is showing wrong when Entry Source is service Debit Note.

21

105841

105841 Net amount is showing wrong in Composite GST Report when Entry Source is Service Invoice

Module:

Finance - Register - #Composite GST Report#

Reported Version:

12.4.1            

Scenario:

1. Go to Finance > Register > #Composite GST Report#.

2. Run the report.

3. Observe that Net amount is showing wrong when Entry Source is service Invoice.

22

105847

105847 Cash Bank Book Report  is showing wrong when Sub Ledger-Employee is not tagged with AR Ledger

Module:

Finance - Register - #Cash Bank Book#

Reported Version:

12.4.1            

Scenario:

1. Go to Finance > Register > #Cash Bank Book#.

2. Run the report.

3. Observe that report is showing wrong when when Sub Ledger-Employee is not tagged with AR Ledger.
   
   

23

105892

105892 "DBConnect Exception ORA-06550: ... " - Error message is displaying while trying to open Open Documents Logistics Pending report

Module:

Inventory - Status  - Open Documents Logistics pending

Reported Version:

12.4.6

Scenario:

1. Go to Inventory > Status  > Open Documents Logistics Pending.

2. Run the report.

3. Observe that the following error message is being displayed - "DBConnect Exception ORA-06550: ... ".

24

105889

105889 Default 'Report Role' is not showing in the User detail entry form

Module:

Admin - Security - Users 

Reported Version:

12.4.6

Scenario:

1. Go to Admin > Security > Users.

2. Create or Edit any existing User.

3.  Observe that the default 'Report role' is not showing.

25

105898

105898 Report Role & Folder Security is not working in the local system with updated Software Version - 12.4.6

Module:

Server - Roles 

Reported Version:

12.4.6

Scenario:

1. Update to 12.4.6.

2. Go to Server > Roles.

3.  Assign Folders to the role and then assign this role to user.

4. Observe that Report Role & Folder Security is not working in the local system.

26

105901

105901 Some errors are showing during report execution after update to latest version

Module:

Web Report

Reported Version:

12.4.6           

Scenario:

1. Update to 12.4.6.

2. Go to Web Report.

3. Observe that some errors are showing during report execution.