My Stuff
Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!
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