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.
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 Sales Order
+ Quantity in Transfer In
- Quantity in Transfer Out
Reorder Point
If the Effective Inventory is less or equal to the Reorder Point, the system will suggests ordering enough stock to get the inventory up to the Maximum Inventory field value.
Note: Zero is NOT a valid number in the Reorder Point 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
Reorder Point
If the field Reorder Point is greater than zero and System Suggested Quantity is less than the Reorder Point, 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