Sunday, October 28, 2018

Create a saved search which compares transaction date and revenue recognition start date

1. Navigate to Lists > Search > Saved Searches > New.

2. Click Transaction.

3. In the Criteria subtab > Standard, add the following filters:

- Type any of Sales Order, Cash Sale, Invoice
- Main Line is false
- Account is Deferred Revenue
4. Go to Results subtab > Columns ans add the following field:

 - Formula (Date)

- Formula NULLIF({trandate},{revrecstartdate})
5. In the Sort by set Formula (Date) and mark Descending.

6. Click Preview/Save & Run.

This formula compares trandate and revrecstartdate. If they are equal, then the function returns null. If they are not equal, then the function returns trandate. You can then check the transactions where the Formula (Date) field is not null. Since the results rows are sorted by the Formula (Date) in descending order, the rows listed first will be the ones where the trandate and revrecstartdate are different. You can then check the transactions where the Formula (Date) field is not null.

No comments:

Post a Comment