Release Note 12.31.1

Control

Release Date	30th Mar, 2026
HO Version	12.31.1
POS Version	2.31.1
Compatible Report Version	2026001
Web Database Compatibility Version	1.20
Features & Enhancements	05
Bug Fixes	29
Navigation	1 Features and Improvements 1.1 Enhancement made to include an additional Reference column in the RQ_SALES_TROUT_DOC (Sales Invoice-TR-Out) data source to improve traceability and provide better linkage with related transactional data. 1.2 Added the Return_Type field to the GRT Header data source to enable classification and analysis of various return types within return-related reports. 1.3 Extended the Item Master data sources to include a few Item Properties fields, like CHARGE_EXTRA_TAX, POS_RETURN_BEHAVIOR, COSTSHEET_ID, and COSTSHEET_DATE for reporting and analytics. 1.4 Enhanced Retail Sales & Stock Reports by incorporating Batch/Serial information, enabling users to track batch-wise and serial-wise stock and sales details. 1.5 Enhanced the Chart of Account Data Source by introducing an additional hierarchy level, enabling more granular financial data reporting and better account structure management. 2 Bug Fixes 2.1 Performance issue in reports where finpost_particulars_stage table is used in query. 2.2 Bin group-related data is missing in reports where the 'Bin Group' datasource is used 2.3 Date Parameter value is showing wrong in #PO Cancellation Register# 2.4 Data not showing in reports made from 'DAY HOUR' category. 2.5 #Bin wise Item stock summary# report has wrong joining, within 'Bin Master' category and 'Owner Site' 2.6 Additional_refdetail column is showing blank in the Adjustment History category. 2.7 ITEM_NET_AMOUNT is showing wrong value in the 'Composite Purchase Details' category 2.8 Value is not showing in the Remarks field in #Goods Receive Challan - Item Wise Margin#. 2.9 The Due_Date column is not included in the 'SRV Sale Header' datasource 2.10 Need to remove the Site Profitability category from parent xml. 2.11 Data is showing wrong when using the HSN-SAC-GST Applicability and HSN-SAC-GST Slab datasource in a report. 2.12 The #Sales Return Tax Summary# is displaying an incorrect value in the "App Amount" field. 2.13 An error occurs when selecting filters in Finance reports where the ginview.fnc_ledgerdetails and fnc_refdetails objects are used. Error: DbConnect Exception 22001: value too long for type character varying(65000) 2.14 Sub Ledger-related generic reports are not displaying data for all financial postings. 2.15 Opening Balance not showing in #Ledger Confirmation# report. 2.16 Taxable amount is showing as null in the #Bill wise Outstanding Analysis# Report when checked against Purchase Debit Note documents. 2.17 Performance issue in #Sales Invoice Register - Date Wise# and #Sales Invoice Register - Customer Wise# reports. 2.18 Performance issue in #Inventory Status Ledger# report. 2.19 In the Billwise Outstanding Analysis generic report, the tax amount fields—CGST tax amount, SGST tax amount, IGST tax amount, cess amount, and total GST amount—are not displaying any data. 2.20 An error showing when creating a report from the 'GRC PI Item Batch' object - Error executing query: SQL Error [42P01]: ERROR: relation "ginview.lv_grc_pi_item_batch" does not exist 2.21 Report description is not correct for #Open Goods Receive (Bill Pending)#. 2.22 Report description is not correct in #Inventory Movement (Detail)# report 2.23 Spelling of the 'WASTAGE_QUANTITY' column header is wrong in Job Order Component category. 2.24 Inventory Movement Summary and Inventory Movement Detail reports are not showing correctly 2.25 Inventory Movement Report shows the monthly 'Unsettled Quantity' instead of Total Up to Selected Month unsettled value 2.26 The #Item Barcode History Date Wise Document# report is showing an error when the Batch/Serial parameter is selected as Yes 2.27 Barcode is not visible in the #Retail Sale & Stock# report 2.28 Image is not showing in the Cost Sheet Reports. 2.29 Data is not showing correctly in reports made from 'Store Collection MOP Wise' and 'Retail Customer'.

Compatible POS Release Note - Release Note 2.31.1

Features and Improvements

ID	Description	Module

ID	Description	Module
81711	Enhancement made to include an additional Reference column in the RQ_SALES_TROUT_DOC (Sales Invoice-TR-Out) data source to improve traceability and provide better linkage with related transactional data.	Report Specific\Document\Sales Invoice-TR-Out\Sales Invoice-TR-Out
86199	Added the Return_Type field to the GRT Header data source to enable classification and analysis of various return types within return-related reports.	04-Procurement\02-Transaction\Goods Return\GRT Header
91529	Extended the Item Master data sources to include a few Item Properties fields, like CHARGE_EXTRA_TAX, POS_RETURN_BEHAVIOR, COSTSHEET_ID, and COSTSHEET_DATE for reporting and analytics.	01-Master\Item 01-Master\Production\Item\Component Item 01-Master\Production\Item\Assembly Item
91739	Enhanced Retail Sales & Stock Reports by incorporating Batch/Serial information, enabling users to track batch-wise and serial-wise stock and sales details.	Sales and Distribution > Retail Sale > #Retail Sales & Stock#
100565	Enhanced the Chart of Account Data Source by introducing an additional hierarchy level, enabling more granular financial data reporting and better account structure management.	01-Master\Chart of Accounts

Bug Fixes

ID	Description	Module

ID	Description	Module
57859	Performance issue in reports where finpost_particulars_stage table is used in query.	Ginesys Web Reports>Finance>Register Reports
81549	Bin group-related data is missing in reports where the 'Bin Group' datasource is used	Ginesys Web Report>Category>Master>Bin Group
82726	Date Parameter value is showing wrong in #PO Cancellation Register#	Ginesys Web Report>Procurement>Register>#PO Cancellation Register#
84455	Data not showing in reports made from 'DAY HOUR' category.	Ginesys Web Report>Category>Master>DAY HOUR
85056	#Bin wise Item stock summary# report has wrong joining, within 'Bin Master' category and 'Owner Site'	Ginesys Web Report>Inventory>Status>#Bin wise Item stock summary#
85205	Additional_refdetail column is showing blank in the Adjustment History category.	Ginesys Web Report>Category>Finance>Composite>Adjustment History
88452	ITEM_NET_AMOUNT is showing wrong value in the 'Composite Purchase Details' category	Ginesys Web Report>Category>Procurement>Transaction>Combined Purchase
91714	Value is not showing in the Remarks field in #Goods Receive Challan - Item Wise Margin#.	Ginesys Web Report>Procurement>Document>#Goods Receive Challan - Item Wise Margin#
97168	The Due_Date column is not included in the 'SRV Sale Header' datasource	Ginesys Web Report>Category>Sales And Distribution>Transaction>Service Invoice>SRV Sale Header
98480	Need to remove the Site Profitability category from parent xml.	Ginesys Web Report>Finance>Report Specific>Site Profitability
98493	Data is showing wrong when using the HSN-SAC-GST Applicability and HSN-SAC-GST Slab datasource in a report.	Ginesys Web Report>Master>GST>HSN-SAC-GST Applicability
99631	The #Sales Return Tax Summary# is displaying an incorrect value in the "App Amount" field.	Ginesys Web Report>Sales And Distribution>Register>#Sales Return Tax Summary#
100382	An error occurs when selecting filters in Finance reports where the ginview.fnc_ledgerdetails and fnc_refdetails objects are used. Error: DbConnect Exception 22001: value too long for type character varying(65000)	Ginesys Web Report>Finance
100570	Sub Ledger-related generic reports are not displaying data for all financial postings.	Ginesys Web Report>Finance>Register>Sub Ledger Detail
100625	Opening Balance not showing in #Ledger Confirmation# report.	Ginesys Web Reports>Finance>Register>#Ledger Confirmation#
104766	Taxable amount is showing as null in the #Bill wise Outstanding Analysis# Report when checked against Purchase Debit Note documents.	Ginesys Web Report>Finance>Register>#Bill wise Outstanding Analysis#
69460	Performance issue in #Sales Invoice Register - Date Wise# and #Sales Invoice Register - Customer Wise# reports.	Ginesys Web Report>Sales And Distribution>Sales Invoice Register - Date Wise#/#Sales Invoice Register - Customer Wise#
84251	Performance issue in #Inventory Status Ledger# report.	Ginesys Web Report>Inventory>Status>#Inventory Status Ledger#
105644	In the Billwise Outstanding Analysis generic report, the tax amount fields—CGST tax amount, SGST tax amount, IGST tax amount, cess amount, and total GST amount—are not displaying any data.	Ginesys Web Report>Finance>Register>#Bill wise Outstanding Analysis - Tabular#/#Bill wise Outstanding Analysis#
105744	An error showing when creating a report from the 'GRC PI Item Batch' object - Error executing query: SQL Error [42P01]: ERROR: relation "ginview.lv_grc_pi_item_batch" does not exist	Ginesys Web Report>Procurement>Transaction>Goods Receive>GRC PI Item Batch
79506	Report description is not correct for #Open Goods Receive (Bill Pending)#.	Ginesys Web Report>Procurement>Register>#Open Goods Receive (Bill Pending)#
83240	Report description is not correct in #Inventory Movement (Detail)# report	Ginesys Web Report>Inventory>Status>StockBook>#Inventory Movement (Detail)#
91779	Spelling of the 'WASTAGE_QUANTITY' column header is wrong in Job Order Component category.	Ginesys Web Report>Category>Production>Transaction>Job Order>Job Order Component
107963	Inventory Movement Summary and Inventory Movement Detail reports are not showing correctly	Ginesys Web Report>Inventory>Composite>Stock Book Summary
112424	Inventory Movement Report shows the monthly 'Unsettled Quantity' instead of Total Up to Selected Month unsettled value	Ginesys Web Report>Inventory>Status>StockBook>#Inventory Movement (Detail)#
108044	The #Item Barcode History Date Wise Document# report is showing an error when the Batch/Serial parameter is selected as Yes	Ginesys Web Report>Inventory>Register>#Item Barcode History Date Wise Document#
112592	Barcode is not visible in the #Retail Sale & Stock# report	Ginesys Web Report>Sales And Distribution>#Retail Sale & Stock#
91641	Image is not showing in the Cost Sheet Reports.	Ginesys Web Report>Production>Document>#Cost Sheet
87211	Data is not showing correctly in reports made from 'Store Collection MOP Wise' and 'Retail Customer'.	Ginesys Web Report>Category>Retail>Report Specific>Store Collection MOP Wise

Release Note 12.31.1

Control

Features and Improvements

Enhancement made to include an additional Reference column in the RQ_SALES_TROUT_DOC (Sales Invoice-TR-Out) data source to improve traceability and provide better linkage with related transactional data.

Added the Return_Type field to the GRT Header data source to enable classification and analysis of various return types within return-related reports.

Extended the Item Master data sources to include a few Item Properties fields, like CHARGE_EXTRA_TAX, POS_RETURN_BEHAVIOR, COSTSHEET_ID, and COSTSHEET_DATE for reporting and analytics.

Enhanced Retail Sales & Stock Reports by incorporating Batch/Serial information, enabling users to track batch-wise and serial-wise stock and sales details.

Enhanced the Chart of Account Data Source by introducing an additional hierarchy level, enabling more granular financial data reporting and better account structure management.

Bug Fixes

Performance issue in reports where finpost_particulars_stage table is used in query.

Bin group-related data is missing in reports where the 'Bin Group' datasource is used

Date Parameter value is showing wrong in #PO Cancellation Register#

Data not showing in reports made from 'DAY HOUR' category.

#Bin wise Item stock summary# report has wrong joining, within 'Bin Master' category and 'Owner Site'

Additional_refdetail column is showing blank in the Adjustment History category.

ITEM_NET_AMOUNT is showing wrong value in the 'Composite Purchase Details' category

Value is not showing in the Remarks field in #Goods Receive Challan - Item Wise Margin#.

The Due_Date column is not included in the 'SRV Sale Header' datasource

Need to remove the Site Profitability category from parent xml.

Data is showing wrong when using the HSN-SAC-GST Applicability and HSN-SAC-GST Slab datasource in a report.

The #Sales Return Tax Summary# is displaying an incorrect value in the "App Amount" field.

An error occurs when selecting filters in Finance reports where the ginview.fnc_ledgerdetails and fnc_refdetails objects are used. Error: DbConnect Exception 22001: value too long for type character varying(65000)

Sub Ledger-related generic reports are not displaying data for all financial postings.

Opening Balance not showing in #Ledger Confirmation# report.

Taxable amount is showing as null in the #Bill wise Outstanding Analysis# Report when checked against Purchase Debit Note documents.

Performance issue in #Sales Invoice Register - Date Wise# and #Sales Invoice Register - Customer Wise# reports.

Performance issue in #Inventory Status Ledger# report.

In the Billwise Outstanding Analysis generic report, the tax amount fields—CGST tax amount, SGST tax amount, IGST tax amount, cess amount, and total GST amount—are not displaying any data.

An error showing when creating a report from the 'GRC PI Item Batch' object - Error executing query: SQL Error [42P01]: ERROR: relation "ginview.lv_grc_pi_item_batch" does not exist

Report description is not correct for #Open Goods Receive (Bill Pending)#.

Report description is not correct in #Inventory Movement (Detail)# report

Spelling of the 'WASTAGE_QUANTITY' column header is wrong in Job Order Component category.

Inventory Movement Summary and Inventory Movement Detail reports are not showing correctly

Inventory Movement Report shows the monthly 'Unsettled Quantity' instead of Total Up to Selected Month unsettled value

The #Item Barcode History Date Wise Document# report is showing an error when the Batch/Serial parameter is selected as Yes

Barcode is not visible in the #Retail Sale & Stock# report

Image is not showing in the Cost Sheet Reports.

Data is not showing correctly in reports made from 'Store Collection MOP Wise' and 'Retail Customer'.