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 | FORMULA | WHEN ORDERED BY FIELD | CUSTOM LABEL | SUMMARY LABEL | |
| Inventory Location | Location | ||||||
| Name | Item | ||||||
| Display Name | Description | ||||||
| Preferred Vendor | Group | Vendor | |||||
| Location Available | |||||||
| Location Back Ordered | |||||||
| Location On Order | |||||||
| Location Reorder Point | |||||||
| Location Preferred Stock Level | |||||||
| Formula (Numeric) | 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 | Quantity | |||||
| Name | Count | Items | |||||
 |