Inventory Restock List

Purpose:

This function provides a simple mechanism for refilling the stock in a stocking location. For example, a location may be a truck. The truck may be normally stocked with many inventory items and has a ‘normal’ stocking level (the Inventory Item's reorder level for a particular location) for each item. You would like the driver to efficiently keep the truck’s inventory items at their normal stocking levels.

This function also makes inventory history entries showing stock on order at the restock-to location and allocating stock from the restock-from location.

The "trigger" mechanism is that when "on hand" quantity is less than the "reorder level", an item will qualify for replenishment, and the Quantity to PICK will be however many are required to bring the "on hand" quantity up to the "Order Up To Level.

for instance...if 2 are on hand
                  3 is the reorder level
                10 is the order up to

then an item would qualify for 8 to be picked.

Assumptions:

This function sets the Inventory History Security for Intercompany databases. It also prevents selecting the To and From Locations from different Companies.  

The inventory items normally stocked at a location are identified from the Inventory Item Location tab entries for the location.

The normal stocking level for an item at a specified location is identified by the Inventory Item Location tab's Reorder Level field.

Usage:

This record is used in a five-step process for restocking inventory:

1. Create a Restock List for a Location pair, as discussed in this help topic.

2. Print the Restock Pick List.

3. Pick the items and record the actual quantities picked.

4. Use the printed Pick List to enter the quantities picked into the system using the Inventory Restock Pick List Entry function.

5. The Pick Ticket is Closed (in the Inventory Restock Pick List Entry function).

 

Note that when the restocking list is saved, the following inventory history postings will be generated for each restocking record:

The quantity on order at the restock-to location will be incremented by the quantity to be transferred.

The quantity allocated at the restock-from location will be incremented by the quantity to be transferred.

When the Close Pick Ticket button is clicked in the Restock Pick Ticket Entry viewer (and the record saved), Inventory History will be adjusted so that any remaining On Order / To Pick quantities are zeroed out. The Status of the Inventory Restock entry will be set to Closed, unless a registry entry is in place to delete closed entries (the previous default behavior).

A Status filter range has been added to the Inventory Restock List and Inventory Restock Pick List Entry viewers. By default, this range is set to Open. To view both Open and Closed entries, click the All filter button. To view only Closed entries, click the Closed filter button.

Registry:

Registry Inventory Restock

Screen Organization:

The upper section of this screen enables you to specify the Restock To and From Locations. Once these fields have been entered, the system will populate the lower section with a list of the items (and quantities) that need to be picked.

Important Fields: Upper Section

Transaction Id:
If you are creating a new restock list, leave this field blank - it will be completed by the system when the record is saved. To access an existing list, you may enter its Transaction Id.

Restock To Location:
Enter the Location Id that you wish to restock to (e.g., a truck 1) or double-click to select from a list of locations.

Restock From Location:
Enter the Location Id from which you will restock inventory (e.g., a regional warehouse).

InterCompany Validation: When running with an Intercompany databases, this function prevents selecting the To and From Locations from different Companies.  

Status: Open Closed
Closed By, Date Closed, and Time Closed

These display-only fields are maintained by the system. A Restock entry will be closed by the system when the Close Pick Ticket button is clicked in the View Inventory Restock Pick List Entry viewer. The Closed By, Date Closed, and Time Closed fields will also be set at this time.

Note:
When the user enters location ids in both the To and From Location fields, the corresponding restocking records will be retrieved and displayed in the lower section. If there are currently no corresponding restocking records in the system, the user will be asked to confirm that the restocking list should be generated and displayed in the lower section.

 Click the Save Record button to save this list.

image\printpickticket.gif Click this button to print a physical pick list. If you have not yet saved this entry, the system will prompt you to do so. This report is ordered by the Bin/Location and then the Inventory Id. Once the pick list has been generated, the user should pick the items on the Restocking Pick Ticket from the restock-from location and write down the quantity actually picked.

Important Fields: Lower Section

Items Tab

Inventory Item Id: Quantity Needed: Inventory Item Name:
The Inventory Item Location table will be searched for inventory items belonging to the restock-to location having a positive quantity needed. The quantity needed is computed as the reorder level less the quantity on hand.

Quantity to Pick:
For each of these inventory items, the quantity available at the restock-from location will be computed. If the quantity available is greater than zero, a restocking record for the item will be generated. The Quantity to Pick will be computed as the lesser of the quantity needed at the restock-to location and the quantity available at the restock-from location.

Stocked:
This display field will be checked if the Item is flagged as a Stocked Item.

Reorder Level:  Order Up To:
These fields display the current Reorder Level and Order Up To quantities in the Restock To Location.

IMH Tab 

Item Id: Location On Order: To Pick: Transferred: Received:

This tab displays the Inventory History summary for this entry.

When a Restock entry is first created, the On Order value of the Restock To Location, and the To Pick: value of the Order From Location will both default from the Quantity to Pick on the Items tab.

When the Pick List Entry has been completed, the Transferred and Received columns will be updated, and the On Order and To Pick columns revised.

When the Close Pick Tick button is clicked in the Restock Pick Ticket Entry viewer (and the record saved), Inventory History will be adjusted so that any remaining On Order / To Pick quantities are zeroed out.