Search Formula Examples and Tips

Review the following topics for hints about how other users have defined search formulas:

Including Line Numbers in Transaction Searches
Referencing Field IDs
Avoiding Divide By Zero Errors
Using Joined Search Field Values
Retrieving the Day of the Week for a Date on a Custom Record
Displaying the Percentage Variance between Custom Record Values
Calculating Days Remaining Until Task Complete
Displaying Multiplier from Cost to Base Price for Items
Comparing Summed Amounts Across Two Fiscal Years for Transactions
Finding the Most Recent Record Updater
Calculating Days a Sale Is In Effect
Referencing System Notes Records
Calculating Time Taken to Approve Orders

For other search examples, see Saved Search Examples.

For details about supported SQL functions, see SQL Expressions. For tables of NetSuite field IDs you can refer to SuiteScript Supported Records.

Important:

If you have examples or tips that you think other users may find helpful, please submit them to the NetSuite User Group's 100 Ways to Use Formula Fields thread.

Important:

Field values in formula definitions can change based on a user's language preference. For example, if you create a formula for a saved search using an English field value and someone runs the search with a different language setting, the search results may be different. To make sure everyone sees the correct results, always use internal field IDs when building formula definitions. This way, the results stay consistent no matter the user's language settings.

Related Topics