Working with Replenishment Control (MSRP)

Purpose: Use the Work with Replenishment Control screen to:

• Run the Replenish Primary Locations program and create the replenishment control request for the run.

• Scan for an existing replenishment control request.

• Review replenishment requests which have been generated as a result of a submitted job (for example, PICK_GEN). Note: These replenishment requests display only if the Let Down Replenishment (C36) system control value is set to RPT/EXEC and the LPN Tracking (E16) system control value is unselected.

• Confirm or unconfirm the individual item transfers detailed in a replenishment control request.

• Confirm the entire replenishment control request.

• Process the replenishment control request to effect the inventory transfer transactions for all confirmed items.

• Reprint the replenishment control reports for any unprocessed request.

• Print consolidated reports for selected, unprocessed requests.

• Delete an unprocessed replenishment control request.

For more information: See Replenish Primary Locations Overview for more information on the processing that occurs to replenish primary locations.

In this topic:

• Create Replenish Control Screen

• Replenishment Detail by 'From' Location Report

• Replenishment Detail Report by Item

• Replenishment Detail Report by 'To' Location

• Consolidated Replenishment Report by From Location

• Consolidated Replenishment Report by Item/SKU

• Consolidated Replenishment Report By To Location

• Replenishment Transfer Labels

• Confirming, Processing or Deleting Replenishment Requests

• Replenishment Confirmation By To Location Screen

• Replenishment Confirmation by Item Screen

• Replenishment Confirmation by From Location Screen

• Processing the Replenishment Control Request

• Deleting a Replenishment Control Request

Work with Replenish Control Screen

How to display this screen: Enter MSRP in the Fast path field at the top of any menu or select Replenish Primary Locations from a menu.

Field	Description
Date	The date the Replenishment Control request was created. Numeric, 6 positions (MMDDYY format); optional.
Time	The time the replenishment control request was created. Entering 0:00:00 or leaving this field blank indicates that you want to view replenishment control requests regardless of the time they were generated. Numeric, 6 positions (HHMMSS format); optional.
Whs (Warehouse)	The code representing the warehouse where the replenishment control request was generated. Numeric, 3 positions; optional.
Requested by user	The User ID of the person who created the replenishment control request. The User ID defaults from the User Profile table. If the request was generated as the result of a submitted job (for example, PICK_GEN) the job name will display. Enter a user ID or a submitted job to display requests generated by that user, or by the submitted job you entered. Alphanumeric, 8 positions; optional.
Status	The status of the replenishment control request. Enter a valid status code to display requests whose status matches your entry. Valid status codes are: • Open = This request is open. • Generated = This request has been generated. • In Use = This request is in use, either by another user or because it is currently generating. • Reprinting = This request is in the process of reprinting for any unprocessed transfers. Alphanumeric, optional.
Zones	The warehouse zones that are being replenished, which you specify at the Create Replenish Control Screen. If the request was generated as a result of a submitted job (for example, PICK_GEN), all zones will be eligible for replenishment and the zones being replenished by the submitted job will not display. Alphanumeric, 1 position; display-only
Start aisle	The number of the first aisle in the zone range you are replenishing, which you specify at the Create Replenish Control Screen. If the request was generated as a result of a submitted job (for example, PICK_GEN), all aisles will be eligible for replenishment and the Start aisle will not display. Numeric, 2 positions; display-only.
End aisle	The number of the last aisle in the zone range you are replenishing, which you specify at the Create Replenish Control Screen. If the request was generated as a result of a submitted job (for example, PICK_GEN), all aisles will be eligible for replenishment and the End aisle will not display. Numeric, 2 positions; display-only.
Bill Btch # (Billing Batch #)	The billing batch number for the replenishment control request, if the request was created as a result of pick slip generation. A Billing Batch number will display only for let down replenishment requests; otherwise, the value 0 will display. Numeric, 3 positions; display-only.
Description	A description of the submitted job which generated the replenishment request If the request was created as a result of pick slip generation, the description of the selected pick slip option template will display. If the request was generated at the Create Replenish Control Screen, the description Authorization Process will display. Alphanumeric, 30 positions; display-only.
Cons Print? (Print consolidated replenishment reports)	Indicates whether you want to include a specific replenishment request in three consolidated replenishment detail reports (sorted by To location, by From location, and by Item). To print consolidated reports, select the Cons Print? field for each replenishment request you want to include in the report. Select OK and then Cons. Rpt. Leave this field unselected if you do not want to include a replenishment request in consolidated replenishment detail reports. See Consolidated Replenishment Report by From Location, Consolidated Replenishment Report by Item/SKU, or Consolidated Replenishment Report By To Location.
Cons print status (Consolidated print status)	P indicates that the replenishment request has been included in previously printed consolidated replenishment detail reports. Alphanumeric, 1 position; display-only.

Screen Option	Procedure
Create a Replenishment Control request	Select Create to run the Replenish Primary Locations program and generate a new replenishment control request. See Create Replenish Control Screen.
Delete a Replenishment Control request	Select Delete for the request you want to delete. See Deleting a Replenishment Control Request.
Work with generated details	Select Work with generated details for a request to advance to the Replenishment Confirmation By To Location Screen, where you can confirm or unconfirm the replenishment request for a specific item, or process the confirmed item transfers in the batch.
Confirm a Replenishment Control request	Select Confirm for the request you want to confirm to confirm all item transfers in the replenishment control request. See Confirming, Processing or Deleting Replenishment Requests.
Process a Replenishment Control request	Select Process for a request to process the replenishment request for all confirmed item transfers in the batch. See Processing the Replenishment Control Request.
Print a Replenishment Detail Report sorted by To Location	Select To Loc Rpt for a request to print the Replenishment Detail by 'From' Location Report for any unprocessed replenishment request. Note: This report appears on the Work with All Spooled Files screen, not the Work with Submitted Jobs screen.
Print consolidated Replenishment Detail Reports for selected replenishment requests	Select the Cons Print? field for each replenishment request you wish to select, then select Cons. Rpt to print the Consolidated Replenishment Report by From Location, Consolidated Replenishment Report by Item/SKU, or Consolidated Replenishment Report By To Location.

Create Replenish Control Screen

Purpose: Use this screen to initiate the replenishment process. When you complete this screen, the system:

• evaluates the replenishment requirements for the warehouse and zones indicated to keep the primary picking locations fully stocked

• creates the replenishment control request

• generates the Replenishment Detail by 'From' Location Report

The replenishment control request contains the item quantities that should be transferred, and the recommended transfer 'To' and transfer 'From' locations.

You can use the Replenishment Detail by 'From' Location Report as a worksheet to move the suggested stock.

How to display this screen: Select Create at the Work with Replenish Control Screen.

.

Field	Description
Warehouse	The code of the warehouse where you are running the Replenish Primary Locations program, or where the system has initiated let down replenishment as a result of pick slip generation. Warehouse codes are defined in and validated against the Warehouse table. Numeric, 3 positions; required.
Zones	The warehouse zones to include in the replenishment. If you leave these fields blank, all zones will be included. Note: Only primary locations in the specified zones will be evaluated for replenishment. Alphanumeric, 1 position; optional.
Start Aisle	The number of the first aisle in the zone range you are replenishing. You cannot select a range of aisles unless you also select one or more zones; also, if you enter a beginning aisle, you must also select an ending aisle. Numeric, 2 positions; optional
End Aisle	The number of the last aisle in the zone range you are replenishing. Numeric, 2 positions; optional.

Instructions:

1. Enter the code of the warehouse for which you want to replenish primary locations.

2. Optionally, enter the codes of the zone(s) to include in the replenishment. Only the primary locations in the zones entered will be evaluated for replenishment.

3. Optionally, enter the starting and ending aisles to include in the replenishment. Only the primary locations located in the specified zones and aisles will be evaluated for replenishment.

4. Select OK to generate the request.

The RPLN_STK job generates the replenishment control request and produces the Replenishment Detail by 'From' Location Report and the Replenishment Transfer Labels. You will remain at this screen; however, the fields will be cleared.

Replenishment Transfer Labels

Purpose: If a print program name is defined in the Replenishment Label Program Name (F20) system control value, the system produces these labels when you generate a Replenishment Control.

You can use these labels to help you manage the replenishment transfer process.

Sample replenishment transfer label:

NAILFUN NAIL DECORATING KIT FOR K Loc: PRIM1

Contents:

• Item code

• SKU code

• Item description

• 'To' location (destination) code

Items flagged for priority replenishment: Items flagged for priority replenishment are indicated with an asterisk (*).

An item is flagged for priority replenishment if:

• you keep the item in more than one location, including both pickable and nonpickable locations, and

• the total quantity on printed pick slips is larger than the quantity currently available in the item's primary, pickable location.

In the above situation, you would need to replenish the item's primary location right away so that you will be able to fulfill all the pick slips that are currently printed.

Replenishment requests initiated by the system as the result of Let Down Replenishment during pick slip generation are always flagged for priority replenishment, since the request is generated when there is not enough inventory in the primary location to fulfill all pick slips.

Note: Typically, you would have priority replenishment items for a replenishment request you generate at the Work with Replenish Control screen only if the Check Location Quantities During Pick Generation (C54) system control value is unselected; however, if the replenishment request is initiated by the system as Let Down Replenishment during pick slip generation, the Check Location Quantities During Pick Generation (C54) system control value must be selected.

Confirming, Processing or Deleting Replenishment Requests

Purpose: After you have created a replenishment control request at the Work with Replenish Control Screen, the locations and item quantities recommended for replenishment must be confirmed before the inventory transfers can be processed.

You can confirm all of the replenishments in the replenishment control request at the same time (see below) or you can confirm individual replenishment records using:

• Replenishment Confirmation By To Location Screen

• Replenishment Confirmation by Item Screen

• Replenishment Confirmation by From Location Screen

If you do not wish to confirm any of the entries, you can delete the replenishment control request; see Deleting a Replenishment Control Request.

If the replenishment control request has been generated by a submitted job (for example, PICK_GEN), the locations and item quantities will be automatically confirmed by the system. You can unconfirm by item, or change the quantities to be confirmed at the Replenishment Confirmation screen.

Once the recommended replenishments have been confirmed, the replenishment control request must be processed to execute the inventory transfer transactions. Inventory in the transfer 'From' location will be reduced, inventory in the transfer 'To' location will be increased, and the inventory transfer transactions will be added to the Inventory Transaction History table.

Note: Confirming the replenishment control request and processing the request are two separate steps in the Replenish Primary Locations process.

To confirm a replenishment request: Select Confirm for a replenishment request to confirm all replenishments in a replenishment request. All items in the request are changed to a confirmed status.

If most of the replenishments are going to be confirmed, use this option to confirm all entries in the replenishment control request. Then use Replenishment Confirmation By To Location Screen, Replenishment Confirmation by Item Screen, or Replenishment Confirmation by From Location Screen to unconfirm any replenishments that you will not be transferring.

Replenishment Confirmation By To Location Screen

Purpose: This screen displays the system-recommended locations to replenish in 'To Location' sequence. At this screen you can change the quantity of each item/SKU to be moved, confirm or unconfirm item/SKU transfers, and process confirmed item/SKU transfers.

How to display this screen: Select Work with generated details for a request at the Work with Replenish Control Screen.

Field	Description
To Location	The primary location the system recommends replenishing. The amount in the Qty moved field will be transferred to this location if confirmed. Alphanumeric, 7 positions; optional.
From Location	The secondary or bulk location the system recommends using to replenish the primary location. The amount in the Qty moved field will be transferred from this location if confirmed. Alphanumeric, 7 positions; optional.
Item/SKU	The item/SKU code of the item being replenished. Enter an Item code to display items in alphanumeric order beginning with your entry. (Item) Alphanumeric, 12 positions; optional. (SKU) Alphanumeric, three 4-position fields; display-only.
Quantity to	The system-recommended number of units to replenish transfer from the secondary or bulk location (the From location) to the primary location (the To location). Numeric, 7 positions; display-only.
Quantity moved	The number of units that you will actually transfer if the location is confirmed. The system-recommended replenishment quantity is indicated. You can change this quantity, but it cannot exceed the amount in the Quantity to replenish field. Numeric, 7 positions; required.
Type	The location type of the 'From' location. Enter a location type code to display locations of the type that matches your entry. Valid location types are: • S = Secondary • B = Bulk Alphanumeric, 1 position; optional.
Cfmd	A code indicating whether replenishment to/from these locations is approved. The system automatically updates this field when you confirm/unconfirm an item transfer by selecting Confirm/unconfirm the location. Select the conformation status setting. • selected = the replenishment request for this location is approved. An inventory transfer transaction will be generated when the replenishment control request is processed. • unselected = the replenishment request for this location is not approved. An inventory transfer transaction will not be generated, and the transfer recommendation will be deleted from the system when the replenishment control request is processed. The default value for requests created in Work with Replenish control is unselected. The default for requests generated by the system as let down replenishment during pick slip generation is selected.

Screen Option	Procedure
Confirm or unconfirm replenishment of an item/SKU to this location	Select Confirm/unconfirm the item/SKU to be replenished to change the confirmed status of the item/SKU transfer.
Process the Replenishment Control request	Select Process to process the replenishment transactions for all confirmed items/SKUs in the replenishment control request. See Processing the Replenishment Control Request.
Display the Replenishment Control request in item code sequence	Select By Item to display the Replenishment Confirmation by Item Screen.
Display the Replenishment Control request in 'From' location sequence	Select By from Location to display the Replenishment Confirmation by From Location Screen.

Instructions:

1. Select Confirm/unconfirm for the replenishment transfer you wish to confirm. The Cfmd flag changes to selected.

2. To change the quantity that will be transferred To/From the locations, enter the actual number of units you will transfer in the Qty moved field. The quantity entered cannot exceed the system recommended quantity. If it does, the following message indicates: Quantity to move cannot be greater than replenish quantity.

3. To unconfirm a replenishment transfer, select Confirm/unconfirm. The Cfmd flag changes to unselected. The transaction will be deleted from the request when it is processed.

4. Select Exit to return to the Work with Replenish Control Screen without processing the request. The request can be accessed at a later time to complete the confirmation process.

5. Select Process to process the replenishment control request if the confirmation process is complete. An inventory transfer transaction will be processed for each confirmed entry and the system tables will be updated. Unconfirmed transactions will be deleted from the request.

Replenishment Confirmation by Item Screen

Purpose: This screen displays the system-recommended replenishments in 'Item' sequence.

At this screen you can change the quantity of each item/SKU to be moved, confirm or unconfirm item/SKU transfers, and process confirmed replenishment transfers.

Optionally, you can print the Replenishment Detail Report by Item.

How to display this screen: Select By Item at the Replenishment Confirmation By To Location Screen or the Replenishment Confirmation by From Location Screen.

Screen Option	Procedure
Confirm or unconfirm replenishment of an item/SKU	Select Confirm/unconfirm for an item/SKU to change the confirmed status of the item/SKU transfer.
Process the replenishment control request	Select Process to process all confirmed item/SKU transfers in the replenishment control request and delete all unconfirmed item/SKU transfers. See Processing the Replenishment Control Request.
Display the replenishment control request in 'to' location sequence	Select By to Location to display the Replenishment Confirmation By To Location Screen.
Display the replenishment control request in 'from' location sequence	Select By from Location to display the Replenishment Confirmation by From Location Screen.
Print the Replenishment Detail Report by Item	Select Print Listing.

Replenishment Confirmation by From Location Screen

Purpose: This screen displays the system recommended locations to replenish in 'From' Location sequence. At this screen you can change the quantity of each item/SKU to be moved, confirm or unconfirm item/SKU transfers, and process confirmed replenishment transfers.

Optionally, you can print the Replenishment Detail by 'From' Location Report.

How to display this screen: Select By from Location at the Replenishment Confirmation By To Location Screen or the Replenishment Confirmation by Item Screen.

Screen Option	Procedure
Confirm or unconfirm replenishment to this location	Select Confirm/unconfirm for and item/SKU to change the confirmed status of the item/SKU transfer.
Process the replenishment control request	Select Process to process the replenishment transactions for all confirmed item/SKU transfers, and to delete all unconfirmed item/SKU transfers. See Processing the Replenishment Control Request.
Display the replenishment control request in 'To' location sequence	Select By to Location to display the Replenishment Confirmation By To Location Screen.
Display the replenishment control request in item sequence	Select By Item to display the Replenishment Confirmation by Item Screen.
Print the Replenishment Detail by 'From' Location Report	Select Print Listing.

Processing the Replenishment Control Request

Purpose: After the locations to replenish have been confirmed, you must process the replenishment control request. When the request is processed the following occurs:

• An inventory transfer transaction is processed for each confirmed location. The on-hand quantity in the 'From' location is decreased by the quantity moved; the on-hand quantity in the 'To' location is increased by this amount.

• The amount in the Pending transfer quantity field in the Item Location record for the confirmed 'To' and 'From' locations is reduced by the quantity moved.

• The Inventory Transaction History table is updated with the transfer transactions.

• The replenishment control request is deleted from the system. Note: If you have not confirmed any transfers in the request, you must delete the replenishment request.

You must confirm all item/SKU replenishment transfers that you are going to make. All unconfirmed entries are deleted when the request is processed.

How to process the request: You can select Process at the Work with Replenish Control Screen, or you can select Process at the Replenishment Confirmation By To Location Screen, Replenishment Confirmation by Item Screen, or Replenishment Confirmation by From Location Screen. The system processes only one request at a time.

Deleting a Replenishment Control Request

Purpose: The replenishment control request must be deleted if you are not confirming any of the system recommended replenishment transfers. If a replenishment transfer request exists for an item and location, another replenishment request will not be generated until the existing request is processed or deleted.

Deleting a control request: Select Delete for a request at the Work with Replenish Control Screen. If there are any confirmed records in the request, it cannot be deleted. The following message indicates:

Cannot delete - confirmed records pending

To delete a request with confirmed transfers, you must unconfirm the transfers at a Replenishment Confirmation screen, then select Exit to return to the Work with Replenish Control Screen, where you can delete the request.