Bug 17339 - [Customer Reports][Statements Activity] - The Partial Payment invoices were not displaying when the cutoff date exceeds the partial payment date of the 30 days.
Summary: [Customer Reports][Statements Activity] - The Partial Payment invoices were n...
Status: CLOSED
Alias: None
Product: ML_DB 64-bit Mac
Classification: Unclassified
Component: Customer Reports (show other bugs)
Version: 2026-14.0.22 + 26.0.1 Ver 03
Hardware: MAC macOS Sequoia
: High Major
Assignee: G.Shivasai
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-11 15:09 IST by G.Shivasai
Modified: 2026-05-07 11:30 IST (History)
2 users (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description G.Shivasai 2025-11-11 15:09:29 IST
[Customer Reports][Statements Activity] - The Partial Payment invoices were not displaying when the cutoff date exceeds the partial payment date of the 30 days.

STEPS TO REPRODUCE:
=> Create a Invoice on 5th month of the 11th day and make partial payment on same month of 13th day.
=> Open Customer Reports, Select the Customer Statements-Activity based report
=> Set the cutoff date to the current date and view the report for the partial payment done and remaining charged is not displayed.
=> When the cutoff date changed to the 31st day of the 5th month then it displays.


Screenshot:
https://drive.google.com/file/d/1er1EIZlM6iKgzX5HJTaYlrfSlfhzM160/view?usp=sharing
Comment 1 Bhavani 2025-11-13 12:21:05 IST
Verify in the given build
Comment 2 G.Shivasai 2025-11-13 13:06:36 IST
#REOPEN => 
The partial payment invoice and its 30 days condition is working fine But its remaining left over unpaid amount is displaying  as full charged amount instead it should display partial charged left over amount from the overall amount when the cutoff date exceed the 30 days condition.

Screenshot:
https://prnt.sc/AP0FWEHPMn7C
Comment 3 Bhavani 2025-11-17 00:32:06 IST
As per the dates if we see db program is showing correct. I think in the flat file only there is issue. With the tester and PS team tomorrow we will discuss.
Comment 4 Bhavani 2026-05-04 19:11:49 IST
Please verify this in the coming build
Comment 5 G.Shivasai 2026-05-05 15:52:01 IST
#REOPEN => Still the issue is exists…

The partial payment invoice and its 30 days condition is working fine But its remaining left over unpaid amount is displaying  as full charged amount instead it should display partial charged left over amount from the overall amount when the cutoff date exceeds the 30 days condition.

Screenshot:
https://prnt.sc/1k_nZt4zQpG-
Comment 6 Bhavani 2026-05-06 17:56:42 IST
Fixed, Available in next build
Comment 7 Nandhini 2026-05-07 11:30:35 IST
Working as expected in the replaced build 26.0.1-03
https://prnt.sc/ckLCo05_Ne4h