When working with NetSuite and the power of Saved Search, you can get into situations where using Criteria Filter Expressions definitions produces unbalanced parentheses. Normally, this is not a problem as you keep working and reworking the Saved Search until you get the right formula.
But what if you save an unbalanced parentheses List View Saved Search and you end up referencing it in your day-to-day processing? This can happen by changing the Drop Down View option in the list footer. The first thing you should do is fix the underlying saved search. But what if you can’t figure out what the underlying search is that is causing the problem. You may be stuck. Further, what if you think you know what the suspect search is but the system is actually returning good results (no errors) on the suspect search when you run it directly?
You need a mechanism to return the search to the default list view. To do so, you need a special URL. For transaction based list view searches, here is the URL to run:
The trick is to know the default SearchID. In this example, the default transaction search ID is “-2100”. By running this URL, you effectively tell NetSuite to reset the list view to the default which is then remembered on all subsequent transaction lists.
This was exactly what I needed. Thank you, Marty.
Absolutely spot on – thanks Marty!