Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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.