Common Replenishment Data Fields

The LS Replenishment solution offers different Replenishment calculation types.

To break down Reorder Point and Max. Inventory by Variant Weight

This topic describes the Replenishment data fields that are common to all Replenishment calculation types.

Other Replenishment data fields that are specific to a Replenishment calculation type will be described in more detail in the corresponding topics.

Field Description
Replenishment Calculation Type A Replenishment calculation type can have one of the following values:
  • Average Usage
  • Manual Estimate
  • Stock Levels
  • Like-for-Like
  • LS Forecast
Reorder Point If the LS Replenishment system has calculated a demand to replenish an item, the Reorder Point has been filled in and the suggested quantity is less than the Reorder Point, the system increases the quantity up to the Reorder Point.

Example:

The system suggests reordering 8 pieces and the field Reorder Point is 10, the System Suggested Quantity is changed to 10.

Maximum Inventory If this field is filled in, the system orders the stock up to Maximum Inventory level if the stock on hand gets below the Reorder Point.

Example:

  1. Replenishment Calculation Type is Stock Levels.
    The Maximum Inventory field is 20, the Reorder Point field is set to 10 and the actual inventory is 8. In this case the system will reorder 12.
    If the Maximum Inventory is 0, the system will order according to the Reorder Point and reorders 2.
  1. Replenishment Calculation Type is Average Usage or Manual Estimate.
    The calculated demand due to the historical sales is 30. The Maximum Inventory field is 20 and the Reorder Point field is set to 10 and the actual inventory is 8. The system suggests 30, but the system will only reorder 12 as the inventory cannot be more than 20.
    If the Maximum Inventory is 0, the system will order 22 (Suggested Qty – Inventory).
Effective Inv. Sales Order

Effective Inv. Purchase Ord.

Effective Inv. Transfer Inb.

Effective Inv. Transfer Outb.

These fields specify if the quantities in the respective order documents will be considered as part of the Effective Inventory for the item during replenishment calculation.

The available options are:

  • Include - The quantities in the documents will be included.
  • Exclude - The quantities in the documents will be excluded.
  • Coverage - The quantities in the documents will be included but only for documents within the coverage days defined in Replenishment Setup.

Note:

The settings for these fields apply to all Replenishment Calculation Types except for Like-for-Like.

In Replenishment Setup, the same fields can be defined as global setup. When a new item is created, the initial values for these fields are copied from the corresponding fields in Replenishment Setup.

Replen. Data Profile This field contains the code of the Replen. Data Profile record to be used in the Replenishment calculation process.

For more information see the Replenishment Data Profile.

Vendor No. This field contains the number of the vendor that the item should be purchased from. If the Replenishment Data record found for the item has the Vendor No. field filled in, that vendor will be used. If the field is blank, however, the system first looks at the Stockkeeping Unit record and finally the Item record.

Example:

If the Vendor No. field in the selected Item Store record is blank, the system uses the Vendor No. from the Item record as a Stockkeeping Unit record is not found for the Item No and Location Code.

Purch. Order Delivery This field can have two values, To Warehouse or To Store. The value in this field determines whether the purchase orders are to be delivered to a warehouse or to the stores. It is used by the process that adds items to a Replenishment Journal to select the items for the journal.

The field is used when the function Adding Items to a Purchase Replenishment Journal is executed.

The table shows which conditions must be met if the item is to be selected:

Purchaser Order Type field - Replenishment TemplatePurch. Order Delivery Field - Replenishment Data
One Purchase Order per Vendor
One Purchase Order per Vendor with Cross Docking
To Warehouse
Purchase Orders for Receiving LocationTo Store
Transfer Multiple Transfer Multiple is used by the process that creates transfer orders from the replenishment journals. If the Transfer Multiple field is filled in for an item, the quantity in the transfer order line for that item is always a multiple of the Transfer Multiple. The system always uses the rounding defined in the Replen. Multiple Rounding page.
Purchase Order Multiple Purchase Order Multiple is used by the process that creates the purchase orders from the replenishment journals. If the Order Multiple field is filled in for an item, the Quantity in the purchase order line for that item is always a multiple of the Order Multiple. The system always uses the rounding defined in the Replen. Multiple Rounding page.

It is possible to automatically update the Purchase Order Multiple field with Purchase Unit of Measure. See Using Purchase Unit of Measure for more details.

Exclude from Replenishment If you want to temporarily exclude an item from Replenishment, you can select this field. The replenishment process will not consider this item.

To break down Reorder Point and Max. Inventory by Variant Weight

When you update the values of the Reorder Point and Maximum Inventory fields on the Replenishment Control Data page, for an item with variants, it is possible to automatically break down the values by the Variant Weight and update the corresponding fields in the Item Store Records. This feature depends on the setup of fields in the Item to Item Store Rec section of the Integration FastTab on the Replen. Setuppage.

The setup includes the Variant Weight Breakdown (Reorder Point) and Variant Weight Breakdown (Max Inventory) fields that can have the following values:

  • Never - No breakdown of the value when it is changed.
  • With Confirmation - Ask for a confirmation to break down the value when it is changed.
  • Without Confirmation - Break down the value when it is changed without any confirmation.

This feature for the breakdown of Reorder Point and Maximum Inventory by Variant Weight only applies to items with Variant Framework defined and existing Item Store Records.

Note: When breakdown is enabled, changing the value in Replen. Control Data List will always ask for a confirmation.

Example:

Variant 001 for Item A has its Variant Weight set to 6.
Variant 002 for Item A has its Variant Weight set to 4.

If you change the Reorder Point of the Item to 100 with the Variant Weight Breakdown (Reorder Point) field set to Without Confirmation, the system will automatically break down this value as per the variant weights and update the related Item Store Rec lines:

Reorder Point will be updated to 60 on Item Store Record for Item A, Variant 001.
Reorder Point will be updated to 40 on Item Store Record for Item A, Variant 002.

The breakdown is grouped by locations that are set up in the Item Store Records.