Release Note 12.26.4

Control

Release Date	04th Jun 2025
HO Version	12.26.4
POS Version	2.26.3
Compatible Report Version	2025002
Web Database Compatibility Version	1.20
Features & Enhancements	04
Bug Fixes	45
Navigation	1 Features and Improvements 1.1 New Reports for Audit Trail 1.2 POS Executive Summary Report Restructuring 1.3 New Data Source for GRC Item wise PI Details 1.4 Enhancement in MOP Category Visibility 2 Bug Fixes 2.1 Item Charge level details is not showing in Store GRT Item Batch Category. 2.2 Item Charge level details is not showing in Store GRC Item Batch Category. 2.3 Item Charge level details is not showing in Store GRT Item Category. 2.4 GST_DOC_NO is not showing in DOCUMENT_NUMBER field for ETL Transaction type(Retail Sale), in GST E-invoice. 2.5 IN SO Item category Item_gross_amount and Item_net_amount showing wrong. 2.6 In #Planning Register# report plan qty is showing wrong in header and total section. 2.7 Receive Type field is showing wrong data in #Purchase Order Tracking Summary# report. 2.8 Data showing wrong in #Store Sales Person Performance# report. 2.9 In #Sales Order# document report grand total and amount in words is showing zero if tax not applied. 2.10 Opening Amount and Closing Amount is showing 0 in Retail POS Session category. 2.11 In #Goods Receive Challan# report Markup % and Markdown % is showing error when received_RSP is zero or null. 2.12 The OPENTIME, OPENON, CLOSEDTIME, and CLOSEDON fields in the Retail POS Session category display both date and time values. 2.13 #Goods Receive Register# report showing wrong data when multiple purchase Invoice created against one GRC. 2.14 #Profit&Loss - Cost Centre (Tabular)# report is showing error while executing-'There are formulas that contain syntax errors. Please fix the errors before continuing.' 2.15 The opening balance is displaying as null, but the closing balance is showing for same month in the Ledger by Month report for a ledger when no transactions are found for the selected month. 2.16 Document report printing logo even though logo print value is "No" in report template. 2.17 The Item_TAX_RATE in the GRC ITEM category is showing an incorrect decimal value. 2.18 In the Retail - Sales Person report, salespersons who were either created or modified by a POS user are not being displayed. 2.19 In #Profit&Loss (Tabular)# Report Wrong Text Footer showing. 2.20 Item_Tax_Rate is showing wrong in SRI Item and TRIN Item category . 2.21 Data not showing in #Goods Return Challan - Adhoc# report for MS-CO-OM-TS site type. 2.22 Item_net_amount' and 'taxable_amount' is showing blank in TR-OUT DC ITEM BATCH if 'item_charge_amount' is null. 2.23 Order_Qty field is showing wrong in Purchase Order tracking Detail Register Report. 2.24 Charge name is not showing in SI Item Charge category. 2.25 Opening Balance is showing zero in #Sub Ledger Monthly# and #Sub Ledger Monthly - Linked# 2.26 L2_DC_NO and L2_DC_DATE is not showing for Detail level in Sales Invoice-TR-Out with DC category . 2.27 Age is not showing in #Bill wise Outstanding Analysis# report. 2.28 Batch/Serial Number is repeating on each line for the same item in Sales Invoice Document 2.29 Item Image is not reflecting in scheduled reports. 2.30 Item information is not showing in #Sales Order Planning#report. 2.31 Avg. Bill Value' field is showing wrong data in #Store Performance Report# 2.32 #Sales Credit Note# report showing error while printing . 2.33 The 'Barcode' is not displaying in the generic register reports where the 'Item_name' field is used. 2.34 Type/Inventory Source' field is not showing value in #Inventory Status Ledger# report. 2.35 Barcode function is missing in Postgress. 2.36 Performance issue in #Sales Invoice Ledger Summary# report 2.37 Payment Average' tile is not showing value in #Customer History# report. 2.38 #Sales Order# document report is showing blank, when Destination Site Name is missing in sales order document. 2.39 An error shows, while creating a join between Site MOP with GL Summary CC datasource due to query issue in TV_GL_SUMMARY_CC_01. 2.40 The 'Month From' and 'ASON Month' parameters are not showing months before 'April-24' in #Inventory Movement (Summary)# and #Inventory Valuation# reports. 2.41 Time component is not showing in 'Created On' and 'Last Modified On' fields in 'Job Order Header' and 'Job Receipt Header' category. 2.42 Error showing in report made from 'SRI Item Batch' category:- DbConnect Exception 42P01 2.43 UDF Fields' are not showing in reports made from 'Production Conversion' and Production Conversion Batch datasource 2.44 Data Not coming in Bill Details and Bill Collection category 2.45 Store Goods Return information are not showing in #EMG E-Way Bill Upload Register#.

Compatible POS Release Note - https://ginesysone.atlassian.net/wiki/spaces/GPOS/pages/292356858

Features and Improvements

	ID	Description

	ID	Description
1	79069	New Reports for Audit Trail Module: Admin > Audit Trail > #Audit Trail Enable Register# Admin > Audit Trail > #Audit Trail Enable Legacy Register# Admin > Audit Trail > #Audit Trail Register - Summary# Admin > Audit Trail > #Audit Trail Register - Detail# Enhancement Summary: The Web Report will now display the enable and disable actions of the Audit Module, including those from the Legacy Audit Trail. Additionally, transaction modifications and deletions will be visible at both the summary and detail levels in the Web Report. To see the #Audit Trail Register - Detail# report, copy the Audit Key from the #Audit Trail Register - Summary# report
2	79089	POS Executive Summary Report Restructuring Module: Ginesys POS > Register > #POS Executive Report# Enhancement Summary: The POS Executive Summary Report has now been restructured in the Specific Environment. This is only applicable to the New Reporting Stack.
3	79092	New Data Source for GRC Item wise PI Details Module: Procurement\Transaction\Goods Receive\GRC PI Item Batch Enhancement Summary: A new Data source to show the PI Details of all the GRC Items.
4	81280	Enhancement in MOP Category Visibility Module: Retail\Transaction\POS Bill\Bill MOP Retail\Composite\POS\Bill Collection Enhancement Summary: The MOP data source has been enhanced by establishing a relationship with the MOP Site Assignment, allowing reports to retrieve additional details from the MOP master when needed.

Bug Fixes

	ID	Description	Module

	ID	Description	Module
1	57844	Item Charge level details is not showing in Store GRT Item Batch Category.	Ginesys Web Report> Category >Retail >Transaction >Store Goods Return>Store GRT Item Batch
2	57848	Item Charge level details is not showing in Store GRC Item Batch Category.	Ginesys Web Report> Category > Retail >Transaction >Store Goods Receive > Store GRC Item Batch
3	57849	Item Charge level details is not showing in Store GRT Item Category.	Ginesys Web Report> Category >Retail >Transaction >Store Goods Return>Store GRT Item
4	57863	GST_DOC_NO is not showing in DOCUMENT_NUMBER field for ETL Transaction type(Retail Sale), in GST E-invoice.	Ginesys Web Report>Category>Cross Module>Composite>GST E-invoice
5	60180	IN SO Item category Item_gross_amount and Item_net_amount showing wrong.	Ginesys Web Report>Category>Sales and Distribution>Transaction>Sales Order>SO Item
6	60198	In #Planning Register# report plan qty is showing wrong in header and total section.	Ginesys Web Report>Production>Register>#Planning Register#
7	60209	Receive Type field is showing wrong data in #Purchase Order Tracking Summary# report.	Ginesys Web Report>Procurement>Register>#Purchase Order Tracking Summary#
8	60280	Data showing wrong in #Store Sales Person Performance# report.	Ginesys Web Reports>Ginesys POS>Register>#Store Sales Person Performance#
9	60348	In #Sales Order# document report grand total and amount in words is showing zero if tax not applied.	Ginesys Web Report >Sales And Distribution>Document>#Sales Order#
10	60449	Opening Amount and Closing Amount is showing 0 in Retail POS Session category.	Ginesys Web Report>Category>Retail>Transaction>Store Cash Summary>Retail POS Session
11	60486	In #Goods Receive Challan# report Markup % and Markdown % is showing error when received_RSP is zero or null.	Ginesys Web Report>Procurement>Document>#Goods Receive Challan#
12	60598	The OPENTIME, OPENON, CLOSEDTIME, and CLOSEDON fields in the Retail POS Session category display both date and time values.	Ginesys Web Report>Category>Master>Retail POS Session
13	60608	#Goods Receive Register# report showing wrong data when multiple purchase Invoice created against one GRC.	Ginesys Web Report> Procurement> Register>#Goods Receive Register#
14	62160	#Profit&Loss - Cost Centre (Tabular)# report is showing error while executing-'There are formulas that contain syntax errors. Please fix the errors before continuing.'	Ginesys Web Report>Finance>Financial Statement>#Profit&Loss - Cost Centre (Tabular)#
15	64186	The opening balance is displaying as null, but the closing balance is showing for same month in the Ledger by Month report for a ledger when no transactions are found for the selected month.	Ginesys Web Report> Finance>Register>#Ledger By Month
16	64341	Document report printing logo even though logo print value is "No" in report template.	Ginesys Web Report>Procurement>Document>#Purchase Return# Ginesys Web Report>Sales And Distribution>Document>#Sales Invoice(GST)# Ginesys Web Report>Sales And Distribution>Document>#Delivery Challan# Ginesys Web Report>Inventory>Document>#Miscellaneous Issue# Ginesys Web Report>Procurement>Document>#Purchase Invoice#
17	64342	The Item_TAX_RATE in the GRC ITEM category is showing an incorrect decimal value.	Ginesys Web Report>Category>Procurement>Goods Receive>GRC ITEM
18	64345	In the Retail - Sales Person report, salespersons who were either created or modified by a POS user are not being displayed.	Ginesys Web Report > Category>Ginesys POS > Master > Retail - Sales Person
19	68271	In #Profit&Loss (Tabular)# Report Wrong Text Footer showing.	Ginesys Web Report >Finance >Financial Statement>#Profit&Loss (Tabular)#
20	68339	Item_Tax_Rate is showing wrong in SRI Item and TRIN Item category .	Ginesys Web Report>Category>SalesAndDistribution>Transaction >Sales Return Invoice>SRI Item Ginesys Web Report>Category>SalesAndDistribution>Transaction >Transfer-IN>TR-IN Item
21	68654	Data not showing in #Goods Return Challan - Adhoc# report for MS-CO-OM-TS site type.	Ginesys Web Report >Procurement>Document>#Goods Return Challan - Adhoc#
22	68737	Item_net_amount' and 'taxable_amount' is showing blank in TR-OUT DC ITEM BATCH if 'item_charge_amount' is null.	Ginesys Web Report>Sales and Distribution>Transaction>Transfer Out>TR-OUT DC ITEM BATCH/TR-OUT DC ITEM
23	68749	Order_Qty field is showing wrong in Purchase Order tracking Detail Register Report.	Ginesys Web Report>Procurement>Register> Purchase Order tracking Detail
24	69294	Charge name is not showing in SI Item Charge category.	Ginesys Web Report >Category>Sales And Distribution >Transaction>Sales Invoice >SI Item Charge
25	69316	Opening Balance is showing zero in #Sub Ledger Monthly# and #Sub Ledger Monthly - Linked#	Ginesys Web Report>Finance>Register>#Sub Ledger Monthly#
26	71690	L2_DC_NO and L2_DC_DATE is not showing for Detail level in Sales Invoice-TR-Out with DC category .	Ginesys Web Report>Source>Category>Report Specific>Document>Sales Invoice-TR-Out with DC
27	73489	Age is not showing in #Bill wise Outstanding Analysis# report.	Ginesys Web Report>Finance>Register>#Bill wise Outstanding Analysis#
28	73967	Batch/Serial Number is repeating on each line for the same item in Sales Invoice Document	Ginesys Web Report>Sales And Distribution>Document>#Sales Invoice(GST)#
29	74087	Item Image is not reflecting in scheduled reports.	Ginesys Web Report>Schedule
30	75295	Item information is not showing in #Sales Order Planning#report.	Ginesys Web Report>Sales and Distribution>Report Specific>Sales Order Planning Report
31	78287	Avg. Bill Value' field is showing wrong data in #Store Performance Report#	Ginesys Web Report>Ginesys POS>Register>#Store Performance Report#
32	78622	#Sales Credit Note# report showing error while printing .	Ginesys Web report > Sales And Distribution>Document>#Sales Credit Note#
33	79651	The 'Barcode' is not displaying in the generic register reports where the 'Item_name' field is used.	Ginesys Web Report>Register Reports
34	79753	Type/Inventory Source' field is not showing value in #Inventory Status Ledger# report.	Ginesys Web Report>Inventory>Status>#Inventory Status Ledger#
35	80135	Barcode function is missing in Postgress.	Ginesys Web Report>Extensions>Function>Barcode
36	81022	Performance issue in #Sales Invoice Ledger Summary# report	Ginesys Web Report>Sales And Distribution>Retail Sale>Register>#Sales Invoice Ledger Summary#
37	81158	Payment Average' tile is not showing value in #Customer History# report.	Ginesys Web Report>Sales And Distribution>Register>#Customer History#
38	81406	#Sales Order# document report is showing blank, when Destination Site Name is missing in sales order document.	Ginesys Web Report>Sales And Distribution>Document>#Sales Order#
39	82174	An error shows, while creating a join between Site MOP with GL Summary CC datasource due to query issue in TV_GL_SUMMARY_CC_01.	Ginesys Web Report>Category>Finance>Report Specific>GL Summary CC
40	85055	The 'Month From' and 'ASON Month' parameters are not showing months before 'April-24' in #Inventory Movement (Summary)# and #Inventory Valuation# reports.	Ginesys Web Report>Parameter>Month From Ginesys Web Report>Parameter>ASONMonth
41	85217	Time component is not showing in 'Created On' and 'Last Modified On' fields in 'Job Order Header' and 'Job Receipt Header' category.	Ginesys Web report>Production>Transaction>Job Order>Job Order Header
42	86370	Error showing in report made from 'SRI Item Batch' category:- DbConnect Exception 42P01	Ginesys Web Report>Sales And Distribution>Transaction>Sales Return Invoice>SRI Item Batch
43	82381	UDF Fields' are not showing in reports made from 'Production Conversion' and Production Conversion Batch datasource	Ginesys Web Report>Category>Inventory>Transaction>Conversion>Production Conversion
44	68629	Data Not coming in Bill Details and Bill Collection category	Ginesys Web Report>Category>Retail>Composite>POS>Bill Details Ginesys Web Report>Category>Retail>Composite>POS>Bill Collection
45	82386	Store Goods Return information are not showing in #EMG E-Way Bill Upload Register#.	Ginesys Web Report>Inventory>Register>#EMG E-Way Bill Upload Register#

Release Note 12.26.4

Control

Features and Improvements

New Reports for Audit Trail

POS Executive Summary Report Restructuring

New Data Source for GRC Item wise PI Details

Enhancement in MOP Category Visibility

Bug Fixes

Item Charge level details is not showing in Store GRT Item Batch Category.

Item Charge level details is not showing in Store GRC Item Batch Category.

Item Charge level details is not showing in Store GRT Item Category.

GST_DOC_NO is not showing in DOCUMENT_NUMBER field for ETL Transaction type(Retail Sale), in GST E-invoice.

IN SO Item category Item_gross_amount and Item_net_amount showing wrong.

In #Planning Register# report plan qty is showing wrong in header and total section.

Receive Type field is showing wrong data in #Purchase Order Tracking Summary# report.

Data showing wrong in #Store Sales Person Performance# report.

In #Sales Order# document report grand total and amount in words is showing zero if tax not applied.

Opening Amount and Closing Amount is showing 0 in Retail POS Session category.

In #Goods Receive Challan# report Markup % and Markdown % is showing error when received_RSP is zero or null.

The OPENTIME, OPENON, CLOSEDTIME, and CLOSEDON fields in the Retail POS Session category display both date and time values.

#Goods Receive Register# report showing wrong data when multiple purchase Invoice created against one GRC.

#Profit&Loss - Cost Centre (Tabular)# report is showing error while executing-'There are formulas that contain syntax errors. Please fix the errors before continuing.'

The opening balance is displaying as null, but the closing balance is showing for same month in the Ledger by Month report for a ledger when no transactions are found for the selected month.

Document report printing logo even though logo print value is "No" in report template.

The Item_TAX_RATE in the GRC ITEM category is showing an incorrect decimal value.

In the Retail - Sales Person report, salespersons who were either created or modified by a POS user are not being displayed.

In #Profit&Loss (Tabular)# Report Wrong Text Footer showing.

Item_Tax_Rate is showing wrong in SRI Item and TRIN Item category .

Data not showing in #Goods Return Challan - Adhoc# report for MS-CO-OM-TS site type.

Item_net_amount' and 'taxable_amount' is showing blank in TR-OUT DC ITEM BATCH if 'item_charge_amount' is null.

Order_Qty field is showing wrong in Purchase Order tracking Detail Register Report.

Charge name is not showing in SI Item Charge category.

Opening Balance is showing zero in #Sub Ledger Monthly# and #Sub Ledger Monthly - Linked#

L2_DC_NO and L2_DC_DATE is not showing for Detail level in Sales Invoice-TR-Out with DC category .

Age is not showing in #Bill wise Outstanding Analysis# report.

Batch/Serial Number is repeating on each line for the same item in Sales Invoice Document

Item Image is not reflecting in scheduled reports.

Item information is not showing in #Sales Order Planning#report.

Avg. Bill Value' field is showing wrong data in #Store Performance Report#

#Sales Credit Note# report showing error while printing .

The 'Barcode' is not displaying in the generic register reports where the 'Item_name' field is used.

Type/Inventory Source' field is not showing value in #Inventory Status Ledger# report.

Barcode function is missing in Postgress.

Performance issue in #Sales Invoice Ledger Summary# report

Payment Average' tile is not showing value in #Customer History# report.

#Sales Order# document report is showing blank, when Destination Site Name is missing in sales order document.

An error shows, while creating a join between Site MOP with GL Summary CC datasource due to query issue in TV_GL_SUMMARY_CC_01.

The 'Month From' and 'ASON Month' parameters are not showing months before 'April-24' in #Inventory Movement (Summary)# and #Inventory Valuation# reports.

Time component is not showing in 'Created On' and 'Last Modified On' fields in 'Job Order Header' and 'Job Receipt Header' category.

Error showing in report made from 'SRI Item Batch' category:- DbConnect Exception 42P01

UDF Fields' are not showing in reports made from 'Production Conversion' and Production Conversion Batch datasource

Data Not coming in Bill Details and Bill Collection category

Store Goods Return information are not showing in #EMG E-Way Bill Upload Register#.