22160 – [Transactions][Bank Reconciliation] - BR displays incorrect balance calculations for the Cash Account.

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

Importance:	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)
CC List:	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