Bug 18247

Summary: [Customer Reports] - The Invoices which are paid out. It should display in the account receivable report. As per cutoff date changed to the prior to its invoice payment date before.
Product: ML_DB 64-bit Mac Reporter: G.Shivasai <gshiva>
Component: Customer ReportsAssignee: G.Shivasai <gshiva>
Status: CLOSED ---    
Severity: Major CC: dharisha, ksagarika
Priority: High    
Version: 2026-14.0.22 + 26.0.1 Ver 03   
Hardware: MAC   
OS: macOS Sequoia   

Description G.Shivasai 2026-01-13 12:26:43 IST 
[Customer Reports] - The Invoices which are paid out. It should display in the account receivable report. As per cutoff date changed to the prior to its invoice payment date before.

STEPS:
=> Create a customer invoice on 01/01/26.
=> Create a sales journal on 01/13/26.
=> Make payment for both on 01/14/26.
=> Open Customer Reports => Accounts Receivable Report => Set the cutoff date on 01/13/26 = > View the report.
=> The Sales or invoice which is created that data should appear in the account receivable report.
=> If the Cutoff date changed to on payment date 01/14/26. Then the transactions data should not appear. 

NOTE: 
#1. The same issue is for Account Receivable, Accounts Receivable-Aged & Accounts Receivable-Summary Aged.
#2. The Same issue exists in 14.0.20 Version-07 Build too.

Screen Record:
https://drive.google.com/file/d/1PivbWDigDj_WOx518dJMW6yHxsHK3kdG/view?usp=sharing

Screenshot:
https://prnt.sc/QBfJOFOMGwTM
Comment 1 Bhavani 2026-02-24 15:16:05 IST 
Fixed, Available in next build
Comment 2 Nayab 2026-04-09 17:35:40 IST 
Issue still exists.

screen record:
https://drive.google.com/file/d/161JDjLUmzoioCBLn-FOYueeKQg3GtyPN/view?usp=sharing
Comment 3 Bhavani 2026-04-26 22:18:44 IST 
Fixed, Available in next build
Comment 4 G.Shivasai 2026-04-27 16:24:25 IST 
#REOPEN =>

For the unpaid invoices only. The Data is not displaying in Account Receivable, Account Receivable-Aged & Account Receivable-Summary Aged Reports.

Screenshot:
https://prnt.sc/UyW1RNpmJKqU
Comment 5 Bhavani 2026-05-04 17:45:52 IST 
Fixed, Available in next build
Comment 6 Quadeer 2026-05-05 14:54:28 IST 
working fine.

Screenshot:https://prnt.sc/uRF9WLECqU7r