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.

#FieldDescriptionConfig. for Autom. Replen.Remarks
1Active for Autom. ReplenishmentActivate if the location to be use Automatic ReplenishmentYESAutom. Replenishment
2Use Planned Cross Docking

Activate for show the location in the Cross Dock and 

Buyer Push Matrix pages

No

Manual Replenishment

  • Planned Cross Docking
3Location is a Warehouse

Select the option is the location is used for a warehouse.

Do not select this option if the location is store.

YESAutom. Replenishment
4Replenish 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


  • Calculation Method is Average Usage
5Data Source

Default Option is Local Company

Other option use for Multi-Company Replenishment

Yes

Autom. Replenishment


6Data Source CompanyUse for Multi-Company ReplenishmentOptional

Multi-Company Replenishment

7Distribution 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"

8Customer 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"

9Effective 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:

  • 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 and historical days defined in Replenishment Setup. The coverage days define how far into the future the documents should be included, whereas the historical days define the time horizon fence for the historical period.

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 RelationDescriptionReference
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
Ordered by = Central
Ordering Method = Calculate

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)


 









  • No labels