Bug 19378 - [Reports][General Ledger] - Issues Identified in GL Report CSV File & Text File.
Summary: [Reports][General Ledger] - Issues Identified in GL Report CSV File & Text File.
Status: CLOSED
Alias: None
Product: ML_DB 64-bit Mac
Classification: Unclassified
Component: General Ledger (show other bugs)
Version: 2026-14.0.22 + 26.0.1 Ver 03
Hardware: MAC All
: High Major
Assignee: G.Shivasai
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-04-28 18:13 IST by G.Shivasai
Modified: 2026-05-07 18:23 IST (History)
1 user (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description G.Shivasai 2026-04-28 18:13:57 IST
Please find the below issues observed in the General Ledger (GL) Report CSV file:

#1. Thousand Separator Formatting:
Amounts are not formatted with thousand separators.
Example: 9510.66 should be displayed as 9,510.66.
https://prnt.sc/BFwt9ymIB8dA


#2. Negative Amount Representation:
Negative values are currently displayed with both a minus sign (-) and brackets. Since brackets already indicate negative amounts, the minus sign should be removed.
Expected format: (9,510.66) instead of (-9,510.66).
https://prnt.sc/fACH4WjJcJSe


#3. Incorrect Treatment of Totals as Ledger Accounts:
Debit/Credit total values and the Ending Balance are being treated as separate ledger accounts. This results in incorrect transaction data and impacts the accuracy of ending balances.
https://prnt.sc/ePcM59BN6nJ3


#4. Unnecessary Display of Transaction Totals:
If only one transaction is assigned to a single ledger account, the "Transaction Totals" and "Net Transactions" sections should not be displayed.
https://prnt.sc/q4HQJXW37ebc


#5. Missing Ending Balance:
The Ending Balance is not being displayed for the last ledger account.
https://prnt.sc/sWDya3h2O_RS
Comment 1 G.Shivasai 2026-04-29 10:21:54 IST
#6.In Text File, Transaction Credits & Ending Balance Credits should not be display in the brackets.

Screenshot:
https://prnt.sc/77ccblilqRE2
Comment 2 G.Shivasai 2026-04-29 10:56:57 IST
#7.In Text File, For the Profit Center GL Report should not display the overall totals.
Screenshot:
https://prnt.sc/M_UV31tj7VNy
Comment 3 Bhavani 2026-04-30 19:11:33 IST
Fixed, Available in next build
Comment 4 G.Shivasai 2026-05-05 11:50:04 IST

#1.REOPEN => Still the issue is there
Screenshot:
https://prnt.sc/DHrUD6hJYEpf

#2.REOPEN => For the Transaction Totals still it displaying the negative sign in the brackets. already a bracket indicates that it is the negative amount.
Screenshot:
https://prnt.sc/4QRHwRr3HLbm


#3.Working fine.
Screenshot:
https://prnt.sc/MgL69nQAB_cn


#4.REOPEN => If only one transaction is assigned to a single ledger account, the "Transaction Totals" and "Net Transactions" sections should not be displayed. This is working fine but 

The ending balance of the ledger ac falling in the Debit column instead it should display in the Balance Column.

Screenshot:
https://prnt.sc/mmsWaw0ETJal


#5.REOPEN => The Ending Balance and its ledger ac is not being displayed for the last ledger account.
Screenshot:
https://prnt.sc/ZQoiNDbJyn1U


#6.REOPEN => Still the issue is exists.
In Text File, Transaction Credits & Ending Balance Credits should not be display in the brackets.

Screenshot:
https://prnt.sc/NiuDEIrrP9Bd


#7.Working fine
Screenshot:
https://prnt.sc/MPIUlmBVcEV-


#8.NEW ISSUE CAME INTO EXISTENCE WHICH IS ALREADY THERE IN PREVIOUS BUILD. REGARDING THIS BUG LOGGED FOR #3. DUE TO THIS ENDING BALANCE DISPLAYS WRONG. BUT NOW #3 IS WORKING FINE BUT

Ending Balance of the ledger ac is taking the value from the credit total. Actually this balance should be calculated as

Opening Balance - Net Transactions = Ending Balance.

Screenshot:
https://prnt.sc/ZgcCi0_2OZ-T
Comment 5 Bhavani 2026-05-05 15:16:18 IST
#1 - #8 bug fixed, Available in next build
Comment 6 G.Shivasai 2026-05-07 11:23:03 IST
Below are the issues few working fine and other few are reopened in the replaced build version-03.


#1. REOPEN => Still the issue is there
https://prnt.sc/adX6z0fMqytX

#2. REOPEN => For the Transaction Totals still it displaying the negative sign in the brackets. already a bracket indicates that it is the negative amount. 
https://prnt.sc/WTGOpnllUL98

#3. Working fine

#4. Working fine
https://prnt.sc/8ezysedPCaWp

#5. Working fine
https://prnt.sc/B4vObdgjUwoh

#6. Working fine
https://prnt.sc/5W6htI4igjvQ

#7. Working fine

#8. REOPEN => Still the Ending Balance is displaying incorrect in the CSV File.

Ending Balance of the ledger ac is taking the value from the credit total. Actually this balance should be calculated as

Opening Balance - Net Transactions = Ending Balance.

https://prnt.sc/qvrzPUVbgBhS

#9. NEW ISSUE: (However it related to the ending balance of the ledger ac)
If only single transaction assigned to the one ledger ac - the ending balance is showing incorrect.
https://prnt.sc/CVBlcEHqXvRV
Comment 7 Bhavani 2026-05-07 12:47:47 IST
in csv we cannot give comma separated value.

Rest of the reported issues are resolved.
Comment 8 G.Shivasai 2026-05-07 18:23:05 IST
#2 #8 & #9 are working fine in the CSV File in replaced build version-03.
Screenshot:
https://prnt.sc/vfTGQ1wHvQAl