Scenario:

Formula to return Quantity Back Ordered on Transfer Orders in Transaction Saved Search is working for most scenarios, but not all

Current formula is returning correct results using Case When conditions for specific Items and Transfer Order status and inventory location except when the Item has On Hand inventory which has been committed

Current formula:

CASE WHEN {item} IN ('NFBL001','NFBK001','NFBN001','NFPR001') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0)) WHEN {item} IN ('NFBLZP2','NFBKZP2','NFBNZP2','NFPRZP2') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS(({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0))*2) WHEN {item} IN ('NFBLZP4','NFBKZP4','NFBNZP4','NFPRZP4') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS(({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0))*4) else 0 END