Bug 17339

Summary:	[Customer Reports][Statements Activity] - The Partial Payment invoices were not displaying when the cutoff date exceeds the partial payment date of the 30 days.
Product:	ML_DB 64-bit Mac	Reporter:	G.Shivasai <gshiva>
Component:	Customer Reports	Assignee:	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 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