Calculation Process for Stock Levels – Warehouse

In this article

Effective Inventory

Reorder Point

Maximum Inventory

This process is only used where a Replenishment Journal is creating a Purchase Order for the warehouse, a Replenishment data record exists for the warehouse, and the Replenishment Calculation Type is Stock Levels.

For BOM and Component Replenishment Journals, refer to Calculation Process for BOM and Components for information about their calculation process.

Effective Inventory

The system calculates the inventory of the warehouse that is going to be used in the rest of the calculations.

Effective Inventory =

Inventory

+ Quantity on Purchase Order

- Quantity on Purchase Return Order

- Quantity on Sales Order

+ Quantity in Transfer In

- Quantity in Transfer Out

+ Quantity in Assembly Header

- Quantity in Assembly Line

Reorder Point

If the field Reorder Point is greater than zero and System Suggested Quantity is less than the Reorder Point, then the System Suggested Quantity is set to Reorder Point and Decision is set to Brought up to Reorder Point.

Condition:

System Suggested Quantity < Reorder Point

Result:

System Suggested Quantity = Reorder Point

Maximum Inventory

The field Maximum Inventory works together with the Reorder Point field. Only if the current Effective Inventory is below or equal to the Reorder Point, will the system proceed to calculate the System Suggested Quantity.

If the Maximum Inventory is set larger than the Reorder Point, the system will bring the System Suggested Quantity up to the Maximum Inventory. Otherwise, the system will bring the System Suggested Quantity up to the Reorder Point.

The Decision is set to Brought up to Maximum Inventory.

Note: Zero is NOT a valid number in the Maximum Inventory field.

Condition:

Effective Inventory <= Reorder Point

Result:

Condition:

Maximum Inventory > Reorder Point

Result:

System Suggested Quantity = Maximum Inventory – Effective Inventory

Condition:

Maximum Inventory <= Reorder Point

Result:

System Suggested Quantity = Reorder Point – Effective Inventory