Bug 22160 - [Transactions][Bank Reconciliation] - BR displays incorrect balance calculations for the Cash Account.
Summary: [Transactions][Bank Reconciliation] - BR displays incorrect balance calculati...
Status: CONFIRMED
Alias: None
Product: ML DB 64-bit Win
Classification: Unclassified
Component: Bank Reconciliation (show other bugs)
Version: Version-12
Hardware: Windows Windows - 11
: High Critical
Target Milestone: ---
Assignee: Kmaneesh
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-11-04 17:39 IST by G.Shivasai
Modified: 2026-11-04 17:52 IST (History)
0 users

See Also:

Attachments
Here is the attached flat file and database for bug verification. (97.76 KB, application/x-zip-compressed)
2026-11-04 17:42 IST, G.Shivasai 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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