ANS-0118 · SAVED SEARCHES & FORMULAS
How to Prevent Unrelated Results in NetSuite Global Search?
Understand the distinction between Transaction Number and Document Number, and configure NetSuite preferences to refine global search results.
Short answer
NetSuite Global Search can display results for both Transaction Numbers (transactionnumber) and Document Numbers (tranid), leading to irrelevant matches. To resolve this, administrators can adjust the 'Global Search Includes Transaction Numbers' preference. This setting allows users to control whether transaction numbers are included in global search results, ensuring more precise and relevant search outcomes.
Scenario
Users performing global searches in NetSuite may encounter multiple records that appear unrelated to their search query. This occurs because the global search functionality returns results based on both the Document Number (tranid) and the Transaction Number (transactionnumber), which can include transaction numbers containing a subset of the numerical value searched. This behavior can lead to confusion and inefficient search processes.
Solution
The NetSuite system distinguishes between the Transaction Number (transactionnumber), which functions as an internal ID, and the Document Number (tranid). Global search results can include both, leading to broader, potentially irrelevant matches.To refine global search results and prevent the display of unrelated transaction numbers, administrators can utilize a specific preference:
Navigate to Home > Set Preferences.
Locate the Global Search Includes Transaction Numbers preference.
Uncheck this box to exclude transaction numbers from global search results.This preference provides direct control over whether transaction numbers are included in global search, thereby ensuring that search results are more focused on Document Numbers and other relevant fields.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support