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 | How to create Saved Search for Sales Orders that are created until a specific time of the day?
In cases where users would like to track the Sales Orders records created for the day until a specific time of the day, they can run a Saved Search and use a Formula (Numeric) to achieve it.
Here are the criteria that you Users may add to the Saved Search:
- Date Created = on today
- Formula (Numeric)
Formula = CASE WHEN {datecreated} < TRUNC(sysdate) + 15/24 THEN 1 ELSE 0 END
Formula (Numeric) = equal to
Value = 1
This Saved Search will pull up Sales Orders created within the day before 3:00 PM.
I hope this helps!
Do you have insights and ideas about Saved Searches like this? Comment down below.