Bug 13586

Summary: [Customer Reports][Customer Statements_Activity Based] - Invoices which are paid. Those are displaying in activity based dropdown. Actually it should be display upto 30 days prior to the cutoff date.
Product: ML_DB 64-bit Mac Reporter: G.Shivasai <gshiva>
Component: Customer ReportsAssignee: 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 reopened bug
Screenshot of the Customer Statements - Activity Based

Description G.Shivasai 2024-11-15 13:14:18 IST
[Customer Reports][Customer Statements_Activity Based] - Invoices which are paid. Those are displaying in activity based dropdown. Actually it should be display upto 30 days prior to the cutoff date.

Screenshot:
https://prnt.sc/LIXP8E-KEF52
https://prnt.sc/L-EgceQMo2H_
Comment 1 Bhavani 2024-11-15 19:41:21 IST
Fixed, Available in next build
Comment 2 G.Shivasai 2024-11-19 13:34:01 IST
Still Issue Exists.

Invoices which are payment done it should display those data upto 30 days prior to the cutoff date.

Screenshot:
https://prnt.sc/YGotCRiGORcT
Comment 3 Bhavani 2025-02-25 18:35:32 IST
Verify in the given build
Comment 4 Quadeer 2025-04-03 12:28:15 IST
The issue still exists. Invoices with completed payments should display data for up to 30 days prior to the cutoff date.

Screenshot: https://prnt.sc/0Qh1eMDrMyBm
Comment 5 Bhavani 2025-09-30 19:00:29 IST
Fixed, Available in next build
Comment 6 saikumar 2025-10-15 11:43:39 IST
Still, the issue was there. The payment made transactions are not showing.

Screenshot:
https://drive.google.com/file/d/1KchE08CDZ8Nu-z6ifp2mewb1omlGE80r/view?usp=sharing
Comment 7 G.Shivasai 2025-10-15 11:52:10 IST
#REOPEN =>
After payment of invoice. Customer Statements_Activity Based Report displays empty. Due to this we unable to verify the above bug its stated condition upto 30 days prior to the cutoff date.

Screenshot:
https://prnt.sc/wEnXnyedTx_f
Comment 8 Bhavani 2025-10-23 00:18:48 IST
Fixed, Available in next build
Comment 9 Bhavani 2025-10-23 00:18:48 IST
Fixed, Available in next build
Comment 10 G.Shivasai 2025-10-25 12:33:15 IST
Created attachment 3132 [details]
Screenshot of the reopened bug

#REOPEN => Still the issue is there.

Invoices which are paid and charged should only display upto 30 days prior to the cutoff date. But here after 31 days and above days also the report is showing. It should not display as per 30days prior to the cutoff date condition.
Comment 11 Bhavani 2025-11-03 00:11:27 IST
Fixed, Available in next build
Comment 12 G.Shivasai 2025-11-10 13:21:23 IST
#REOPEN => 
During retesting this bug. This 30 days condition its working like month end 30th day but It should work like from the payment done date and its prior to cutoff date between the 30 days should be there. Upto 30 days the payment done and charged both should display after the 30 days crossing the both charged and payment done should not display in the activity report.

Screenshot:
https://drive.google.com/file/d/1iRmRHx0AcKFzMywoSX1zH6J0uk5o9lRI/view?usp=sharing
Comment 13 Bhavani 2025-11-13 10:19:31 IST
Fixed, Available in next build
Comment 14 G.Shivasai 2025-11-13 12:22:44 IST
The 30days Condition is working fine for the paid invoice. But Invoice which is charged and payment done that also need not to display when the 30 days condition is exceed.

Screenshot:
https://prnt.sc/kZhpGPW9pY9Y
Comment 15 Bhavani 2025-11-14 13:09:53 IST
Fixed, Available in next build
Comment 16 G.Shivasai 2025-11-17 12:52:29 IST
#REOPEN => Still, the same issue is exists - 

The 30days Condition is working fine for the paid invoice. But Invoice which is charged and payment done that also need not to display when the 30 days condition is exceed.

Screenshot:
https://prnt.sc/kZhpGPW9pY9Y
Comment 17 Bhavani 2026-04-26 20:30:55 IST
Fixed, Available in next build
Comment 18 G.Shivasai 2026-04-27 15:10:53 IST
Created attachment 3390 [details]
Screenshot of the Customer Statements - Activity Based

Still, The Issue is exists - 30 days prior to the cutoff date condition is not met and displaying the data after 30 days condition is exceeded.
Comment 19 Bhavani 2026-05-04 18:28:06 IST
Verify in the coming build
Comment 20 G.Shivasai 2026-05-05 15:18:09 IST
#REOPEN => Still this issue is exists.

According to the cutoff date the paid data is not displaying and its 30 days condition is fine but issue is with the charged amount data and the before cutoff date to payment date having issues.

After 30 days condition from the payment date to the cutoff date is exceeded. Then the invoice data which is charged it should not display in the report.

NOTE: If a invoice is paid and the cutoff date exceeds the 30 days condition both charged and paid data will no longer display in the report.

If the cutoff date placed before the payment date also. this paid data should not be display in the report.

Screenshot:
https://prnt.sc/h2Ccuycrm9YM
https://prnt.sc/2w7Vbw062ejC
Comment 21 Bhavani 2026-05-06 17:55:44 IST
Fixed, Available in next build
Comment 22 Nandhini 2026-05-07 11:56:33 IST
After 30 days of the payment being charged, the invoice report is showing empty; it's working as expected
screenshot:
https://prnt.sc/HyX6W-Avq-w5
https://prnt.sc/nX1lg_mmU6cE