Bug 19127

Summary: [Customer Reports] – Accounts Receivable (Standard, Aged, and Summary Aged) show incorrect totals, include post-cutoff transactions, and contain typo issue.
Product: ML_DB 64-bit Mac Reporter: Swathi <kswathi>
Component: Customer ReportsAssignee: Swathi <kswathi>
Status: CLOSED ---    
Severity: Medium CC: dharisha, ksagarika
Priority: High    
Version: 2026-14.0.22 + 26.0.1 Ver 03   
Hardware: MAC   
OS: macOS Sequoia   

Description Swathi 2026-04-14 15:16:10 IST 
[Customer Reports] – Customer Reports – Accounts Receivable (Standard, Aged, and Summary Aged) show incorrect totals, include post-cutoff transactions, and contain typo issue.

Description:-
Accounts Receivable report, when a cutoff date is specified, transactions dated after the cutoff date are still being included in the report.

Additionally, the Accounts Receivable total amount is calculated incorrectly.
ScreenShot:-
https://drive.google.com/file/d/1hYqvC3WWJJusv_4oqvyR337xAmg5x-AM/view?usp=sharing

#Issue 2:-
In the Customer Reports, the Accounts Receivable - Aged report has the following issues:

1.The total amount is calculated incorrectly.
2.There is a typo in the label, showing "Accounts Receive" instead of "Accounts Receivable".
Screenshot:-
https://drive.google.com/file/d/1oevvdbFAwIPp6SEWrro4q6dZ04AsOcok/view?usp=sharing

#Issue3:-
The Accounts Receivable - Summary Aged ,The total amount is calculated incorrectly.
Screenshot:-
https://drive.google.com/file/d/19VS5-mw1Fq0BMS419qSAHO0E9_HufRqA/view?usp=sharing
Comment 1 Swathi 2026-04-14 16:17:52 IST 
#Issue 4:-
In the Customer Statement – Activity Based report, transactions up to the specified cutoff date are expected to be displayed, but they are missing.

Steps to Reproduce:-

1.Create multiple invoices across different months in Customer Invoices.
2.Navigate to Customer Reports.
3.Enter a cutoff date and select Customer Statement – Activity Based.
4.Generate the report.

Actual Result:
Transactions dated after the cutoff date are also displayed in the report.

Screenshot:-
https://drive.google.com/file/d/1Y7lMlDqX-K59yNBmzsz8pLgZKS1D_o-3/view?usp=sharing

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

FlatFiles:-
https://drive.google.com/file/d/1CGTdqDhpaOC93m_RiQ7XuZ64xVUAoMaZ/view?usp=sharing
Comment 2 Bhavani 2026-04-25 17:05:08 IST 
Fixed, Available in next build
Comment 3 G.Shivasai 2026-04-27 16:45:15 IST 
#REOPEN => 

#1, #2 & #3 are unable to retest the bugs - Because of the unpaid invoices are not showing in the Account Receivable, Account Receivable-Aged & Summary Aged Reports.

#4. Still the issue is exists.
https://prnt.sc/Y00fzNpsmlUz

#2. Label Typo issue for the Accounts Receivable is updated as expected.
Comment 4 Bhavani 2026-05-04 18:08:15 IST 
Fixed, Available in next build
Comment 5 Bhavani 2026-05-04 18:08:15 IST 
Fixed, Available in next build