ANS-0143 · SAVED SEARCHES & FORMULAS
How Does NetSuite Search for Employees Using Email Addresses?
NetSuite's employee search functionality considers multiple email fields, which impacts how users and scripts locate records.
Short answer
When searching for an employee by email, NetSuite's default behavior may query both the primary 'email' and secondary 'altemail' fields. While 'altemail' is not directly accessible on loaded records via SuiteScript, it is available as a search column for scripting purposes, ensuring comprehensive search results.
Scenario
Users or administrators attempting to locate employee records within NetSuite by email address may observe that searches return results based on both primary and alternate email fields. Understanding which fields NetSuite queries during an email search is crucial for accurate record retrieval and custom scripting.
Solution
When performing an employee search by email, NetSuite's default behavior may query both the primary 'email' field and the 'altemail' field. It is important to note that while the 'altemail' field may not be directly accessible on a loaded record object via SuiteScript, it is accessible through SuiteScript when performing a search, as 'altemail' is available as a search column. This ensures that comprehensive search results can be achieved when scripting custom searches.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support