ANS-0202 · SAVED SEARCHES & FORMULAS
Why Can’t a NetSuite Saved Search Find My Custom Record?
Custom record internal ID character limitations can impact saved search results.
Short answer
NetSuite saved searches may not return custom records if their internal IDs contain restricted characters. NetSuite support indicates that internal IDs for custom records or certain custom fields have alphanumeric restrictions. Ensure custom record internal IDs adhere to these guidelines to ensure proper saved search functionality.
Scenario
Users attempting to create a NetSuite saved search on a particular custom record may find that the search does not return the expected results, even when the record clearly exists. This issue suggests an underlying problem with how the custom record's identifier is interpreted by the search engine.
Solution
NetSuite support has indicated that the internal ID of a custom record or certain custom field IDs may have restrictions on special characters. While the display name of a custom record can generally include various characters, the internal ID field, which is crucial for system operations like saved searches, typically has alphanumeric restrictions. To ensure custom records are discoverable by saved searches, it is essential to verify that their internal IDs adhere to NetSuite's character guidelines, avoiding quotes or other special characters that could interfere with search functionality.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support