<?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>21619</bug_id>
          
          <creation_ts>2026-09-21 13:30:02 +0530</creation_ts>
          <short_desc>[Report-Transaction journal]- Recurring Transaction Filtering Issues</short_desc>
          <delta_ts>2026-09-22 18:15:30 +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 2027</product>
          <component>Transaction Journal</component>
          <version>27.0.0 Ver-03</version>
          <rep_platform>MAC</rep_platform>
          <op_sys>All</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium</priority>
          <bug_severity>Medium</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Nandhini">bnandhini</reporter>
          <assigned_to name="Nandhini">bnandhini</assigned_to>
          <cc>btadepalli</cc>
          
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>82720</commentid>
    <comment_count>0</comment_count>
    <who name="Nandhini">bnandhini</who>
    <bug_when>2026-09-21 13:30:02 +0530</bug_when>
    <thetext>Create transactions in the item PO and payables screen, then save
Create transactions with the same document number on a different date in the same month; one is recurring, the other one normal transaction, then save
Open the TJ report, choose the saved transaction period, then select the last used recurring checkbox.

Issue #1: Period Filter Not Applied to Recurring Transactions
After selecting the last used checkbox, showing all saved recurring entries regardless of the period selection in live, but in the DB, you manually need to select all the period list.

Issue#2: Non-Recurring Transaction Included in Recurring Report.
When the Last Used Recurring checkbox is selected, the report displays both the recurring and non-recurring transactions.
This issue occurs when the recurring and non-recurring transactions have the same document number but are separate transactions.

Screen recording:
https://drive.google.com/file/d/14ch34Ae11Q56q-074aWcK763H-P5ngLL/view?usp=sharing
DB:
https://drive.google.com/file/d/1NVtaqTrJb8pBGjruU4edMkhh7g90sk8F/view?usp=sharing</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>82845</commentid>
    <comment_count>1</comment_count>
    <who name="Bhavani">btadepalli</who>
    <bug_when>2026-09-22 18:15:30 +0530</bug_when>
    <thetext>#1 &amp; #2 - Resolved</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>