here is a sample on how to create a Saved Search that computes the number of days a Transaction Record is Open. This will help the us to be able to check which of the Transactions are already aging.
This can be done by using a formula to the Saved Search that will be created.
1. Navigate to Lists > Search > Saved Searches > New
2. Click Transaction
3. Search Title: Enter Title
Example: Aging Transactions
4. Click Criteria
5. Click Standard
6. Filters:
Note: Always click Add once Filter selected and adjusted as needed.
1. Select Formula (Numeric)
§ Formula: Enter CASE WHEN ROUND(({today} - {datecreated}),0) = x then 1 end
Note: X can be changed according to the desired number of days to be displayed.
2. Click Add
7. Click Preview or Save
Note: Make Save & Run option appear when hover over the arrow-down icon next to the Save button.
Feel free to share us about your thoughts and tips 😊