Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Exclude Sales Orders with Drop Ship lines from Search Results
I'm trying to create a script that looks for open orders that are pending fulfillment, even though the customer is overdue. The script will change the status of the order to Pending Approval. Everything works properly unless it hits an order that contains a line with a drop ship item. It cannot set it to pending approval. I'm OK with ignorning these orders, but I cannot figure out how to exclude these type of orders from the search.
Reviewing the records browser, I see "createdpo" and "createpo" which are under the "item" sublist as a "select" field. Whichever way I try to reference this fails. I've tried to build this saved search in the UI and also cannot find out how to do this.
0