Reorder Point Search

Search Criteria: Type is Inventory Item   Formula (Numeric) is greater than 0 case when NVL({locationreorderpoint},0)-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0) > 0 AND NVL({locationpreferredstocklevel},{locationreorderpoint})-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0)> 0 then ROUND(NVL({locationpreferredstocklevel},{locationreorderpoint})-NVL({locationquantityavailable},0)-NVL({locationquantityonorder},0)+NVL({locationquantitybackordered},0)) else 0 end Inactive is false   Location is all   Inventory Location is 02 – Warehouse   Preferred Vendor – Buyer (Custom) is all   Results:   FIELD SUMMARY TYPE FUNCTION… Continue reading Reorder Point Search