Bug 19419 - [Customer Reports][Customer Statements-Open Invoices] - The Finance Charge which is fully paid should not be display in the customer statements-open invoices report.
Summary: [Customer Reports][Customer Statements-Open Invoices] - The Finance Charge wh...
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 All
: High Major
Assignee: G.Shivasai
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-05-01 10:11 IST by G.Shivasai
Modified: 2026-05-07 18:29 IST (History)
2 users (show)



Attachments

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