Monday, September 24, 2018

Create Saved Search to Display Transactions Posted in a DifferentPeriod

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