Bug 17281 - Customer Statement - Activity Based :-In the Customer Statement - Activity Based report, when partial payments are made, the corresponding values are not displaying.
Summary: Customer Statement - Activity Based :-In the Customer Statement - Activity Ba...
Status: CLOSED
Alias: None
Product: ML_DB 64-bit Mac
Classification: Unclassified
Component: Customer Reports (show other bugs)
Version: 14.0.22 Ver-02
Hardware: MAC Mac OS - 64 Bit
: High Major
Assignee: Priyanka
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-10-28 18:33 IST by Priyanka
Modified: 2026-05-07 17:43 IST (History)
2 users (show)



Attachments
In the Customer Statement - Activity Based report, when partial payments are made, the corresponding values are not displaying. (70.94 KB, image/jpeg)
2025-10-28 18:33 IST, Priyanka
Details

Note You need to log in before you can comment on or make changes to this bug.
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