Saved Search Formula for ” On Hand Quantity” in a location

CEIL(NVL(MIN(CASE WHEN {inventorylocation.id}=’5′ OR {memberitem.inventorylocation.id}=’5′ THEN  (CASE WHEN {type}=’Inventory Item’ THEN (NVL({locationquantityonorder},0)) ELSE  (NVL({memberitem.locationquantityonorder},0)/{memberquantity}) END) END),0))

Leave a comment

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