<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "http://45.127.191.6/bugzilla/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.3"
          urlbase="http://45.127.191.6/bugzilla/"
          
          maintainer="checkmark.bugzilla@checkmark.in"
>

    <bug>
          <bug_id>19419</bug_id>
          
          <creation_ts>2026-05-01 10:11:03 +0530</creation_ts>
          <short_desc>[Customer Reports][Customer Statements-Open Invoices] - The Finance Charge which is fully paid should not be display in the customer statements-open invoices report.</short_desc>
          <delta_ts>2026-05-07 18:29:03 +0530</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>ML_DB 64-bit Mac</product>
          <component>Customer Reports</component>
          <version>2026-14.0.22 + 26.0.1 Ver 03</version>
          <rep_platform>MAC</rep_platform>
          <op_sys>All</op_sys>
          <bug_status>CLOSED</bug_status>
          <resolution></resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>High</priority>
          <bug_severity>Major</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="G.Shivasai">gshiva</reporter>
          <assigned_to name="G.Shivasai">gshiva</assigned_to>
          <cc>dharisha</cc>
    
    <cc>ksagarika</cc>
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>74058</commentid>
    <comment_count>0</comment_count>
    <who name="G.Shivasai">gshiva</who>
    <bug_when>2026-05-01 10:11:03 +0530</bug_when>
    <thetext>[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:
=&gt; Create a Invoice or sales and apply finance charge for it and make full payment for it.
=&gt; Open Customer Reports -&gt; Customer Statements-Open Invoices.
=&gt; 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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74205</commentid>
    <comment_count>1</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-05-04 19:16:49 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74316</commentid>
    <comment_count>2</comment_count>
    <who name="Nandhini">bnandhini</who>
    <bug_when>2026-05-05 15:01:19 +0530</bug_when>
    <thetext>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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74413</commentid>
    <comment_count>3</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-05-07 00:28:28 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74432</commentid>
    <comment_count>4</comment_count>
    <who name="Nandhini">bnandhini</who>
    <bug_when>2026-05-07 10:32:56 +0530</bug_when>
    <thetext>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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74463</commentid>
    <comment_count>5</comment_count>
    <who name="Nandhini">bnandhini</who>
    <bug_when>2026-05-07 12:25:22 +0530</bug_when>
    <thetext>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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74481</commentid>
    <comment_count>6</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-05-07 15:11:28 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74508</commentid>
    <comment_count>7</comment_count>
    <who name="Nandhini">bnandhini</who>
    <bug_when>2026-05-07 18:29:03 +0530</bug_when>
    <thetext>working as expected
https://prnt.sc/WhdFe-dMbAnm</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>