Bug 21598

Summary: [Customer Reports][Customer Statements] – Zero-Balance Transactions Not Displayed in Activity-Based Report
Product: ML DB 64-bit Mac 2027 Reporter: G.Shivasai <gshiva>
Component: Customer ReportsAssignee: pmyadav <pmyadav>
Status: CONFIRMED --- QA Contact:
Severity: Major    
Priority: High CC: btadepalli
Version: 27.0.0 Ver-03   
Target Milestone: ---   
Hardware: MAC   
OS: macOS Sequoia   

Description G.Shivasai 2026-09-18 15:31:53 IST
Zero-balance transactions are not displayed in the Customer Statements – Activity-Based Report even when the Zero-Balance Statements checkbox is selected.

STEPS:
=> Create an invoice dated 01/05/2026.
=> Make a payment for the invoice on 01/06/2026.
=> Verify that the transaction balance is 0.00.
=> Navigate to Customer Reports → Customer Statements and select the Activity-Based report.
=> Set the Cutoff Date to 01/04/2026.
=> Check the Zero-Balance Statements checkbox & generate the report.


EXPECTED RESULT:
The zero-balance transaction should be displayed in the report when the Zero-Balance Statements checkbox is selected and the transaction falls within the defined activity period.

The condition for displaying zero-balance transactions is that there must be activity within the 30 days preceding the Cutoff Date.


ACTUAL RESULT:
The zero-balance transaction is not displayed in the report, even though the Zero-Balance Statements checkbox is selected.


As per Multiledger Manual this condition is there:
https://prnt.sc/2MmIUn2xjAwe

Screenshot:
https://prnt.sc/vIWAOGhkgYGi