This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

*Saved Search Question-I am trying to create a saved search that displays open E-Commerce orders that need to be displayed on a television in the warehouse. I want to filter out orders that we cannot ship from there being no physical inventory in our warehouse to fulfill these orders. However, I have questions on how I can create this saved search. One problem I am seeing is I am unsure how to search by line items on a sales order -&gt; if one item has an availability/on hand of a 0 quantity then the whole SO would be excluded from the search. An example is SO111, if SO111 has 3 items (A,B,and C) If item A and B have quantity on hand and C does not , I want to exclude the whole order as we cannot ship it completely. Does anyone have any ideas on how to do this?*