Bug 17349

Summary:	[Customer Reports][Customer Statements-Activity Based] - Making of Excess payment for the invoice. The Excess payment amount data is not displaying from prior to the cutoff date crossed 30 days condition.
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
Attachments:	Screenshot of the Customer Statements - Activity Based

Description G.Shivasai 2025-11-11 16:51:32 IST

[Customer Reports][Customer Statements-Activity Based] - Making of Excess payment for the invoice. The Excess payment amount data is not displaying from prior to the cutoff date crossed 30 days condition.

STEPS TO REPRODUCE:
=> Create Invoice and make excess payment for it.
=> Open Customer reports, Select Statements-Activity Based Report.
=> Change the cutoff date it should exceed the 30 days from the payment of invoice prior to the cutoff date.
=> The Balance excess amount is not displaying in the report.


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

Screenshot:
https://drive.google.com/file/d/1H-obHnGLEYSMkdmRyz43s94HVaklGrAI/view?usp=sharing

Comment 1 Bhavani 2025-11-17 01:20:19 IST

Fixed, Available in next build

Comment 2 G.Shivasai 2025-11-17 14:35:12 IST

#REOPEN = > Still, the issue is there in 14.0.20 Version-03.

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

Screenshot:
https://drive.google.com/file/d/1H-obHnGLEYSMkdmRyz43s94HVaklGrAI/view?usp=sharing

Comment 3 Bhavani 2026-04-26 20:34:30 IST

Fixed, Available in next build

Comment 4 G.Shivasai 2026-04-27 16:07:11 IST

Created attachment 3391 [details]
Screenshot of the Customer Statements - Activity Based

This issue has been verified and its working fine. when the cutoff date crossed the 30 days condition from the payment date but 

New issue came into existence - If the cutoff date not crossed over payment date 30 days condition then the way of showing the data is 

Charged amount and excesss paid amount and the balance left over in negative Data is not showing as expected.

Comment 5 Bhavani 2026-05-04 18:30:00 IST

Fixed, Available in next build

Comment 6 G.Shivasai 2026-05-05 16:18:18 IST

#REOPEN =>

Earlier Reported issue which is working fine in the last build. Now, In this build its effected again.

When a Excess Payment is done and verifying the reports in two scenarios.

First One is 30 days Condition crossed the cutoff date with the payment date. The excess which is paid that amount should reflect in the report with negative.
(This issue which is working in last build but In this build the issue is exists again).
Screenshot:
https://prnt.sc/HIPmL2-ofkas


Second one is 30 days Condition not crossed the cutoff date with the payment date.(This is working fine in the current build however last build have the issue)
Screenshot:
https://prnt.sc/OGFBkBtWH3yr

Comment 7 Bhavani 2026-05-06 18:37:47 IST

Fixed, Available in next build

Comment 8 G.Shivasai 2026-05-07 13:51:11 IST

BOTH SCENARIOS ARE WORKING FINE AS EXPECTED IN REPLACED BUILD VERSION-03.

Screenshot:
https://prnt.sc/iShYsdd2EyZE