Search criteria to find the sales order which do not have the back ordered quantity

If a user need to create a transaction search to list out the sales orders which do not have any back ordered quantity in the line items, use the formula given below.

case when {‌quantity}-nvl({‌quantitycommitted},0)-nvl({‌quantityshiprecv},0) > 0 then 1 else 0 end
Enter 0

Leave a comment

Your email address will not be published. Required fields are marked *