Assign Replenishment Details

May 27, 2018 in Inventory Control

Purpose

This tool is used to assign replenishment details to a selected set of inventory items of your choosing. It is basically a short cut for setting the replenishment type on many inventory items at once. You enter the replenishment details to set, then the selection criteria of the inventory items you want e.g. apply a replenishment method of ‘Outside Supplier’ to all items in locations starting with ‘C’ and where the product group is equal to ‘JA’.

The selected items are presented in a list for further refinement so you can see which inventory items are going to be assigned the new replenishment settings. Once you submit the list for change, the replenishment details on each included inventory item are updated with the detail settings.

For more details on replenishment, see the related article on Replenishment Overview.

Data Input

­

Step 1 – Options

Nominate for each of the Replenishment prompts listed below the new setting you want to be applied to the selected Inventory items.

Replenishment Code

Select the new replenishment code that you want to apply.

Replenishment Location

Enter an existing location as replenishment location. Note that not all ‘Replenishment Codes’ require a ‘Replenishment Location’.

Stocking Method

Select the ‘Stocking Method’ that you want to apply.

Replenishment Method

Select the ‘Replenishment Method’ that you want to apply.

Replenishment Mode

Select the ‘Replenishment Mode’ that you want to apply.

Update Lead Time

Select this option if you want to update inventory items with any of the lead time details. The prompts below are available if you have selected this ‘Update Lead Time’ option.

Standard Lead Time

Enter the ‘Standard Lead Time’ that you want to apply.

Lead Time

Enter the ‘Lead Time’ that you want to apply.

Update Replenishment Quantities

Select this option if you want to update inventory items with replenishment quantity information. The prompts below are available if you have selected this ‘Update Replenishment Quantities’ option.

Safety Stock

Enter the ‘Safety Stock’ that you want to apply.

Minimum Stock

Enter the ‘Minimum Stock’ that you want to apply.

Maximum Stock

Enter the ‘Maximum Stock’ that you want to apply.

Update Bin

Select this option if you want to update inventory items with bin information. The prompts below are only available if you have selected this ‘Update Bin’ option.

Specific Bin

Choose if you want to apply the specific bin rule to the inventory items selected.

Primary Bin

Enter the ‘Primary Bin’ that you want to apply.

Secondary Bin

Enter the ‘Secondary bin’ that you want to apply.

Update Replenishment Levels

Select this option if you want to update inventory items with replenishment level information. The prompts below are only available if you have selected this ‘Update Replenishment Levels’ option.

Minimum ReOrder Quantity

Enter the minimum re-order quantity that you want to apply.

Replenishment Quantity Factor

Enter the replenishment quantity factor that you want to apply.

Replenishment Factor Type

Enter the replenishment factor type that you want to apply.

Update ABC

Select this option if you want to update inventory items with ABC information. The prompts below are only available if you have selected this ‘Update ABC’ option.

Auto Update

Choose if you want to apply the auto update rule to the inventory items selected.

ABC Code

Enter the ‘ABC Code’ that you want to apply.

Update Supplier

Select this option if you want to update inventory items with supplier information. The prompts below are only available if you have selected this ‘Update Supplier’ option.

Supplier Code 1

Enter the supplier you want to set as the first ranked supplier for the inventory item. Note this overrides the product supplier.

Supplier Code 2

Enter the supplier you want to set as the second ranked supplier for the inventory item. Note this overrides the product supplier. You should not enter a supplier here unless you also have a ‘Supplier Code 1’ entry.

Supplier Code 3

Enter the supplier you want to set as the third ranked supplier for the inventory item. Note this overrides the product supplier. You should not enter a supplier here unless you also have a ‘Supplier Code 1’ and ‘Supplier Code 2’ entry.

Return to the Top
­

Step 2 – Fixed Filters

Enter any specific filters that you want to use to target the Inventory items you want to update e.g. you may only want to select products in a certain Product Group, or for a particular Buyer. Entry of filters here is the same style as used with User Report Filters – read here for more about reporting filters.
Return to the Top
­

Step 3 – Selected Items

The Inventory items that match the entered filters are displayed in a list on-screen. You may further refine the selected items by omitting any items you don’t want to update with the new Replenishment settings.
Return to the Top

{ 0 comments… add one now }

Ask a Question or Leave a Comment

Previous post:

Next post: