Bug 17349 - [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.
Summary: [Customer Reports][Customer Statements-Activity Based] - Making of Excess pay...
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 16:51 IST by G.Shivasai
Modified: 2026-05-07 13:51 IST (History)
2 users (show)


Attachments
Screenshot of the Customer Statements - Activity Based (918.67 KB, image/png)
2026-04-27 16:07 IST, G.Shivasai 		Details
Add an attachment (proposed patch, testcase, etc.)

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