Saved Search for Orders that have BackOrdered Products

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)

Rookie Asked on March 24, 2023 in Order Management.
Add Comment
2 Answer(s)
Best answer

Formula {‌quantity}-nvl({‌quantityshiprecv},0)-nvl({‌quantitycommitted},0) should provide you the back ordered quantity

Rookie Answered on March 24, 2023.
Add Comment

What if I need to search for sales orders WITHOUT any back orders, i.e. orders with everything in stock?

Rookie Answered on May 31, 2023.

Then you need to compare the quantity on the order and the quantity committed.

on May 31, 2023.

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?

on May 31, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor