Bug 21639

Summary: [Transactions][Bank Reconciliation] - When giving Cutoff date in Feb month 2025. I observed Ledger Balance & Difference Balances issue in BR.
Product: ML DB 64-bit Mac 2027 Reporter: G.Shivasai <gshiva>
Component: Bank ReconciliationAssignee: Bhavani <btadepalli>
Status: CONFIRMED --- QA Contact:
Severity: Major    
Priority: High CC: pmyadav
Version: 27.0.0 Ver-03   
Target Milestone: ---   
Hardware: MAC   
OS: macOS Sequoia   

Description G.Shivasai 2026-09-21 18:08:59 IST
[Transactions][Bank Reconciliation] - When giving Cutoff date in Feb month 2025. I observed Ledger Balance & Difference Balances issue in BR.

STEPS:
=> Add the Cascade Auto Electric Customer DB:
=> Open BR => Set Cutoff Date 02/01/25 and 02/28/25
=> Observe the Ledger Balance & Difference Balances issues.

Screenshot:
https://prnt.sc/QJVlqr9n_9AV
https://prnt.sc/Vo2vsFuntFku

DB:
https://drive.google.com/file/d/1nRonBkV_APO8CyeCt70-qy5DqkLZX3j8/view?usp=sharing

NOTE:This issue exists in 14.0.25 & 26.0.4 Version-04 Applications too.
Comment 1 G.Shivasai 2026-09-23 11:43:20 IST
#2.The Same issue is exists for the month of February 2026 too. Below are the steps for bug verification.

STEPS:
=> Create 3 Sales Journal Transactions in the month of January 2026.
=> Create 1 Sales Journal Transactions in the month of February 2026.
=> Open BR. Select AR Acct and give the cut off in the month of February 2026.
=> The Ledger balance will split the feb month entered transaction into difference field.

Screenshot:
https://prnt.sc/pxauFuYnCcBs


#3.After Payment verify the Cash Acct in BR.

STEPS:
=> After Payment of the 4 Sales Journal Transaction in their respective months.
=> Open BR then Select Cash Ac and set the cutoff date in the month of February 2026.
=> Observe the Ledger Balance is splitted into difference field.

Screenshot:
https://prnt.sc/S8-R2uvgbybd

NOTE: 
=> This issue is occurs across all transactions which are done in this scenario.
=> This issue exists in 14.0.25 & 26.0.4 Version-04 Applications too.

DB:
https://drive.google.com/file/d/1H2-TDQ9kk_bKDo-DBXUbb06ZUAxFaDjq/view?usp=sharing