ANS-0187 · SAVED SEARCHES & FORMULAS
NetSuite Saved Search: Sorting by Multiple Numeric Formula Fields
NetSuite users may encounter a known system limitation when attempting to sort saved search results using more than one numeric formula field.
Short answer
NetSuite Saved Searches currently have a recognized limitation where sorting does not function correctly when multiple formula (numeric) fields are used as sorting criteria. This behavior is a known system constraint that users should be aware of when designing complex searches.
Scenario
Users attempting to sort the results of a NetSuite Saved Search by multiple formula fields, specifically those configured as numeric, may observe that the sorting order does not apply as expected. This occurs when more than one formula (numeric) field is designated as a sorting criterion within the search definition.
Solution
This behavior is a recognized system limitation within NetSuite. When a Saved Search attempts to sort by multiple formula (numeric) fields, the system may not apply the sorting criteria correctly. Users should be aware that this is a known constraint when designing searches that rely on complex multi-field numeric sorting.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support