ANS-0203 · SAVED SEARCHES & FORMULAS
How to Prevent Empty Excel Exports from NetSuite Saved Searches
Learn how to resolve issues where NetSuite saved search results export as empty Excel files, particularly when using text filters.
Short answer
If a NetSuite saved search export results in an empty Excel file, especially when a text filter is empty and also used as a primary sorting criterion, the issue may be resolved by entering the percentage character '%' into the text filter. This wildcard ensures comprehensive results and helps prevent potential export failures.
Scenario
Users occasionally encounter situations where exporting results from a NetSuite saved search yields an empty Excel file. This can occur when a saved search includes a text box filter that is left empty, particularly if that same field is also designated as the primary sorting criterion for the search results. While the exact behavior may vary, this configuration has been observed to lead to unsuccessful exports.
Solution
To address potential issues with empty Excel exports from NetSuite saved searches, especially when an empty text filter is involved, follow this workaround:When configuring a text box filter in a saved search, instead of leaving it blank, enter the percentage character '%' into the filter field.
%The '%' character acts as a wildcard, matching any sequence of zero or more characters, effectively telling NetSuite to include all records for that filter. This method ensures that the filter is not truly empty, which can help prevent the export from failing or producing an empty file, particularly if the filtered field is also used for primary sorting. While the specific bug where an empty text filter used as primary sorting criteria leads to an empty Excel export may have been resolved in recent NetSuite versions, using the '%' wildcard remains a best practice for comprehensive text filtering and avoiding potential export anomalies.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support