Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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