ANS-0021 · SAVED SEARCHES & FORMULAS
Why Are Some Standard NetSuite Fields Not Available in Saved Searches?
Learn why some standard NetSuite fields are not exposed in saved searches and how to access their data.
Short answer
Some standard NetSuite fields are not directly exposed for use in saved searches. To access data from these fields, users must either load the record programmatically to fetch the value or create a custom field that copies the value via a script, typically on save events.
Scenario
Users often encounter situations where specific standard fields in NetSuite do not appear as selectable options when creating or modifying a saved search. This limitation prevents direct reporting or filtering on these fields through standard saved search functionality.
Solution
When a standard field is not exposed for direct use in a NetSuite saved search, there are two primary approaches to retrieve its data. The first method involves programmatically loading the relevant record and fetching the field's value directly. The second approach requires adding a custom field (configured to store a value of TRUE) and implementing a script to copy the value from the unexposed standard field into this new custom field. This script typically executes on record save events, though it would require a separate process to update existing records.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support