ANS-0093 · SAVED SEARCHES & FORMULAS
How to Include Unavailable Fields in NetSuite Saved Search Criteria or Results?
Learn a simple method to display or filter by fields not present in standard NetSuite Saved Search dropdowns.
Short answer
When a desired field is not visible in the dropdown menus for NetSuite Saved Search criteria or results, users can leverage a formula field. By inputting the field's internal ID into a custom formula, the data can be successfully retrieved and utilized within the search.
Scenario
NetSuite users occasionally encounter situations where specific fields are not available for selection within the standard dropdown menus of a Saved Search, either when defining criteria or configuring results. This limitation can prevent users from extracting or filtering data essential for their reporting needs.
Solution
If a field is unavailable in the dropdown menus of a NetSuite Saved Search, either in the Criteria or Results subtabs, the recommended approach is to utilize a formula field. Users should create a new formula field and input the internal ID of the desired field. This method allows the system to retrieve and display the data, bypassing the standard dropdown limitations.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support