Bug 17281

Summary: Customer Statement - Activity Based :-In the Customer Statement - Activity Based report, when partial payments are made, the corresponding values are not displaying.
Product: ML_DB 64-bit Mac Reporter: Priyanka <mpriyanka>
Component: Customer ReportsAssignee: Priyanka <mpriyanka>
Status: CLOSED ---    
Severity: Major CC: dharisha, ksagarika
Priority: High    
Version: 14.0.22 Ver-02   
Hardware: MAC   
OS: Mac OS - 64 Bit   
Attachments: In the Customer Statement - Activity Based report, when partial payments are made, the corresponding values are not displaying.

Description Priyanka 2025-10-28 18:33:50 IST
Created attachment 3148 [details]
In the Customer Statement - Activity Based report, when partial payments are made, the corresponding values are not displaying.

Note :

Cut-off Date Issue: When a cut-off date is given (for example, 02/01/25), the report should display only the transactions dated 02/01/25. However, the values are not displaying correctly based on the specified cut-off date.
Comment 1 Priyanka 2025-10-29 11:46:44 IST
Note:Invoice created on 01/01/25 and Payment made on 01/02/25 where my cut off date is 01/01/25
Need to display total invoice amount in both the reports

Opted cutoff date as 01/06/2025
Payment details are not displaying in Customer Statements Activity Based.

Screenshot:https://prnt.sc/wP12KX7ZLDXn
Comment 2 Bhavani 2025-11-07 18:24:10 IST
Fixed, Available in next build
Comment 3 Priyanka 2025-11-13 12:35:40 IST
>Still issue is there,Invoice created on 01/01/25 and Payment made on 04/01/25 where my cut off date is 03/01/25.Need to display total invoice amount in both the reports.


screenshot :https://prnt.sc/5b3Zokh-7S-k
Comment 4 Bhavani 2025-11-17 00:32:52 IST
Fixed, Available in next build
Comment 5 Priyanka 2025-11-17 18:02:49 IST
The Statements-Activity report is not subtracting payments made before the cutoff date. For the 02/28/25 report, it should show a remaining balance of 650.00 instead of 1,650.00.

screenshot :https://prnt.sc/22TM39ypsgUy
Comment 6 Bhavani 2026-04-26 20:35:28 IST
Fixed, Available in next build
Comment 7 Priyanka 2026-04-30 09:45:36 IST
The issue still exists, when partial payments are made, the corresponding values are not displaying.


Screenshot :-  https://prnt.sc/bSMF3pCtwAvS
Comment 8 Bhavani 2026-05-04 18:56:16 IST
Fixed, Available in next build
Comment 9 Priyanka 2026-05-06 12:02:34 IST
Screenshot:  https://prnt.sc/QMbvVsYg-qjn


Note:The report is also displaying paid invoice amounts. It should display only unpaid and partially paid invoices.
Comment 10 Bhavani 2026-05-06 19:27:02 IST
Fixed, Available in next build
Comment 11 Priyanka 2026-05-07 17:43:42 IST
Its working fine as expected.

screenshot :https://prnt.sc/xI1y1vpMZJSv