ANS-0142 · SAVED SEARCHES & FORMULAS
Why Do NetSuite Saved Searches Return No Results for Transaction Exports?
Complex fields in NetSuite saved searches can lead to performance issues and incomplete transaction export results.
Short answer
NetSuite saved searches exporting transaction data may return no results or incomplete data if complex fields like 'Realized Gain' or 'Formula Field' are included. To resolve this, remove these complex fields from your search criteria and results columns. This improves search performance and ensures expected transaction data is displayed.
Scenario
Users attempting to export comprehensive transaction data via a NetSuite saved search may encounter an unexpected issue where the search returns zero results, or the results are incomplete. This problem typically arises when the saved search includes certain complex or computationally intensive fields, preventing the search from executing successfully or displaying all relevant data.
Solution
When configuring a NetSuite saved search to export all fields from a Transaction, the inclusion of certain complex fields can lead to unexpected behavior. Specifically, including 'Realized Gain' fields may cause performance degradation, timeouts, or unexpected empty or incomplete results. Similarly, 'Formula Field' fields, if not carefully managed or if computationally intensive, can also contribute to performance issues, timeouts, or display problems such as blank fields or columns not appearing. To resolve these issues and ensure the saved search returns the expected transaction data, it is recommended to remove these complex fields from the search criteria and results columns. After removing these fields, re-run the saved search to verify that the results are now complete and accurate.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support