Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
NSC | Saved Search to Compute the Number of Days a Transaction is Open
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
Tagged:
0