Making effective use of NetSuite Global Search

6 March 2014 | BlueBridge One

The effective use of the NetSuite Global Seach function is an important element in the day to day use of NetSuite. Most Users know how to use the Global Search function and use it on a daily basis. However most Users are not aware of some of the special characters that they could use as part of the search string to help filter down the results of the search into a more manageable list.

Below are some of the lesser known special characters to help you when performing a Global Search from your NetSuite dashboard:

Special CharactersUseExampleResult
: or
^
Used to narrow searches down to a specific record type e.g. Leads onlyle:dental or
cu:dental
Would return a list of leads or customers containing the keyword “dental”
OR or
space or
Used to separate keywordsnorth OR south or
north south or
north – south
Would return records containing either “north” or “south”
+Used to include inactive recordscu:dental+Would return a list of leads or customers containing the keyword “dental” including inactive customer records
” “Used to include exact text matches only for keywords and record typescu:”ABC Dental” or

“customer”:XYZ

cu:”ABC Dental” would only return a list of customers with the name “ABC Dental”
%Used as a wildcard in numeric searchesinv:202%Would return a list of invoices starting with 202 e.g. 20210, 20211, 20212 etc.
::Used to show search results in a new tab or windowinv::202%Would return the same list of invoices starting with 202 e.g. 20210, 20211, 20212 etc. but in a new window

Notes

1. If you have enabled the Global Search Customer Prefix Includes Leads and Prospect at Home > Set Preferences then as an example cu: would return all leads, prospects and customers instead of only customers. The same would be true for using pr: for prospects and le: for leads.

2. To always include inactive records in your Global Search results, go to Home > Set Preferences, click the Reporting/Search subtab, and check the Include Inactives in Global and Quick Search box.