Following setup needs to be done for activate the Replenishment System
1- LOCATION
One or more locations need to be set up as warehouse. You can setup one or more warehouse with one warehouse being a default warehouse.
# | Field | Description | Config. for Autom. Replen. | Remarks |
1 | Active for Autom. Replenishment | Activate if the location to be use Automatic Replenishment | YES | Autom. Replenishment |
2 | Use Planned Cross Docking | Activate for show the location in the Cross Dock and Buyer Push Matrix pages | No | Manual Replenishment
|
3 | Location is a Warehouse | Select the option is the location is used for a warehouse. Do not select this option if the location is store. | YES | Autom. Replenishment |
4 | Replenish as Location Code | Use for new location it have no sales history but the replenishment calculation method is Average Usage. For example, S0009 is a new store and no sales history for the replenishment calculation. Select the existing store location S0001 in this field, that means the calculation for S0009 is use the sales history for S0001 to calculate | Optional |
|
5 | Data Source | Default Option is Local Company Other option use for Multi-Company Replenishment | Yes | Autom. Replenishment |
6 | Data Source Company | Use for Multi-Company Replenishment | Optional | Multi-Company Replenishment |
7 | Distribution Location Code | Specific the Distribution Location Code for the Location Only applicable when the field "Data Source" is "Other Company" or "Other Database" | Optional | Data Source is not "Local Company" |
8 | Customer No | Define the Company No. use to create sales order if Data Source is Other Company or Other Database. | Optional | Data Source is not "Local Company" |
9 | Effective Inventory | These fields specify if the quantities in the respective order documents will be considered as part of the Effective Inventory for the location during replenishment calculation. The available options are:
| Optional if the field is left blank, system will according to the "Replenishment Control Data" setup in item card for the calculation. |
2- STORES
One or more stores need to be set up as receiving location for Replenishment
3- ITEM
The replenishment process uses Item Data to decide the quantity to replenish and which calculation method and parameters are to be used
3.1- Item Store Relation - Active for Replenishment and for which store
Options for Item-Store Relation | Description | Reference |
---|---|---|
Grades | Replenishment Grades are used to determine if an item is to be automatically replenished for a given store or a location. When the system determines whether an item is to be automatically replenished, it needs to find the Replenishment Grade Code for the Item and the Replenishment Grade Code for the Location and compare them. If the Item Replenishment Grade Code is smaller than or equal to the Store Replenishment Grade Code, the Item will be automatically replenished. Example: For an Item with the Replenishment Grade Code D and Store Replenishment Grade Code B, the Item will be automatically replenished in that particular store. Items with the Grade Code D should be replenished for all stores with the Grade Codes A, B, C and D. | Assigning Items to Store Using Grades |
Store Group | Store Groups are used to determine if an item is to be automatically replenished for a given store or a location. You can specify if the item is to be replenished in specific stores or Store Groups in the Retail Item Card under Distribution FastTab. You must set the following values for the item to be valid for Automatic Replenishment: Status = Active If more than one Item Distribution record is valid for a specific store (all stores, group of stores, or a single store), the system will select the record that is the most specific (One Store being the most specific and All Stores the least). The priority of store groups is defined in the Store Card. | Assigning Items to Stores Using Store Groups |
4- Replenishment Setup
(1) Select default warehouse in the field "Default Central Warehouse".
Multiple Warehouse
you can define the exception warehouse for a Division, Item Category, Retail Production Group, Item No. and/or Store Location.
for example:
All items for the Retail Product Group ACC will be replenished from the W02 Accessory warehouse.
All items for the Item Category HOMEAPPL will be replenished from the W03 Home Appliance warehouse.
No Warehouse
if the company does not have a warehouse, the head office can process the replenishment by use of the Purchase Order Journals. The Purchase Order to be delivered to the store directly. However, the default warehouse must be defined in the replenishment setup.
5- Common Replenishment Data fields
Refer to the article for the common data field for all Replenishment calculation types
Common Replenishment Data Fields (lsretail.com)
6- Setup for Auto Replenishment - Average Usage
Calculation Type – Average Usage (lsretail.com)
7- Setup for Auto Replenishment - Manual Estimate
Calculation Type – Manual Estimate (lsretail.com)
8- Setup for Auto Replenishment - Like for Like
Calculation Type – Like for Like (lsretail.com)
9- How to replenish item for future sales
Replenishment Planned Sales Demand (lsretail.com)