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 > Total Amount of Sales Order per Day
Below is a Saved Search you can create to determine the total amount of your Sales Orders per day.
- Navigate to Lists > Search > Saved Searches > New
- Select Transaction
- Rename the Saved Search
- Under the Criteria tab, add the following:
- Type = Sales Order
- Maine Line = True
- Under the Results tab, add the following:
- Field = Amount | Summary Type = Sum
- Field = Formula (Text) | Summary Type = Group | Formula = TO_CHAR({trandate}, 'Day')
- Click Save & Run
- Check the Show in Filter Region checkbox
- Under Available Filters tab, add Date
Result:
For checking, here's the list of the Sales Orders:
I hope this helps! ❤ Feel free to share your own tips and tricks under
Dominica Sevilla - Oracle | OTC / P2P / SCM Guru
Tagged:
0