This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello, I'm trying to create a saved search to see Sales orders created by days weeks &amp; months.

The formula i used for weeks is TO_CHAR({trandate}, 'week') &amp; summary type group but get an invalid error. Any suggestions?

There's a Week of Year built-in function that you can set on any date field. Do you need different weeks?

Hey Thanks for the help, much appreciated

i was under the impression i couldn't use the date field to group multiple times on the results.

Hey RJ i have a question regarding a customer saved search any chance you can assist?

I need to create a daily report of how many customers i updated yesterday the sales tax status

Customer search.

Criteria:

• System Notes : Type = Change
• System Notes : Context = UI (assuming you did this in the UI; if not might need to choose CSV if that's the way you did it)
• System Notes : Field = Sales Tax Status
• System Notes : Date = yesterday
• System Notes: Set by = you (optional)
Add all the fields from the System Notes join to the Results tab.