My Stuff
Comments
-
thank you very much Tris finally, I used this formula CASE WHEN {preferredstocklevel} IS NULL AND {quantityavailable} IS NULL AND {reorderpoint} IS NULL AND {safetystocklevel} IS NULL THEN 0 WHEN {preferredstocklevel} IS NOT NULL AND {quantityavailable} IS NULL AND {reorderpoint} IS NULL AND {safetystocklevel} IS NULL THEN…
-
because To order field doesn't match with reorder qty. To order doesn't take in consideration the items sold during the lead time period