Discussions
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.