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.
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