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.
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
This was exactly what I needed. Thank you, Marty.
Absolutely spot on – thanks Marty!