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