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 Control requests which have been generated as a result of a submitted job (for example, PICK_GEN).

• 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 Replenishment Control requests.

• Delete an unprocessed Replenishment Control request.

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

For more information: See:

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

• Let Down Replenishment for more information on the processing that occurs during let down replenishment.

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.

FLR0046 DISPLAY Work with Replenish Control 8/13/99 8:59:22 LJW MAIL ORDER COMPANY Requested Start End Opt Date Time Whs by user Sts -------Zones-------- Aisle Aisle 0:00:00 Type options, press Enter. 4=Delete 5=Work with generated details 8=Confirm 9=Process 21=Reprint 8/12/99 12:56:00 100 LWARREN G A 01 05 Bill Btch #: 0 AUTHORIZATION PROCESS Cons Print?: P 8/12/99 13:01:04 100 LWARREN G A Bill Btch #: 0 AUTHORIZATION PROCESS Cons Print?: P 8/12/99 14:57:53 100 PICK_GEN G Bill Btch #: 882 ZONE RESERVATION PICK GEN Cons Print?: P 8/12/99 15:06:44 100 PICK_GEN G Bill Btch #: 883 ZONE RESERVATION PICK GEN Cons Print?: P F3=Exit F6=Create F12=Cancel F21=Cons. Rpt F22=User defined option

Field	Description
Date	The date the Replenishment Control request was created. Enter a date to display Replenishment Control requests created on that day. 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 file. 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: G = The request has been generated. I = The request is in use, either by another user or because it is currently generating. R = The request is in the process of reprinting for any unprocessed transfers. Alphanumeric, 1 position; 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 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 displays. If the request was generated at the Create Replenish Control Screen, Authorization Process displays. Alphanumeric, 30 positions; display-only.
Cons Print? (Print consolidated replenishment reports)	Indicates whether you want to include a specific replenishment request in the consolidated replenishment detail reports: • Consolidated Replenishment Report by From Location • Consolidated Replenishment Report by Item/SKU • Consolidated Replenishment Report By To Location Enter Y in the Cons Print? field for each replenishment request you want to include in the consolidated replenishment reports. Press Enter and then F21. Enter N or leave this field blank if you do not want to include a replenishment request in the consolidated replenishment detail reports. Alphanumeric, 1 position; optional.
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	Press F6 to advance to the Create Replenish Control Screen.
Delete a Replenishment Control request	Enter 4 next to the request you want to delete. See Deleting a Replenishment Control Request.
Work with generated details	Enter 5 next to 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	Enter 8 next to 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	Enter 9 next to 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	Enter 21 next to 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	Enter Y in the Cons Print? field for each replenishment request you wish to select, then press F21 to print the consolidated replenishment reports: • Consolidated Replenishment Report by From Location • Consolidated Replenishment Report by Item/SKU • Consolidated Replenishment Report By To Location.

Create Replenish Control Screen

Purpose: Use this screen to create a Primary Location Replenishment request. 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 record

• 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: Press F6 at the Work with Replenish Control Screen.

FLR0047 ENTER Create Replenish Control 1/21/10 11:34:12 KAB Co2 Karen Bottger Company Date . . . : 1/21/10 User . . . : KBOTTGER Time . . . : 11:34:12 Status . . : Warehouse . . . . . . ------------Zones----------- Start Aisle . . . . . . End Aisle . . . . . . . Bypass Minimum (Y/N) . . ENTER=Generate F3=Exit F12=Cancel

.

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 file. 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.
Bypass Minimum	Defines how the system determines when an item location requires replenishment, and, if a pieces per case is defined for the item, whether the system rounds the calculated replenishment quantity up or down to the nearest case. Valid values: • N (default)= An item location requires replenishment when the calculated on-hand quantity falls below the minimum quantity defined for the item location. If a pieces per case is defined for the item, the system rounds the calculated replenishment quantity up to the nearest case, even if rounding up causes the new on hand quantity to be greater than the maximum quantity defined for the item location. If the replenishment quantity is less than a case quantity, the system replenishes the item location, rounding up to the case quantity. Example: If the replenishment quantity is 20 and the pieces per case for the item is 12, the system rounds the replenishment quantity to 24 (2 cases of 12). If the replenishment quantity is 10 (less than the pieces per case), the system replenishes the item location with 1 case (12 units).
	• Y = An item location requires replenishment when the calculated on-hand quantity is less than the maximum quantity, and if a pieces per case is defined for the item, the calculated replenishment quantity is greater than one case. If the calculated replenishment quantity is less than a case quantity, the system does not replenish the item location. If a pieces per case is defined for the item, the system rounds the calculated replenishment quantity down to the nearest case so that the new on hand quantity is not greater than the maximum quantity defined for the item location. Example: If the replenishment quantity is 20 and the pieces per case for the item is 12, the system rounds the replenishment quantity to 12 (1 case of 12). If the replenishment quantity is 10 (less than the pieces per case), the system does not replenish the item location. See Determining the Locations to Replenish for more information and examples. Alphanumeric, 1 position; required.

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. Press Enter to generate the request. A message such as the following displays:

Job 494947/EKAPLAN/RPLN_STK submitted to job queue QBATCH in library QGPL.

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 replenishment transfer labels when you generate a Replenishment Control.

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

Sample replenishment transfer label:

2007ST3 BLUE WMNS SML ORGANIC COTTON TEE Loc: MAIN1 2007ST3 BLUE WMNS MED ORGANIC COTTON TEE Loc: MAIN1

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 set to N; 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 set to Y.

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

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: Enter 8 next to 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: Enter 5 next to a request at the Work with Replenish Control Screen.

FLR0039 DISPLAY Replenishment Confirmation 8/20/99 16:23:53 By To Location LJW MAIL ORDER COMPANY Warehouse : 100 WAREHOUSE 100 To From Qty to Qty From Opt Loc Loc Item SKU Replenish Moved Loc Typ Cfmd Type options, press Enter. 6=Confirm/unconfirm A010203 B010203 CROCUS BLUE 1 1 S Y A010203 C010203 CROCUS PINK 1 1 B Y F3=Exit F9=Process F12=Cancel F15=By Item F16=By from Location

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 (split SKU) or one 14-position field (full SKU); 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 displays. 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 entering 6 next to the location. Enter Y or N to display items whose confirmation status matches your entry. Y - the replenishment request for this location is approved. An inventory transfer transaction will be generated when the replenishment control request is processed. N - 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 N. The default for requests generated by the system as let down replenishment during pick slip generation is Y. Alphanumeric, 1 position; optional.

Screen Option	Procedure
Confirm or unconfirm replenishment of an item/SKU to this location	Enter 6 next to the item/SKU to be replenished to change the confirmed status of the item/SKU transfer.
Process the Replenishment Control request	Press F9 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	Press F15 to display the Replenishment Confirmation by Item Screen.
Display the Replenishment Control request in 'From' location sequence	Press F16 to display the Replenishment Confirmation by From Location Screen.

Instructions:

1. Enter 6 next to the replenishment transfer you wish to confirm. The code in the Cfmd field will change to Y.

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 displays: Quantity to move cannot be greater than replenish quantity.

3. To unconfirm a replenishment transfer, enter 6 next to it. The code in the Cfmd field will change to N. The transaction will be deleted from the request when it is processed.

4. Press F3 or F12 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. Press F9 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 files 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: Press F15 at the Replenishment Confirmation By To Location Screen or the Replenishment Confirmation by From Location Screen.

FLR0041 DISPLAY Replenishment Confirmation by Item 8/23/99 15:10:50 LJW MAIL ORDER COMPANY Warehouse : 100 WAREHOUSE 100 To From Qty to Qty From Opt Item SKU Loc Loc Replenish Moved Loc Typ Cfmd Type options, press Enter. 6=Confirm/unconfirm CROCUS BLUE A010203 B010203 1 1 S Y CROCUS PINK A010203 C010203 1 1 B Y F3=Exit F9=Process F12=Cancel F14=By to Location F16=By from Location F21=Print Listing

Screen Option	Procedure
Confirm or unconfirm replenishment of an item/SKU	Enter 6 next to an item/SKU to change the confirmed status of the item/SKU transfer.
Process the replenishment control request	Press F9 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	Press F14 to display the Replenishment Confirmation By To Location Screen.
Display the replenishment control request in 'from' location sequence	Press F16 to display the Replenishment Confirmation by From Location Screen.
Print the Replenishment Detail Report by Item	Press F21.

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: Press F16 at the Replenishment Confirmation By To Location Screen or the Replenishment Confirmation by Item Screen.

FLR0040 DISPLAY Replenishment Confirmation 8/23/99 15:45:01 By From Location LJW MAIL ORDER COMPANY Warehouse : 100 WAREHOUSE 100 From From To Qty to Qty Opt Loc Typ Loc Loc Item SKU Replenish Moved Cfmd Type options, press Enter. 6=Confirm/unconfirm B C010203 A010203 CROCUS PINK 1 1 Y S B010203 A010203 CROCUS BLUE 1 1 Y F3=Exit F9=Process F12=Cancel F14=By to Location F15=By item F21=Print Listing

Screen Option	Procedure
Confirm or unconfirm replenishment to this location	Enter 6 next to and item/SKU to change the confirmed status of the item/SKU transfer.
Process the replenishment control request	Press F9 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	Press F14 to display the Replenishment Confirmation By To Location Screen.
Display the replenishment control request in item sequence	Press F15 to display the Replenishment Confirmation by Item Screen.
Print the Replenishment Detail by 'From' Location Report	Press F21.

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 file 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 using option 4.

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 option 9 at the Work with Replenish Control Screen, or you can press F9 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: Enter 4 next to 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 displays:

Cannot delete - confirmed records pending

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