To list transactions posted in a period different from that which transactions dates are supposed to be covered, perform the following:
1. Navigate to Lists > Search > Saved Searches > New.
2. Click Transactions.
3. On Criteria tab and Standard subtab, set the following:
• Posting = T
• Formula (Text) > Formula = DECODE(To_Char({trandate},'Mon YYYY'),{postingperiod},'YES','NO') > Formula (Text) = Start with "NO"
4. On Results tab and Columns subtab, set the following:
• Date
• Period
• Number
• Name
• Formula (Text)= DECODE(To_Char({trandate},'Mon YYYY'),{postingperiod},'YES','NO')
5. Click Save.
No comments:
Post a Comment