Release Note 12.13.1 - 2.13.1

Release Date

21 February 2023

HO Version

12.13.1

POS Version

2.13.1

Web Database Compatibility Version

1.18

Features & Enhancements

5

Bug Fixes

25

Navigation

1

107442

GIN-1638-1

107442  The following existing Web Reports Data Source Categories have been enhanced with new UDF columns

Module:

Ginesys Web > 03-Inventory > 02-Transaction > Conversion > Bundle Conversion

Ginesys Web > 03-Inventory > 02-Transaction > Conversion > Production Conversion

Ginesys Web > 03-Inventory > 02-Transaction > Conversion > Split Conversion

Ginesys Web > 02-Finance > 02-Transaction > AR-AP Journal

Ginesys Web > 02-Finance > 02-Transaction > Finance Voucher

Ginesys Web > 02-Finance > 02-Transaction > General Journal

Ginesys Web > 02-Finance > 02-Transaction > General Journal

Ginesys Web > 06-Retail > 02-Transaction > GV Issue Journal

Ginesys Web > 07-Production > 02-Transaction > WIP Clearance > WIP Clearance Header

Ginesys Web > 04-Procurement > 02-Transaction > Purchase Credit Note > PCN Header

Ginesys Web > 04-Procurement > 02-Transaction > Purchase Debit Note > PDN Header

Ginesys Web > 04-Procurement > 02-Transaction > Purchase Service Debit Note > PSDN Header

Ginesys Web > 04-Procurement > 02-Transaction > Service Order > SRVO Header

Ginesys Web > 05-Sales and Distribution > 02-Transaction > Sales Credit Note > SCN Header

Ginesys Web > 05- Sales and Distribution > 02- Transaction > Sales Debit Note > SDN Header

Ginesys Web > 05- Sales and Distribution > 02 - Transaction > Service Invoice > SRV Sale Header

Ginesys Web > 02- Finance > 02- Transaction > TDS Journal

Ginesys Web > 02- Finance > 02- Transaction > TDS Reversal

Ginesys Web > 05- Sales and Distribution > Transaction > Transfer Order > TO Header

Ginesys Web > 05- Sales and Distribution > Transaction > Transfer-IN > TR-IN Header

Enhancement Summary:

UDF columns have been added in existing Data Source Categories to have more information during report development.

2

107504

GIN-1639-1

107504  A new report has been introduced with the name #Barcode Print Log Register#

Module:

Ginesys Web > Inventory > #Barcode Print Log Register#

Enhancement Summary:

A new report named #Barcode Print Log Register# has been introduced. This Report will display Barcode Printing Log, considering printing time and number of barcodes printed and it will also help to audit barcode printing process.

3

107835

GIN-1642-1

107835  A New report has been introduced with the name #Store Pay-In and Pay-Out#

Module:

Ginesys POS > Register > #Store Pay-In and Pay-Out#

Enhancement Summary:

A new report named #Store Pay-In and Pay-Out# has been introduced. This report will display store wise Pay-In and Pay-Out details.

4

107852

GIN-1643-1

107852 Existing Web Report # Retail Sale Stock # has been enhanced 

Module:

Ginesys Web > Sales & Distribution > Retail Sale > #Retail Sale & Stock#

Enhancement Summary:

A new parameter named 'Consider Sale' has been added. It will display three options - All, Retail Online and Retail Offline.

5

108004

GIN-1649-1

Existing Web Report Data Source Category Retail Customer has been enhanced with new columns 

Module:

Ginesys Web > 01 - Master > Retail Customer 

Enhancement Summary:

The following columns have been added in Existing Data Source Category Retail Customer to have more information during report preparation. It will display country wise ISD code details.

Columns are: ISD_COUNTRY, ISD_CODE

1

105985

 N.A.

105985  Incorrect data was showing in POS Customer Outstanding Analytics & Fixed report in case of Global Credit Note adjustment 

Module:

POS > Analytics > POS Customer Outstanding

POS> Fixed Report > Customer Outstanding

Reported Version:

12.4.6      128894

Scenario:

1. Run the report.

2. Observed that in case of Global Credit Note adjustment POS Customer Outstanding Analytics and Fixed report were showing incorrect data.

2

106948

N.A.

106948  Incorrect balance amount was showing in POS Customer Outstanding Report into the un-adjustment section

Module:

POS > Back office > report > POS Customer Outstanding Report 

Reported Version:

12.7.4       149760

Scenario:

1. Run the report.

2. Observe that incorrect balance amount was showing in POS Customer Outstanding Report into the un-adjustment section.

3

107015

N.A.

107015  Batch Schedule was not working for #Purchase Return# document report

Module:

Ginesys Web > Procurement > Document  > #Purchase Return# 

Reported Version:

12.7.4         168268

Scenario:

1. Run the report.

2. Observe that Batch Schedule was not working for #Purchase Return# document report.

4

107099

N.A.

107099 Opening Value of Customer Outstanding Statement(POS) report and POS Customer Outstanding(HO-Web) report were not matching

Module:

Ginesys Web > Ginesys POS > Register > # POS Customer Outstanding Report #

Reported Version:

12.8.3        172837

Scenario:

1. Run the report.

2. Observe that Opening Value of Customer Outstanding Statement(POS) report and #POS Customer Outstanding#(HO-Web) report were not matching.

5

107105

107105   Component icode and quantity were not showing in the profit and Loss ledger report

Module:

Ginesys Web > Finance  > Financial Statement > Profit & loss and Profit & Loss tabular

Reported Version:

12.8.3       186202

Scenario:

1. Make a custom report with this data source. 

2. Run this report.

3. Component icode and qty not showing.

6

107299

N.A.

107299  #The Store Sales Dashboard# report was showing overlapped data while viewing the Last 30 days Sales Trend

Module:

Ginesys Web > Ginesys POS > Dashboard >  #Store Sales Dashboard#

Reported Version:

12.10.2       190635

Scenario:

1. Run the report.

2. Observe that #The Store Sales Dashboard# report was showing overlapped data while viewing the Last 30 days Sales Trend.

7

107423

N.A.

107423  Multiple data was showing in SI header and SI DC Item 

Module:

Ginesys Web  > Server > GINVIEW.LV_SALINV_HEADER

Reported Version:

12.11.1       203012

Scenario:

1. Run the report.

2. Observe that Multiple data were showing due to incorrect Joining was available in SI header and SI DC Item.

8

107428

N.A.

107428  POS customer outstanding report was showing incorrect amount in Un-adjustment section

Module:

Ginesys Web  > Ginesys POS > Register >#POS Customer Outstanding#

Reported Version:

12.11.0       211438

Scenario:

1. Run the report.

2. Observe that POS customer outstanding report was showing incorrect amount in Un-adjustment section.

9

107519

107519 Untagged ledgers were not showing in #Budget Variance Analysis# report 

Module:

Ginesys Web  > Finance > Register > #Budget Variance Analysis#

Reported Version:

12.11.1       208416

Scenario:

1. Make budget for some of the ledger (Any month from April).

2. Do any transaction for those ledger which are not tagged in budget.

3. Observe that report was not showing value for untagged ledgers.

10

107522

N.A.

107522  Net Retail and Wholesale COGS amount column were showing incorrect data in #Site wise Qty and Amount# report

Module:

Ginesys Web > Inventory > Status > Stock Book > # Site wise Quantity and Amount #

Reported Version:

12.11.6        204907 

Scenario:

1. Make an Sale Entry in HO and POS.

2. Refresh the cube. 

3. Run the report.

4. Observe that Net Retail and Wholesale COGS amount column were showing incorrect data in #Site wise Qty and Amount# report.

11

107528

N.A.

107528  In LV_POS_CN Adjusted by OTP and Manager Details fields were not available 

Module:

Data Source > LV_POS_CN

Reported Version:

12.11.6        193121

Scenario:

1. Observe that in LV_POS_CN Adjusted by OTP and Manager Details fields were not available. 

12

107602

N.A.

107602  Reference Detail was not available in REFDETAILS column of LV_Finance_Voucher

Module:

Data Source > LV_Finance_Voucher > Finance Voucher

Reported Version:

12.11.6      207844

Scenario:

1. Make an AR voucher.

2. Adjust the document and save it.

3. Observe that Reference Detail was not available in REFDETAILS column of LV_Finance_Voucher but adjustment detail was showing in Refdetail column.

13

107813

N.A.

107813  Current year data was not showing into the #Customer History# report

Module:

Ginesys Web > Sales & Distribution > Register > #Customer History#

Reported Version:

12.12.0      219385

Scenario:

1. Run the report.

2. Observe that Current year data was not showing into the #Customer History# Report.

14

107865

107865  Incorrect Plan quantity was showing in #Planning Register# report 

Module:

Ginesys Web > Production Register > #Planning Register# 

Reported Version:

12.9.1         217838

Scenario:

1. Make a working plan with more than one process.

2.  Run the Report.

3. Observe that incorrect Plan quantity was showing in #Planing Register# report.

15

107868

107868  Incorrect opening amount was showing  in #Ledger Summary - Cost Centre# report

Module:

Ginesys Web > Finance > Register > #Ledger Summary - Cost Centre#  

Reported Version:

12.11.5       200961

Scenario:

1. Make two entry in general voucher with same ledger and same cost centre.

2. Run the report.

3. Observe that incorrect opening amount was showing  in #Ledger Summary - Cost Centre# report

16

107879

N.A.

107879  Opening Section Credit Side was showing negative value in #Trial Balance Periodic Report#  and LEV2_DEBIT was mounted in the grand total of the closing credit

Module:

Ginesys Web > Finance > Financial Statement > #Trial Balance Periodic#

Reported Version:

12.12.1      221026

Scenario:

1. Export the #Trial Balance Periodic # Report in Excel.

2.  Click any opening credit balance.

3. Observe that Trial Balance Periodic Report was showing against Opening Section Credit Side.

4.  Duplicate the #Trial Balance Periodic # generic report.

5. Observe that LEV2_DEBIT was mounted in the grand total of the closing credit.

17

107882

107882  Opening amount was showing completely different from the previous closing amount in #Ledger Summary - Cost Center# report

Module:

Ginesys Web > Finance > Register ># Ledger Summary -Cost Centre # Report    

Reported Version:

12.11.6       220425

Scenario:

1. Run the  # Ledger Summary -Cost Centre # Report  for previous financial year and present financial year.

2. Compare the data of these two reports.

3.  Create a Ledger and try to make Opening Ledger Entry .

4. Observe that opening amount was showing completely different from the previous closing amount in #Ledger Summary - Cost Center# report.

18

107920

N.A.

107920  #Cash Bank Book# register report was not showing any opening balance for Ledgers

Module:

Ginesys Web > Finance > Register > #Cash Bank Book# 

Reported Version:

12.11.6      221721

Scenario:

1. Run the report.

2. Observe that #Cash Bank Book Register Report# was not showing any opening balance for Ledgers.

19

107980

N.A.

107980   WAREHOUSE_TRANSFER_IN_QUANTITY and WAREHOUSE_TRANSFER_OUT_QUANTITY were showing 0 in #Stock Book# summary reports

Module:

Ginesys Web Report > Inventory > Status > #Stock Book#

Reported Version:

12.13.0      220846

Scenario:

1. Check data in invstock for WTI and WTO enntyp.

2. Refresh the stock book cube. 

3. Run report.

4. Observe that WAREHOUSE_TRANSFER_IN_QUANTITY and WAREHOUSE_TRANSFER_OUT_QUANTITY were showing 0 in #Stock Book# summary reports.

20

107986

107986  Relation was missing between GINVIEW.LV_STORE_AUDIT_JRN_ITEM and GINVIEW.LV_ITEM

Module:

Ginesys Web Inventory > Register > Retail Operation > #Store Audit Journal#

Reported Version:

12.11.1        206194

Scenario:

1. Run the report.

2. Observe that relation was missing between GINVIEW.LV_STORE_AUDIT_JRN_ITEM and GINVIEW.LV_ITEM.

21

107998

107998  Relation was missing between PV_STOCK_MOVEMENT_NONINV and LV_SITE AND LV_ITEM

Module:

Ginesys Web > Data Source > PV_STOCK_MOVEMENT_NONINV   

Reported Version:

12.3.0        200181

Scenario:

1. Run the report.

2. Observe that relation was missing between PV_STOCK_MOVEMENT_NONINV and LV_SITE AND LV_ITEM.

22

108024

N.A.

108024  Relation was missing between GINVIEW.LV_POS_DEPREF_HEADER and GINVIEW.LV_POS_DEFREF_MOP 

Module:

Ginesys Web > Finance > Ginesys POS > Register > Deposit and Refund Register 

Reported Version:

12.11.6      222041

Scenario:

1. Go to report server.

2.  Search GINVIEW.LV_POS_DEFREF_MOP Object.

3.  Search join between GINVIEW.LV_POS_DEPREF_HEADER and GINVIEW.LV_POS_DEFREF_MOP .

4. Observe that Join was missing between GINVIEW.LV_POS_DEPREF_HEADER and GINVIEW.LV_POS_DEFREF_MOP. 

23

108066

N.A.

108066  EMG GST E-Invoice Utility (Store) report showing cast type error when converting value to number

Module:

POS > POS Analytic > EMG GST E-Invoice Utility (Store)

Reported Version:

12.12.2      211029,169360,192809,204360,211029,211923

Scenario:

1. Run the report.

2. Observe that EMG GST E-Invoice Utility (Store) report showing cast type error when converting value to number.

24

108085

N.A.

108085  Relation was missing between GINVIEW.LV_ARTICLE and GINVIEW.LV_ASSEMBLY_ITEM 

Module:

Ginesys Web > Data Source > GINVIEW.LV_ARTICLE and GINVIEW.LV_ASSEMBLY_ITEM  

Reported Version:

12.9.1       213276

Scenario:

1. Go to Report Server.

2. Search joining between GINVIEW.LV_ARTICLE and GINVIEW.LV_ASSEMBLY_ITEM .

3. Observe that Joining was missing between GINVIEW.LV_ARTICLE and GINVIEW.LV_ASSEMBLY_ITEM. 

25

108094

N.A.

108094   In #Interest Calculation - Bank# report balance was not getting carry forwarded to the next day

Module:

Ginesys Web > Finance > Register >#Interest calculation -Bank#

Reported Version:

12.9.1        210389

Scenario:

1.  Run  #Interest Calculation - Bank# report.

2. Observe that in #Interest Calculation - Bank# report balance was not getting carry forwarded to the next day.