Inventory control fields

Field definitions for inventory control fields.

Field name Description Usage information
Actual P/Order Lines Average Total Purchase Order lines per year The average number of unique purchase order line items in a year calculated over the last 2 years, based on the purchase order date field for Supplier ("SUP") lead-times.
Current P/O Lines Expected Annual Number of Purchase Order Lines based on current reorder levels The number of orders per year based on the average order quantity and the forecast annual usage.
Current Safety Units Current Safety Stock in units Calculated based on the Current Min or ROP.
Current Turnover Current Stock Turnover Ratio This value is calculated as Forecast Usage Value over Stock Holding Value.
Intransit SOH In transit Stock On Hand Extracted from the ERP - Quantity of Stock on Hand in-transit.
Lead Time Code. Lead Time Code. Used to designate which lead time value is adopted and displayed. For example, "A - Average" or "S - Stated".
Lead Time Sigma. Lead Time Standard Deviation. The number of units of an item that can be expected to be used during the time period represented by the lead time variability.
Lead Time Variance % Supplier. Lead Time Variance %. A measure of the degree of variability in the Supplier Lead Times.
OOB Reorder Point Optimal/Optimal/Best Reorder Point (ROP) Reorder Point based on "Optimal" Reorder Level Methods and "Best" Forecast Method.
OOB Reorder Quantity Optimal/Optimal/Best Reorder Quantity (ROQ) Reorder Quantity based on "Optimal" Reorder Level Methods and "Best" Forecast Method.
Overshoot Average Reorder Point (ROP) Overshoot When Stock on Hand falls below the Reorder Point due to a goods issue.
P/Order Lines Expected Annual Number of Purchase Order Lines Value based on the solution Recommended Reorder Point and Reorder Quantity.
Recommended AOQ MIO Inventory Optimization Average Reorder Quantity (considers pack size) Value based on the solution Recommended Reorder Point and Reorder Quantity.
Review Lead Time. Administrative Review (Internal) Lead Time (days) Clients defined lead time to take into account time taken to review a material requirement and process to a purchase order.
ROM Reorder Method The Reorder Method (ROM) field is used to determine what values are passed between the ERP and the solution during the Import and Export phases.
ROP Method Reorder Order Point calculation Method. A drop-down list of selectable parameters for example optimal, hold zero, hold one, define.
ROP Parameter Re-Order Point calculation Parameter User-defined parameter entered when using some of the non-optimal methods.
ROQ Method Reorder Order Quantity Calculation Method. A drop-down list of selectable parameters for example optimal, hold zero, hold one, define.
ROQ Parameter Order Quantity Calculation Method Parameter User-defined parameter entered when using some of the non-optimal methods.
Smoothed SOH Smoothed Average Stock on Hand This field allows the average stock holding to be tracked by smoothing the past and current stock holding.
Stock On Hand Current Stock On Hand (SOH) Extracted from the ERP.
Total Lead Time Total Lead Time (days) Calculated as Review + Selected lead time + Delivery leadtime.
Turnover Expected Stock Turnover ratio This value is calculated as Forecast Usage Value over Stock Holding Value based on Recommended Reorder Point and Reorder Quantity.