Bug 19419

Summary:	[Customer Reports][Customer Statements-Open Invoices] - The Finance Charge which is fully paid should not be display in the customer statements-open invoices report.
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:	All

Description G.Shivasai 2026-05-01 10:11:03 IST

[Customer Reports][Customer Statements-Open Invoices] - The Finance Charge which is fully paid should not be display in the customer statements-open invoices report as payment done. But before to its payment date the charged amount can display.

STEPS:
=> Create a Invoice or sales and apply finance charge for it and make full payment for it.
=> Open Customer Reports -> Customer Statements-Open Invoices.
=> Finance charges which is paid fully should not be display in the customer statements-open invoices report.

NOTE:- In Very rare scenarios, the invoices which is paid as fully those are displaying as paid in Customer Statements open-invoices report. However we are not able to replicate it again.

Screenshot:
https://prnt.sc/I-JVyKTS_Ayo

Comment 1 Bhavani 2026-05-04 19:16:49 IST

Fixed, Available in next build

Comment 2 Nandhini 2026-05-05 15:01:19 IST

Still showing the fully paid charges applied to invoices and sales in the open-invoice report
screenshot: invoice
https://drive.google.com/file/d/1PxhwBZD1dxs0InCu6wQtSVAOd4jGNJ87/view?usp=sharing
screenshot2: sales
https://drive.google.com/file/d/1aCLOWTjN--_ntHjfTiOAA7PlI2RgPHqZ/view?usp=sharing

Comment 3 Bhavani 2026-05-07 00:28:28 IST

Fixed, Available in next build

Comment 4 Nandhini 2026-05-07 10:32:56 IST

The total paid balances not showing in the open-invoices report but the applied charges in the finance charges screen balances showing In the replaced build 26.0.1-03.
screenshot:
https://drive.google.com/file/d/1IOMtmwHRGg0IFYf90g1AUz8905qHyyQL/view?usp=sharing

Comment 5 Nandhini 2026-05-07 12:25:22 IST

Ignore the above comments, follow the below: replaced build 26.0.1-03

#1. created full payment along with charged amount should not display in open invoice but here for the finance charges applied details are showing
screenshot:
https://drive.google.com/file/d/1GVUHkrSeC2g8E9_7CAQIwDCWr1KmAV2b/view?usp=sharing

#2. 
* creation date 01/11/25
* finance charges apply date 01/11/25
* full payment done date 01/13/25
1. Open report-open invoices select created date - The created invoice details and finance charges details should be display in report but here showing only invoice related missing finance charges data
2. Open with payment done date - The details should not display here showing finance charges data.
3. open with before created invoice date - the finance charges details also missing.
screenshot:
https://drive.google.com/file/d/1srYAkh4Id_ZbTg1HQ2S2Wwcd5uDYvnmg/view?usp=sharing
DB:
https://drive.google.com/file/d/1QVgch2l4XNSCYp3h04rgr4MbwAc7ZHnH/view?usp=sharing

Comment 6 Bhavani 2026-05-07 15:11:28 IST

Fixed, Available in next build

Comment 7 Nandhini 2026-05-07 18:29:03 IST

working as expected
https://prnt.sc/WhdFe-dMbAnm