Bug 22160

Summary: [Transactions][Bank Reconciliation] - BR displays incorrect balance calculations for the Cash Account.
Product: ML DB 64-bit Win Reporter: G.Shivasai <gshiva>
Component: Bank ReconciliationAssignee: Kmaneesh <Kmaneesh>
Status: CONFIRMED --- QA Contact:
Severity: Critical    
Priority: High    
Version: Version-12   
Target Milestone: ---   
Hardware: Windows   
OS: Windows - 11   
Attachments: Here is the attached flat file and database for bug verification.

Description G.Shivasai 2026-11-04 17:39:24 IST 
The calculations for the following fields appear to be incorrect in the Bank Reconciliation (BR) screen:

=> Current Outstanding
=> Revised Bank Balance
=> Ledger Balance
=> Difference

STEPS:
=> Create Few Invoices and Sales and Make Payment for it.
=> Open BR, Select Cash Acct and Observe the balances how calculation is going wrong.

Screenshot:
https://prnt.sc/Cb2u4-nE5Q8u
Comment 1 G.Shivasai 2026-11-04 17:42:45 IST 
Created attachment 3527 [details]
Here is the attached flat file and database for bug verification.
Comment 2 G.Shivasai 2026-11-04 17:52:06 IST 
#2.When clicking the “Get Transactions” button, the balances were calculated incorrectly, and the cursor kept blinking in the “Bank Statement Balance” and “Outstanding Not Entered” fields.

Screen Record:
https://drive.google.com/file/d/1J5Uf78pFGvJVCAGakMH1vbAw0xy1vGlL/view?usp=sharing