How to: NetSuite Saved Search Lookup By List of InternalIDs

This article is relevant if you need to feed in a list of internalids to serve as input criteria to drive a NetSuite Saved Search.


While helping solve a client’s challenge to lookup a customer deposits that are related to invoices via sales orders,¬†I need to¬†use¬†two saved searches. ¬†While I can use the Content Renderer Engine to link these, it’s a one time analysis so going to the tool isn’t really applicable. ¬†Due to way the data is laid out, I need the results of one NetSuite Saved Search feed into the criteria of another Saved Search.

Solving The Feed of One Search to Another Search

I previously discussed how to do this in my other article, How To: NetSuite Saved Search: Look Up Records from Another List.  This article is just another example where instead I use the Oracle Decode PLSQL function to effectively make my search criteria hold a bit more information in the Saved Search criteria text box.  The trick is to get the Saved Search tool to return a 1 if the internalid matches.    See image for the format.  Here is a snapshot of my Excel sheet that helped me create the formula.


Go After NetSuite Results

The NetSuite platform is powerful and yet, many times, if may seem that your hands are tied. ¬†Indeed, going to a spreadsheet to manipulate data is the way to go. ¬†If you would like help with your NetSuite report or search challenge, let’s have a conversation.

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's 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 25 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 - Google Plus - YouTube

| Tags: , , | Category: NetSuite, Reporting, Technical | Leave a comment

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>