Saved Searches
I'm going to explain searches in NetSuite by contrasting them with a tool that you likely know very well, Microsoft Excel. Start by going to Lists
| Search
| Saved Search
| New
and select Customer
.
Criteria tab
Let's start at the bottom of the screen with the tabs. The NetSuite Criteria
tab is used to build the query, which is analogous to the advanced filter option in Excel:
Excel filter
The Excel filter of City = 'New York'
is represented as criteria in NetSuite:
Setting up a filter in NetSuite Saved Searches
The Excel custom filter option is equivalent to Use Expressions
in NetSuite. This allows you to build extensive searches using AND
as well as OR
logic, in addition to parentheses. The parentheses must of course balance in order for the search to run properly:
Comparison between Excel Filter and NetSuite Expressions
NetSuite also allows you to base queries on fields in other tables by clicking the filter button and scrolling down to the bottom of the list of filters. Fields...