Release Note 12.7.4

Release Date

21st March 2022

HO Version

12.7.4

POS Version

2.7.2

Web Database Compatibility Version

1.16

Features & Enhancements

00

Bug Fixes

35

Navigation

1

105954

 N.A.

105954 Customer/Vendor parameter is not showing more than 100 records in Ledger detail - Cost Centre report

Module:

Finance - Register - Ledger detail - Cost Centre report

Reported Version:

12.7.2      153310

Scenario:

1. Run the report.

2. Observe that Customer/Vendor parameter is not showing more than 100 records.

2

106514

N.A.

106514 Ledger Narration value is not showing in #Sub Ledger Detail# & #Sub Ledger Detail (Printable)# reports

Module:

Finance - Register - #Sub Ledger Detail#

Finance - Register - #Sub Ledger Detail (Printable)#

Reported Version:

12.5.1       140944

Scenario:

1. Run the report.

2. Observe that Ledger Narration value is not showing in the report.

3

106546

N.A.

106546 Online Retail Sale data is not showing properly in report due to time component issue 

Module:

Report > Retail > #E-Commerce Sale Register#

Report > Retail > #Retail Invoice E-Commerce Fulfilled By Seller#

Report > Retail > #Retail Invoice E-Commerce Fulfilled By Marketplace#

Data source Changes - Ginview > LV_RETAIL_SALE

Reported Version:

12.2.2      144513

Scenario:

1. Run the report.

2. Observe that data is not showing properly in the report due to component issue.

4

106549

N.A.

106549 Online retail sale data is not showing properly in the ECOM sale register report due to time component issue

Module:

Report - Retail - #E-Commerce Sale Register#

Report - Retail - #Retail Invoice E-Commerce Fulfilled By Seller#

Report - Retail - #Retail Invoice E-Commerce Fulfilled By Marketplace#

Ginview > LV_ECOM_SALE_HEADER and LV_ECOM_S_HEADER

Reported Version:

12.2.2      145877

Scenario:

1. Run the report.

2. Observe that data is not showing properly in the report due to component issue.

5

106552

N.A.

106552 "ORA-06502: PL/SQL: numeric or value error..." - Error message is showing when selected Subledgers concatenates more than 2000 Char

Module:

Finance - Register - Sub Ledger Detail

Reported Version:

12.6.8       144910

Scenario:

1. Run the report.

2. observe that following error message is being is shown when selected Subledgers concatenates more than 2000 Char - "ORA-06502: PL/SQL: numeric or value error"

6

106626

N.A.

106626 Reference No. is not showing for AP Voucher in #Sub Ledger Detail# & #Sub Ledger Detail (Printable)# reports

Module:

Finance - Register - #Sub Ledger Detail#

Finance - Register - #Sub Ledger Detail (Printable)#

Reported Version:

12.4.4      140809

Scenario:

1. Run the report.

2. Observe that the Reference No is not showing for AP Voucher.

7

106641

N.A.

106641 "DbConnect Exception ORA-01403: no data found ..." - Error message is showing while trying to run the report

Module:

Inventory - Status - Inventory Status Summary-Image wise

Reported Version:

12.6.6      149695

Scenario:

1. Run the report.

2. Observe that the following error message is being shown - "DbConnect Exception ORA-01403: no data found..."

8

106650

N.A.

106650 Wrong name is for Joining Column is showing in Conversion Split report

Module:

Web reports > Inventory > Conversion Split 

Data Source - Ginview > View > LV_CONVERSION_SPLIT 

Reported Version:

12.6.4      149793

Scenario:

1. Run the report.

2. Observe that wrong name is for Joining Column is showing.

9

106653

N.A.

106653 Some of the records are not showing in  #Retail Invoice Franchise Secondary Sale# report due to time component issue

Module:

Web reports - Sales & Distribution - Retail - #Retail Invoice Franchise Secondary Sale#

Data Source - Ginview > View > LV_ECOM_S_HEADER 

Reported Version:

11.153.6   148399

Scenario:

1. Run the report.

2. Observe that some of the records are not showing in the report due to time component issue.

10

106665

N.A.

106665  Cheque No, Cheque Date & Drawn On are not showing in  #Sub Ledger Detail (Printable)# report

Module:

Finance - Register -  #Sub Ledger Detail (Printable)# 

Reported Version:

12.6.4      141381

Scenario:

1. Run the report.

2. Observe that Cheque No, Cheque Date, Drawn On are not showing.

11

106804

N.A.

106804 "ORA-12899: value too large for column..." - Error message is showing when particular column length is more than a few hundred

Module:

Finance - Register - Ledger Summary - ledger detail linked report

Reported Version:

12.6.3      158745

Scenario:

1. Run the report.

2. Observe that the following error message is being shown when when particular column length is more than a few hundred - "ORA-12899: value too large for column..."

12

106811

N.A.

106811 Purchase Invoice entry is showing wrong Net Amount in Composite GST report

Module:

Finance - Register - Composite GST report

Reported Version:

12.6.12    156851

Scenario:

1. Run the report.

2. Observe that the Purchase Invoice entry is showing wrong Net Amount.

13

106828

N.A.

106828 "DBConnect Exception ORA-01722 invalid number at WebReports ... " _ Error message is showing while trying to run the Agent Commission report

Module:

Sales & Distribution - Register - Agent Commission report

Reported Version:

12.6.12    159935

Scenario:

1. Run the report.

2. Observe that the following error message is being displayed - "DBConnect Exception ORA-01722 invalid number at WebReports ...".

14

106831

N.A.

106831 Bill wise outstanding report is showing blank where 'Include zero balance' is set to 'False'

Module:

Finance - Register - Bill wise outstanding

Reported Version:

12.6.12    159893

Scenario:

1. Run the report.

2. Observe that report is showing blank where 'Include zero balance' is set to 'False'.

15

106834

N.A.

106834 Sale Stock Valuation Analytic report showing 'Store' as the only stockpoint in the POS outlets

Module:

Ginesys Launchpad - POS Utilities - Analytics Designer > Sale Stock Valuation Analytic Report

Reported Version:

12.7.0              152386

Scenario:

1. Run the report.

2. Observe that the report is showing 'Store' as the only stockpoint in the POS outlets.

16

106841

N.A.

106841  Unable To Open Purchase Invoice Document report

Module:

Procurement > Operations > Purchase Invoice document report

Reported Version:

12.7.0            160532

Scenario:

1. Create a Purchase Invoice.

2. Try to run the related document report.

3. Observe that the report cannot be opened.

17

106850

N.A.

106850 "ORA -12899 value too large for column..." - Error message is showing while trying to refresh Retail Sale Summary cube where Customer Name is too long

Module:

Admin - Utility - Cube Manager - Sales & Distribution - Retail Sale Summary

Reported Version:

12.7.0      162956

Scenario:

1. Try to refresh Retail Sale Summary cube.

2. Observe that the following error message is being displayed when Customer Name is too long - "ORA - 12899 value too large for column..."

18

106853

N.A.

106853 Ledger opening balance and closing balance is not showing correct due to wrong sequence in report

Module:

Finance - Register - Ledger Detail

Reported Version:

12.7.0      161484

Scenario:

1. Run the report.

2. Observe that Ledger opening balance and closing balance is not showing correct due to wrong sequence in report.

19

106856

N.A.

106856 Bank report is showing wrong interest calculation for closing balance as it is not showing with previous balance.

Module:

Finance - Register - Interest Calculation - General Ledger

Reported Version:

12.7.1      161613

Scenario:

1. Run the report.

2. Observe that the following error message is showing as wrong interest calculation for closing balance - "DbConnect Exception specified cast is not valid ..."

20

106859

N.A.

106859 "DbConnect Exception ORA - 01722: invalid number....... " - Error message is showing while trying to open Sub ledger Detail Report in Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

Module:

Finance - Register - Bill wise outstanding

Reported Version:

12.6.12    159893

Scenario:

1. Run the report in Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

2. Observe that the following error message is showing "DbConnect Exception ORA - 01722: invalid number.......".

21

106862

N.A.

106862 Agent parameter is showing twice in the parameter selection list

Module:

Finance - Register - Sub ledger Detail Report

Reported Version:

12.7.1      161146

Scenario:

1. Open the Parameter selection window.

2. Observe that the agent parameter is showing twice in the parameter selection list.

22

106865

N.A.

106865 Agent parameter is not working properly and showing other sub ledgers which are not related to the selected agent

Module: 

Finance - Sub ledger Detail 

Reported Version:

12.7.1      160927

Scenario:

1. Run the above report.

2. Observe that the agent parameter is not working properly and showing other sub ledgers which are not related to the selected agent.

23

106868

N.A.

106868 Some details are not showing in Composite GST report for Sales Invoice Entry Type

Module:

Finance - Register - Composite GST Report

Reported Version:

12.7.2      162628

Scenario:

1. Run the report.

2. Observe that the following  details are not showing for Sales Invoice Entry - CP Name, CP Mobile ,CP_PAN,CP_EMAIL not showing.

24

106874

N.A.

106874 Some columns are missing in the Cash Bank Book report 

Module:

Finance - Register - Cash Bank Book

Reported Version:

12.6.10     162653

Scenario:

1. Run the report.

2. Observe that some of the columns are missing.

25

106877

N.A.

106877 Opening Amount is showing wrong in cash bank book report

Module:

Finance - Register - Cash bank book report

Reported Version:

12.7.2      159433

Scenario:

1. Run the report within a certain date range.

2. Observe that the closing amount for the date before the 'From Date' in the range is different from the opening amount of the 'From Date'.

26

106880

N.A.

106880 Running balance showing wrong for single ledger in LEDGER DETAIL COST CENTRE.

Module:

Finance - Register - Ledger Detail Cost Centre

Reported Version:

12.7.2      154842

Scenario:

1. Run the report for a single ledger.

2. Observe that the running balance is showing wrong.

27

106886

N.A.

106886  Sales Invoice & Transfer Out Document report a opening very slow

Module:

Report - Home - Sales and Distribution - Documents - Sales Invoice or Transfer Out

Reported Version:

12.7.2          153700

Scenario:

1. Run the report.

2. Observe that it is taking a lot of time to open.

28

106889

N.A.

106889 Ledger Details - Cost Centre report is opening very slow

Module:

Finance - Register - Ledger detail - Cost Centre report

Reported Version:

12.7.2      153310

Scenario:

1. Run the report.

2. Observe that it is opening very slow.

29

106892

N.A.

106892 Complete adjustment against a debit note is not showing in a Sub Ledger Detail (Printable) report

Module:

Finance - Register - Sub Ledger detail printable

Reported Version:

12.7.2      152054

Scenario:

1. Run the report.

2. Observe that complete adjustment against a debit note is not showing.

30

106895

N.A.

106895 DC item remarks column not found in TR-OUT DC Item

Module:

Custom Reports - Data source Changes

Reported Version:

12.7.2     151049

Scenario:

1. Observe that the DC item remarks column not found in TR-OUT DC Item.

31

106910

N.A.

106910 Bill wise outstanding report showing error at the time opening for a particular scenario where Agent Code column capacity is smaller than SLCode column capacity

Module:

Finance - register - Bill wise outstanding report

Reported Version:

12.7.2           165316

Scenario:

1. Run the above report.

2. Observe that the following error is showing when Agent Code column capacity is smaller than SLCode column capacity - "DbConnect Exception ORA - 01722: invalid number....... "

32

106913

N.A.

106913 Purchase Invoice document report is showing [@0] value in charge detail field when charge is not available in selected term

Module:

Procurement - Purchase Invoice - Document report 

Reported Version:

12.7.2      165985,165984

Scenario:

1. Run the report.

2. Observe that it is showing [@0] value in charge detail field when charge is not available in selected term.

33

106921

N.A.

106921 "Error - Error in the application ..." -  Error message is showing while opening Bill wise outstanding report in Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production version for particular scenario 

Module:

Finance - Register - Bill wise outstanding report

Reported Version:

12.7.2      165631

Scenario:

1. Run the report in Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production version.

2. Observe that the following error message is showing  for particular scenario - "Error - Error in the application ..." 

34

106924

N.A.

106924 Composite GST report showing wrong Net Entry value for retail sale type entry and POS bill type entry

Module:

Finance - Register - Bill wise outstanding report

Reported Version:

12.7.2      165631

Scenario:

1. Run the report in Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production version.

2. Observe that the following error message is showing  for particular scenario - "Error - Error in the application ..."

35

106927

N.A.

106927 Service Charge Analysis cube is showing only current financial year's data instead of all the available data of any year

Module:

Admin - Utilities - Procurement - Cube manager > Service Charge Analysis

Reported Version:

12.7.2      

Scenario:

1. Go to Cube Manager.

2. Observe that Service Charge Analysis cube is showing only current financial year's data instead of all the available data of any year.