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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Finding "Pending Approval" Sales Orders where items are 100% available.
I'd like to write a saved search that shows sales orders that have a status of pending approval, but that can ship complete based on there being enough Quantity Available of every item.
I wrote a search that can show me each line individually by adding the following search criteria:
formula (numeric) {item.quantityavailable} - {quantity} greater than or equal to 0
What would be better is if we could only show the mainline of orders where every item meets this criteria.
0