Saved search formula to be applied as a criterion for fetching sales order item lines that have zero backorders by increasing the committed quantity, not by decreasing the ordered quantity.

["max(formulanumeric: DECODE(MAX(case when ({quantity} - nvl({quantitycommitted}, 0) - nvl({quantityshiprecv}, 0)) = 0 then 1 else 0 end),1,DECODE(MAX(case when {linesystemnotes.field} = 'Committed'  then 1 else 0 end),1,DECODE(MAX( case when {linesystemnotes.field} = 'Quantity'then 1 else 0 end ),1,MAX(CASE WHEN  ({linesystemnotes.field} = 'Quantity') AND (ABS({linesystemnotes.oldvalue})<ABS({linesystemnotes.newvalue})) THEN 1 ELSE 0 END),0,1) , 0,0),0,0))","equalto","1"]

Leave a comment

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