<?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>19127</bug_id>
          
          <creation_ts>2026-04-14 15:16:10 +0530</creation_ts>
          <short_desc>[Customer Reports] – Accounts Receivable (Standard, Aged, and Summary Aged) show incorrect totals, include post-cutoff transactions, and contain typo issue.</short_desc>
          <delta_ts>2026-05-05 14:15:25 +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>macOS Sequoia</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>Medium</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Swathi">kswathi</reporter>
          <assigned_to name="Swathi">kswathi</assigned_to>
          <cc>dharisha</cc>
    
    <cc>ksagarika</cc>
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>72852</commentid>
    <comment_count>0</comment_count>
    <who name="Swathi">kswathi</who>
    <bug_when>2026-04-14 15:16:10 +0530</bug_when>
    <thetext>[Customer Reports] – Customer Reports – Accounts Receivable (Standard, Aged, and Summary Aged) show incorrect totals, include post-cutoff transactions, and contain typo issue.

Description:-
Accounts Receivable report, when a cutoff date is specified, transactions dated after the cutoff date are still being included in the report.

Additionally, the Accounts Receivable total amount is calculated incorrectly.
ScreenShot:-
https://drive.google.com/file/d/1hYqvC3WWJJusv_4oqvyR337xAmg5x-AM/view?usp=sharing

#Issue 2:-
In the Customer Reports, the Accounts Receivable - Aged report has the following issues:

1.The total amount is calculated incorrectly.
2.There is a typo in the label, showing &quot;Accounts Receive&quot; instead of &quot;Accounts Receivable&quot;.
Screenshot:-
https://drive.google.com/file/d/1oevvdbFAwIPp6SEWrro4q6dZ04AsOcok/view?usp=sharing

#Issue3:-
The Accounts Receivable - Summary Aged ,The total amount is calculated incorrectly.
Screenshot:-
https://drive.google.com/file/d/19VS5-mw1Fq0BMS419qSAHO0E9_HufRqA/view?usp=sharing</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>72860</commentid>
    <comment_count>1</comment_count>
    <who name="Swathi">kswathi</who>
    <bug_when>2026-04-14 16:17:52 +0530</bug_when>
    <thetext>#Issue 4:-
In the Customer Statement – Activity Based report, transactions up to the specified cutoff date are expected to be displayed, but they are missing.

Steps to Reproduce:-

1.Create multiple invoices across different months in Customer Invoices.
2.Navigate to Customer Reports.
3.Enter a cutoff date and select Customer Statement – Activity Based.
4.Generate the report.

Actual Result:
Transactions dated after the cutoff date are also displayed in the report.

Screenshot:-
https://drive.google.com/file/d/1Y7lMlDqX-K59yNBmzsz8pLgZKS1D_o-3/view?usp=sharing

DB:-
https://drive.google.com/file/d/1ARTLFhGojM6W_bITZSnZJOvV1gM1ckwm/view?usp=sharing

FlatFiles:-
https://drive.google.com/file/d/1CGTdqDhpaOC93m_RiQ7XuZ64xVUAoMaZ/view?usp=sharing</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>73632</commentid>
    <comment_count>2</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-04-25 17:05:08 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>73812</commentid>
    <comment_count>3</comment_count>
    <who name="G.Shivasai">gshiva</who>
    <bug_when>2026-04-27 16:45:15 +0530</bug_when>
    <thetext>#REOPEN =&gt; 

#1, #2 &amp; #3 are unable to retest the bugs - Because of the unpaid invoices are not showing in the Account Receivable, Account Receivable-Aged &amp; Summary Aged Reports.

#4. Still the issue is exists.
https://prnt.sc/Y00fzNpsmlUz

#2. Label Typo issue for the Accounts Receivable is updated as expected.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74191</commentid>
    <comment_count>4</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-05-04 18:08:15 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74192</commentid>
    <comment_count>5</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-05-04 18:08:15 +0530</bug_when>
    <thetext>Fixed, Available in next build</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>74298</commentid>
    <comment_count>6</comment_count>
    <who name="Swathi">kswathi</who>
    <bug_when>2026-05-05 14:15:25 +0530</bug_when>
    <thetext>Issue 1 , 2 ,3 &amp; 4are working fine

Screenshot1:-
https://drive.google.com/file/d/1cXsR7t9Z-6CMvv-FMVA-vTbeFL7RV-Nc/view?usp=sharing
Screenshot2:-
https://drive.google.com/file/d/1vEvL4aSlSgLF5Fc0yXd7Lcvfm6Gw6sGB/view?usp=sharing
Screenshot3:-
https://drive.google.com/file/d/1TUnac0EokJpOb38kLo1dzh3hNzPyPl0T/view?usp=sharing
Screenshot4:-
https://drive.google.com/file/d/12moQBYKYKB0xlE93n8nlfvMVKN4ZqwON/view?usp=sharing
Screenshot5:-
https://drive.google.com/file/d/16wXFJV0KL5Wzn6bRAC9Nuidvq1hRXUzF/view?usp=sharing</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>