Release Note 12.27.2

Control

Release Date	21st August 2025
HO Version	12.27.2
POS Version	2.27.2
Compatible Report Version	2025003
Web Database Compatibility Version	1.20
Features & Enhancements	08
Bug Fixes	43
Navigation	1 Features and Improvements 1.1 Enhancement on age calculation based on a defined parameter in the Bill Wise Outstanding and Ageing Reports. 1.2 Datasource Required for Approver and Approver Site Assignment 1.3 GV and POSBill OTP Discount related fields to be added to Various data sources 1.4 Inclusion of PSITE_COUPONOFFER.CODE in LV_ASSIGNED_COUPONOFFERS data-source 1.5 New Report for Stock named #Stock Status Register# 1.6 New Report for OTP and Privileged Discount named #Store Bill Discount Register - OTP\|Privileged# 1.7 #Trial Balance-Periodic# and #Trial Balance-Tabular# Report should have Sub Ledger Information 1.8 New Report for Sale named #Sales Origin Register# 2 Bug Fixes 2.1 Data is not showing correctly in the 'Composite HO Sales Details' category for some fields. 2.2 Column name is showing wrong in the Composite Purchase Service Details category. 2.3 Transfer Out and Transfer In data are not showing in reports made from the Invoice Analysis Cube. 2.4 The #Profit&Loss - Cost Centre (Tabular)# report is displaying the incorrect sequence of the Chart of Accounts levels. 2.5 The closing amount is showing incorrectly in the #Profit&Loss (Tabular)# report if any balance is present from the previous year. 2.6 The #Purchase Service Register# report is showing only one service detail in the service invoice document. 2.7 In the #Document Adjustment Register# report Entry type is not showing for unadjusted documents . 2.8 'Item_tax_rate' is showing wrong in the PI Item category . 2.9 Deleting Terminal User column will be removed from the #Deleted Document Register# report. 2.10 Shipping Details are showing wrong in the #EMG E-Way Bill Upload Register# report. 2.11 Store Status is showing wrong data in the #Store Performance Report# report 2.12 Main Remarks field is showing wrong value in the Retail Sale Category 2.13 Total_Quantity is showing wrong in the MPlan Component Summary category 2.14 Completed qty is not showing correctly in the #Job Order Register# report. 2.15 Reports made from 'Inter Stockpoint Transfer' and 'Jobber' or 'Jobber Ref' categories are not showing complete data. 2.16 Received Qty' field is showing '0' in #Incoming - LR Issue Summary# report. 2.17 The 'Item Master' category does not capture the changes, if any modifications in item made through Manage Item or Excel import. 2.18 #GV History# report showing error while executing- Error: DbConnect Exception ORA-04063: view "GINVIEW.LV_GV_HISTORY" has errors 2.19 'Vehicle No' field is not showing data in the 'E-way Bill' category. 2.20 In the #Ledger Detail - Cost Center# report, the opening balance is not showing properly . 2.21 'Payment Amount' field is showing the wrong value in the AP Voucher Document. 2.22 Item properties are not showing for the items in the #Stock Audit Verification Register# report when the Snapshot Qty is zero. 2.23 #Post Promotion Analysis# report is showing error when selecting a 'Promo Name' value whose Start date is different for two different sites. 2.24 Data is not showing in reports made from the 'Bin Group' and 'Bin Master' data sources. 2.25 'Received_asembly_item_name' field is showing blank in the report made from WIP Clearance Detail. 2.26 Multiple records are showing for an item in the Real time Stock Point wise Stock category. 2.27 Performance issue in #Retail Sales & Stock# report 2.28 Performance issue in #Sub Ledger Detail# report 2.29 The #Document Adjustment Register# report is showing blank when selecting multiple ledgers from the filter. 2.30 Balance is not showing in the Cash Balance Report . 2.31 Performance issue in #Stock Audit Verification Register# report. 2.32 Data not coming in #Composite GST Report# report . 2.33 Performance issue in #Sub Ledger Summary# report 2.34 Wrong joining exists between Sales Invoice-TR-Out with DC and Site category . 2.35 In Stock Book Summary, Category conversion issue, and receive qty showing wrong. 2.36 Performance issue in reports made from the 'Composite Purchase Service Details' category. 2.37 Error showing while filtering data in edit mode of #Bill wise Outstanding Analysis# report. 2.38 Error showing while filtering data in edit mode of #Customer-Vendor Outstanding Ageing Analysis# report. 2.39 Error showing while Printing Cheque-'DbConnect Exception ORA-04063: view "GINVIEW.LV_FINANCE_VOUCHER" has errors.' 2.40 Audit Trail reports are appearing twice in the System folder. 2.41 Register Reports are showing error where 'Item Name' field is used. 2.42 Error showing while executing reports- DbConnect Exception 2200H: nextval: reached maximum value of sequence "seq_ri$uk" (99999999999) 2.43 Return Entries are not showing in the report generated from the E-COM-S Header data source.

Compatible POS Release Note - Release Note 2.27.2

Features and Improvements

	ID	Description

	ID	Description
1	84688	Enhancement on age calculation based on a defined parameter in the Bill Wise Outstanding and Ageing Reports. Module: Finance > Register > #Bill wise Outstanding Analysis - Tabular# Finance > Register > #Bill Wise Outstanding Analysis MSME - Tabular# Finance > Register > #Bill Wise Outstanding Analysis# Finance > Register > #Customer-Vendor Outstanding Ageing Analysis# Enhancement Summary: Enhanced the age calculation logic in the Bill Wise Outstanding and Ageing Reports modules to support dynamic age computation based on a user-defined parameter. Document/Ref. Date, 2. Ref/Document Date, 3. Document Date (New), 4. Due Date. This report will now provide more flexibility and accuracy in reporting outstanding balances as per specific business requirements.
2	82248	Datasource Required for Approver and Approver Site Assignment Module: Master\Approver Master\Approver Assignment Enhancement Summary: Introduced a new data source to support Approver and Approver Site Assignment functionality. The data source captures essential details to identify Approver Site assignment details, thereby improving administrative efficiency and approval governance.
3	82246	GV and POSBill OTP Discount related fields to be added to Various data sources Module: Retail\Transaction\POS Bill\Bill Header Retail\Transaction\POS GV Bill\POS GV Bill Header Retail\Composite\POS\Bill Summary Retail\Composite\POS\Bill Details Enhancement Summary: Enhanced multiple data sources to include new fields related to Gift Voucher (GV) and POS Bill for OTP-based Discounts. This update enables improved tracking, reporting, and analysis of discounts applied via OTP validation at the point of sale.
4	81715	Inclusion of PSITE_COUPONOFFER.CODE in LV_ASSIGNED_COUPONOFFERS data-source Module: Master\Retail\Site Assignment\Site Coupon Offer Enhancement Summary: Enhanced the LV_ASSIGNED_COUPONOFFERS data source by including the PSITE_COUPONOFFER.CODE field. This addition enables better traceability and reporting by providing direct visibility of the coupon offer code.
5	81642	New Report for Stock named #Stock Status Register# Module: Inventory > Status > #Stock Status Register# Enhancement Summary: Introduced a new report "Stock Status Register" to provide a comprehensive view of current stock of Items across locations for a particular date. The Stock Status Register enables users to monitor stock levels in real-time, supporting better inventory control and planning.
6	81643	New Report for OTP and Privileged Discount named #Store Bill Discount Register - OTP\|Privileged# Module: Ginesys POS > Register > #Store Bill Discount Register - OTP & Priviledged# Enhancement Summary: Introduced a new report titled "Store Bill Discount Register – OTP \| Privileged" to provide detailed insights into discounts applied Bills at the store level through OTP-based and Privileged discount mechanisms. This enables better tracking, auditing, and analysis of discount usage and effectiveness across stores.
7	85210	#Trial Balance-Periodic# and #Trial Balance-Tabular# Report should have Sub Ledger Information Module: Finance\Financial Statement\#Trial Balance Periodic# Finance\Financial Statement\#Trial Balance Tabular# Finance\Financial Statement\#Trial Balance# Enhancement Summary: Enhanced the "Trial Balance#", "Trial Balance – Periodic", and "Trial Balance – Tabular" reports to include Sub Ledger Information. This update allows users to view detailed breakdowns of balances by individual sub-ledgers directly within the trial balance reports. The inclusion improves financial transparency and supports deeper analysis of account movements, enabling better reconciliation and audit compliance.
8	93956	New Report for Sale named #Sales Origin Register# Module: Admin\Status\#Sales Origin Register# Enhancement Summary: A new report, '#Sales Origin Register#' report has been introduced to summarize all sales and returns based on their originating channels or sources.

Bug Fixes

	ID	Description	Module

	ID	Description	Module
1	64698	Data is not showing correctly in the 'Composite HO Sales Details' category for some fields.	Ginesys Web Report>Category>Sales and Distribution>Transaction>Composite HO Sales>Composite HO Sales Details
2	64700	Column name is showing wrong in the Composite Purchase Service Details category.	Ginesys Web Report>Category>Procurement>Transaction>Combined Purchase Service>Composite Purchase Service Details
3	64740	Transfer Out and Transfer In data are not showing in reports made from the Invoice Analysis Cube.	Ginesys Web Report>Category>Sales and Distribution>Cube>Invoice Analysis
4	64790	The #Profit&Loss - Cost Centre (Tabular)# report is displaying the incorrect sequence of the Chart of Accounts levels.	Ginesys Web Report>Finance>Financial Statement>#Profit&Loss - Cost Centre (Tabular)#
5	65500	The closing amount is showing incorrectly in the #Profit&Loss (Tabular)# report if any balance is present from the previous year.	Ginesys Web Report>Finance>Financial Statement>#Profit&Loss (Tabular)#
6	69926	The #Purchase Service Register# report is showing only one service detail in the service invoice document.	Ginesys Web Report>Procurement>Register>#Purchase Service Register#
7	71286	In the #Document Adjustment Register# report Entry type is not showing for unadjusted documents .	Ginesys Web Reports > Finance>Register>#Document Adjustment Register#
8	71773	'Item_tax_rate' is showing wrong in the PI Item category .	Ginesys Web Report>Category>Procurement>Transaction>Purchase Invoice>PI Item
9	73284	Deleting Terminal User column will be removed from the #Deleted Document Register# report.	Ginesys Web Report>Admin>Status>#Deleted Document Register#
10	73990	Shipping Details are showing wrong in the #EMG E-Way Bill Upload Register# report.	Ginesys Web Report>Inventory>Register>#EMG E-Way Bill Upload Register#
11	74104	Store Status is showing wrong data in the #Store Performance Report# report	Ginesys Web Report>Ginesys POS>Register>#Store Performance Report#
12	74124	Main Remarks field is showing wrong value in the Retail Sale Category	Ginesys Web Report>Category>Retail>Transaction>Retail Sale
13	74132	Total_Quantity is showing wrong in the MPlan Component Summary category	Ginesys Web Report>Production>Transaction>Planning Master>MPlan Component Summary
14	74669	Completed qty is not showing correctly in the #Job Order Register# report.	Ginesys Web Report>Production>Register>#Job Order Register#
15	75665	Reports made from 'Inter Stockpoint Transfer' and 'Jobber' or 'Jobber Ref' categories are not showing complete data.	Ginesys Web Report>Category>Master>Jobber Ref Ginesys Web Report>Category>Master>Jobber
16	76296	Received Qty' field is showing '0' in #Incoming - LR Issue Summary# report.	Ginesys Web Report>Inventory>Status>#Incoming - LR Issue Summary#
17	77108	The 'Item Master' category does not capture the changes, if any modifications in item made through Manage Item or Excel import.	Ginesys Web Report>Category>Master>Item
18	78486	#GV History# report showing error while executing- Error: DbConnect Exception ORA-04063: view "GINVIEW.LV_GV_HISTORY" has errors	Ginesys Web Report>Ginesys POS>Register>#GV History#
19	78678	'Vehicle No' field is not showing data in the 'E-way Bill' category.	Ginesys Web Report>Category>Cross Module>Composite>E-way Bill
20	79842	In the #Ledger Detail - Cost Center# report, the opening balance is not showing properly .	Ginesys Web Report >Finance >Register>#Ledger Detail - Cost Center#
21	80048	'Payment Amount' field is showing the wrong value in the AP Voucher Document.	Ginesys Web Report>Finance>Document>#AP Voucher #
22	80173	Item properties are not showing for the items in the #Stock Audit Verification Register# report when the Snapshot Qty is zero.	Ginesys Web Report>Inventory>Register>#Stock Audit Verification Register#
23	81017	#Post Promotion Analysis# report is showing error when selecting a 'Promo Name' value whose Start date is different for two different sites.	Ginesys Web Report>Ginesys POS>Register>#Post Promotion Analysis#
24	81019	Data is not showing in reports made from the 'Bin Group' and 'Bin Master' data sources.	Ginesys Web Report>Category>Master>Bin Master
25	83958	'Received_asembly_item_name' field is showing blank in the report made from WIP Clearance Detail.	Ginesys Web Report>Production>Transaction>WIP Clearance>WIP Clearance Detail.
26	84237	Multiple records are showing for an item in the Real time Stock Point wise Stock category.	Ginesys Web Report>Category>Inventory>Composite>On-Hand Stock>Stock Point wise Stock
27	88626	Performance issue in #Retail Sales & Stock# report	Ginesys Web Report>Sales And Distribution>Register>#Retail Sale & Stock#
28	83658	Performance issue in #Sub Ledger Detail# report	Ginesys Web Report>Finance>Register>#Sub Ledger Detail#
29	70788	The #Document Adjustment Register# report is showing blank when selecting multiple ledgers from the filter.	Ginesys Web Report>Finance>Register>#Document Adjustment Register#
30	73377	Balance is not showing in the Cash Balance Report .	Ginesys Web Report >Finance>Register>#Cash Balance#
31	79784	Performance issue in #Stock Audit Verification Register# report.	Ginesys Web Report>Inventory>Register>#Stock Audit Verification Register#
32	81991	Data not coming in #Composite GST Report# report .	Ginesys Web Report >Finance>Register>#Composite GST Report#
33	83659	Performance issue in #Sub Ledger Summary# report	Ginesys Web Report>Finance>Register>#Sub Ledger Summary#
34	85011	Wrong joining exists between Sales Invoice-TR-Out with DC and Site category .	Ginesys Web Report>Category>Report Specific>Document>Sales Invoice-TR-Out with DC
35	88620	In Stock Book Summary, Category conversion issue, and receive qty showing wrong.	Ginesys Web Report >Category >Inventory>Cube>Stock Book Summary
36	90787	Performance issue in reports made from the 'Composite Purchase Service Details' category.	Ginesys Web Report>Category>Procurement>Transaction>Combined Purchase Service>Composite Purchase Service Details
37	91526	Error showing while filtering data in edit mode of #Bill wise Outstanding Analysis# report.	Ginesys Web Report>Finance>Register>#Bill wise Outstanding Analysis#
38	91528	Error showing while filtering data in edit mode of #Customer-Vendor Outstanding Ageing Analysis# report.	Ginesys Web Report>Finance>Register>#Customer-Vendor Outstanding Ageing Analysis#
39	92038	Error showing while Printing Cheque-'DbConnect Exception ORA-04063: view "GINVIEW.LV_FINANCE_VOUCHER" has errors.'	Ginesys Web Report>Finance>Document>Print Cheque
40	92596	Audit Trail reports are appearing twice in the System folder.	Ginesys Web Report>System>Audit Trail>Reports
41	94250	Register Reports are showing error where 'Item Name' field is used.	Ginesys Web Report>Register Reports
42	83944	Error showing while executing reports- DbConnect Exception 2200H: nextval: reached maximum value of sequence "seq_ri$uk" (99999999999)	Ginesys Web Report>Document Reports
43	81834	Return Entries are not showing in the report generated from the E-COM-S Header data source.	Ginesys Web Report>Retail>Transaction>E-Com Bill By Seller>E-COM-S Header

Release Note 12.27.2

Control

Features and Improvements

Enhancement on age calculation based on a defined parameter in the Bill Wise Outstanding and Ageing Reports.

Datasource Required for Approver and Approver Site Assignment

GV and POSBill OTP Discount related fields to be added to Various data sources

Inclusion of PSITE_COUPONOFFER.CODE in LV_ASSIGNED_COUPONOFFERS data-source

New Report for Stock named #Stock Status Register#

New Report for OTP and Privileged Discount named #Store Bill Discount Register - OTP|Privileged#

#Trial Balance-Periodic# and #Trial Balance-Tabular# Report should have Sub Ledger Information

New Report for Sale named #Sales Origin Register#

Bug Fixes

Data is not showing correctly in the 'Composite HO Sales Details' category for some fields.

Column name is showing wrong in the Composite Purchase Service Details category.

Transfer Out and Transfer In data are not showing in reports made from the Invoice Analysis Cube.

The #Profit&Loss - Cost Centre (Tabular)# report is displaying the incorrect sequence of the Chart of Accounts levels.

The closing amount is showing incorrectly in the #Profit&Loss (Tabular)# report if any balance is present from the previous year.

The #Purchase Service Register# report is showing only one service detail in the service invoice document.

In the #Document Adjustment Register# report Entry type is not showing for unadjusted documents .

'Item_tax_rate' is showing wrong in the PI Item category .

Deleting Terminal User column will be removed from the #Deleted Document Register# report.

Shipping Details are showing wrong in the #EMG E-Way Bill Upload Register# report.

Store Status is showing wrong data in the #Store Performance Report# report

Main Remarks field is showing wrong value in the Retail Sale Category

Total_Quantity is showing wrong in the MPlan Component Summary category

Completed qty is not showing correctly in the #Job Order Register# report.

Reports made from 'Inter Stockpoint Transfer' and 'Jobber' or 'Jobber Ref' categories are not showing complete data.

Received Qty' field is showing '0' in #Incoming - LR Issue Summary# report.

The 'Item Master' category does not capture the changes, if any modifications in item made through Manage Item or Excel import.

#GV History# report showing error while executing- Error: DbConnect Exception ORA-04063: view "GINVIEW.LV_GV_HISTORY" has errors

'Vehicle No' field is not showing data in the 'E-way Bill' category.

In the #Ledger Detail - Cost Center# report, the opening balance is not showing properly .

'Payment Amount' field is showing the wrong value in the AP Voucher Document.

Item properties are not showing for the items in the #Stock Audit Verification Register# report when the Snapshot Qty is zero.

#Post Promotion Analysis# report is showing error when selecting a 'Promo Name' value whose Start date is different for two different sites.

Data is not showing in reports made from the 'Bin Group' and 'Bin Master' data sources.

'Received_asembly_item_name' field is showing blank in the report made from WIP Clearance Detail.

Multiple records are showing for an item in the Real time Stock Point wise Stock category.

Performance issue in #Retail Sales & Stock# report

Performance issue in #Sub Ledger Detail# report

The #Document Adjustment Register# report is showing blank when selecting multiple ledgers from the filter.

Balance is not showing in the Cash Balance Report .

Performance issue in #Stock Audit Verification Register# report.

Data not coming in #Composite GST Report# report .

Performance issue in #Sub Ledger Summary# report

Wrong joining exists between Sales Invoice-TR-Out with DC and Site category .

In Stock Book Summary, Category conversion issue, and receive qty showing wrong.

Performance issue in reports made from the 'Composite Purchase Service Details' category.

Error showing while filtering data in edit mode of #Bill wise Outstanding Analysis# report.

Error showing while filtering data in edit mode of #Customer-Vendor Outstanding Ageing Analysis# report.

Error showing while Printing Cheque-'DbConnect Exception ORA-04063: view "GINVIEW.LV_FINANCE_VOUCHER" has errors.'

Audit Trail reports are appearing twice in the System folder.

Register Reports are showing error where 'Item Name' field is used.

Error showing while executing reports- DbConnect Exception 2200H: nextval: reached maximum value of sequence "seq_ri$uk" (99999999999)

Return Entries are not showing in the report generated from the E-COM-S Header data source.