ANS-0092 · SAVED SEARCHES & FORMULAS
How does NetSuite determine saved search sorting precedence?
Understanding the hierarchy of sorting criteria is crucial when a NetSuite saved search incorporates both user interface and script-defined sorting rules.
Short answer
NetSuite prioritizes sorting definitions established directly within the user interface of a saved search. Any sorting instructions specified through scripts will only be applied after the UI-defined sorting criteria have been fully processed and implemented. This ensures consistent behavior based on the primary configuration.
Scenario
Users may observe unexpected sorting behavior in NetSuite record searches, particularly when a saved search has sorting preferences configured both within the NetSuite user interface and through an associated script. The perceived discrepancy arises from a lack of clarity regarding which sorting instructions take precedence.
Solution
When a record search is performed on a saved search that has sorting defined in the NetSuite user interface, the system will apply the UI-defined sorting order first. Script-defined sorts will only be considered and applied after the primary sorting setup in the user interface has been fully processed. This established precedence ensures that the explicit UI configuration dictates the initial sort order.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support