Bug 21619

Summary: [Report-Transaction journal]- Recurring Transaction Filtering Issues
Product: ML DB 64-bit Mac 2027 Reporter: Nandhini <bnandhini>
Component: Transaction JournalAssignee: Nandhini <bnandhini>
Status: RESOLVED FIXED QA Contact:
Severity: Medium    
Priority: Medium CC: btadepalli
Version: 27.0.0 Ver-03   
Target Milestone: ---   
Hardware: MAC   
OS: All   

Description Nandhini 2026-09-21 13:30:02 IST
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
Comment 1 Bhavani 2026-09-22 18:15:30 IST
#1 & #2 - Resolved