AnsweredAssumed Answered

Netsuite Inventory Item Saved Search (Is there an easier way to do this?)

Question asked by GuinScholl3001 on Sep 23, 2016
Latest reply on Sep 26, 2016 by Adam Arrowsmith

I'm wondering if there is an easier way to do this other than running the saved search 3 times and combining the results? 


I have a Saved Search in Netsuite which returns various types of Item records (Inventory Items, Assembly/BOM Items, and Kitted Items) that have a certain flag set.   So three types of Items show up in the Saved Search.


I connect to Netsuite using the QUERY operator and it successfully retrieves the regular Inventory Items, because my Query Connector Operation was initiated with the "Item" object.


Do I have to build 3 QUERY operations (one where object type = Item, one where object type = Assembly Item, and one where object type = Kit Item) and then merge the results together?


We will have a lot of processes that retrieve Items, so I just want to make sure that there is not an easier approach to retrieve everything in my Netsuite Saved search using 1 Connector Operation.


Thanks for any insight folks may have on this topic.