RE: Saved Search for Orders that have BackOrdered Products
Answered
I am hitting a wall,
I need to search for all orders that contain a back-ordered item on them.
What I want to see is
Dosument Number | Date | Status | BackOrdered Quantity
The formulas I have tried to get the back ordered quantity
{quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0)
nvl({quantity}-{quantitycommitted},0)
What if I need to search for sales orders WITHOUT any back orders, i.e. orders with everything in stock?
Then you need to compare the quantity on the order and the quantity committed.
Can a search return only those orders where the quantity committed equals the quantity on order for every single item on the order? In other words, where there are no back orders?
