Wildcards are powerful tools in NetSuite’s Global Search that allow you to search for records using partial information. The most common wildcard in NetSuite is the % symbol.  

How to use wildcards in NetSuite:

1. Access the Global Search Bar: Use the Alt+g (Windows) or Option+g (Mac) shortcut to quickly access the global search bar.  
2. Use the % Wildcard:
   • Beginning of a word: %keyword (e.g., %apple to find records containing “apple” anywhere)
   • End of a word: keyword% (e.g., apple% to find records ending with “apple”)
   • Anywhere in a word: %keyword% (e.g., %appl% to find records containing “apple” anywhere)

Example:

If you want to find all customers whose names start with “John”, you would search for: cus:John%

Additional Tips:

• Combine Wildcards with Other Search Criteria: You can combine wildcards with other search criteria, such as field names and operators, to refine your search.
• Use Quotation Marks: Enclosing a phrase in quotation marks will search for an exact match.  
• Use the Underscore Wildcard: The underscore (_) can be used to represent a single character. For example, inv_123 would match invoices with numbers like “inv123”, “invA23”, etc.

By effectively using wildcards, you can quickly and efficiently find the information you need in NetSuite, saving you time and effort.