Friday, December 14, 2018

Alternate Solution in using Age in Weeks function in saved searches

1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Choose Transaction.
3. On the Criteria tab > Standard subtab > set the following Filter:
- Type is Sales Order
4. On the Results tab > Columns subtab > set the following Fields:
- Date
- Document Number
- Name
- Amount
- Formula (Numeric) - Formula: TRUNC(({today} - {trandate})/7)
5. Save & Run.

Note: Sales Order Saved Search is just used as an example to illustrate the Formula for Age in Weeks.

No comments:

Post a Comment