Purpose: A retail store is a warehouse in CWSerenade that represents an actual store where consumers can purchase merchandise. Once you set up the retail store in Creating and Maintaining Warehouses (WWHS), you can:
• create store promotions for the retail store. A store promotion is a sale for specific items in selected stores. During the promotion, you can define a sale price for the items in the promotion and increase the amount of inventory you keep in the store for the duration of the promotion.
• create retail store restock orders as a means to transfer stock to selected stores, generate pick slips for the restock orders, and process the transfer of inventory from your main warehouse to the stores.
• download items, customer address changes, A/R bill to accounts, purchase order, and inventory recount requests to the retail store.
• upload sold to customer addresses, purchase order receipts, and store add-on requests from retail stores into CWSerenade.
In this topic:
• Understanding Store Promotions
• Minimum and Maximum Override Dates
• Step 1: Which Stores are Eligible for Restock?
• Step 2: Which Items in Each Store Need More Inventory?
• Step 3: Creating a Store Restock Order
• Step 4: Generating a Pick Slip for the Store Restock Order
• Step 5: Confirming Shipment of a Store Restock Order
• Creating Store Restock Orders in Order Entry
• Understanding Store Promotions
• Setting up Store Restock Information
• Setting up Store Restock Information
• Retail Store Related System Control Values
Understanding Store Promotions
About store promotions: A store promotion is a sale for specific items in selected stores. You can set up two types of store promotions:
• Discount promotion. A discount promotion is a promotion you define for specific items that are on sale for a discounted price. For example, you can create a “back to school” promotion for school supplies in your store. Each school supply item is sold at a reduced price for the length of the promotion. You can also increase the amount of inventory you keep in the store for each item in the promotion.
• Minimum/maximum promotion. A minimum/maximum promotion is a promotion you define for specific items that are not sold at a reduced price. Instead, you wish to change the amount of inventory you keep in the store for each item. For example, you can create a “summer specials” promotion for summer items in your store. Each summer item, such as flip flops or fans, is sold at regular price, but you expect an increase in sales because the items will be more in demand.
See Working with Store Promotions (WSPR).
Store promotion type: In order to define whether a store promotion is a discount promotion or a minimum/maximum promotion, you must set the Minimum/maximum only field for the store promotion type correctly.
• If the Minimum/maximum only field for the store promotion type is selected, the system identifies the promotion as a minimum/maximum promotion. When this field is selected, the system does not allow you to define a price for an item or set up an item as free of charge for the promotion.
• If the Minimum/maximum only field for the store promotion type is unselected, the system identifies the promotion as a discount promotion. When this field is unselected, the system requires you to define a price for an item or set up the item as free of charge for the promotion.
See Working with Store Promotion Types (WSPT) for more information on setting up store promotion types.
Store promotion start/end dates: When you set up a store promotion, you must define the date the store promotion begins and the date the store promotion ends.The system uses the start date and end date to determine when the store should begin preparing for the sale and when the store should begin preparing for the next sale, or reduce the inventory to its normal inventory and/or price.
Minimum and Maximum Override Dates
The system uses the start date and end date to determine when the amount of stock in the store should be changed for the store promotion and when the amount of stock should be reduced to its normal amount.
Minimum/maximum lead days: The system uses the Store Promotion Minimum/Maximum Lead Days (G18) system control value to determine the minimum/maximum override start date. The system subtracts the number in this system control value from the promotion start date to determine the minimum/maximum override start date.
Example: |
promotion start date = 6/6 minimum/maximum lead days = 4 6/6 - 4 = 6/2 (6/2 is the minimum/maximum start date; this is the date the store changes the minimum quantity and maximum quantity in the store for the specified items so that the items are available for the promotion). |
Minimum/maximum end days: The system uses the Store Promotion Minimum/Maximum End Days (G19) system control value to determine the minimum/maximum override end date. The system subtracts the end days from the promotion end date to determine the minimum/maximum override end date.
Example: |
promotion end date = 6/12 minimum/maximum end days = 4 6/12 - 4 = 6/8 (6/8 is the minimum/maximum end date; this is the date the store changes the minimum quantity and maximum quantity in the store for the specified items back to the items regular inventory amount so that the store is not overstocked). |
When the current date falls between the minimum/maximum override start date and the minimum/maximum override end date, the system looks at the minimum quantity and the maximum quantity for the rank associated with the store to determine how much inventory the store needs to restock the store for the promotion.
The system uses the start date and end date to determine the pricing start date and the pricing end date.
The store uses the pricing start date to determine when the prices of items in the promotion should be changed to the promotion price and uses the pricing end date to determine when the prices of items in the promotion should be changed back to the normal store price.
Pricing lead days: The system uses the Store Promotion Pricing Lead Days (G16) system control value to determine the pricing start date. The system subtracts the pricing lead days from the promotion start date to determine the pricing start date.
Example: |
promotion start date = 6/6 pricing lead days = 2 6/6 - 2 = 6/4 (6/4 is the pricing start date; this is the date the store changes the item's price so that the items are sold at the promotion price). |
Pricing end days: The system uses the Store Promotion Pricing End Days (G17) system control value to determine the pricing end date. The system subtracts the pricing end days from the promotion end date to determine the pricing end date.
Example: |
promotion end date = 6/12 pricing end days = 2 6/12 - 2 = 6/10 (6/10 is the pricing end date; this is the date the store changed the item's price back to its regular price). |
Store promotion items: For each item in the store promotion, you can define:
• a promotion price if the Minimum/maximum only field for the store promotion type is unselected. The system uses the promotion price to override the item's regular store price during the store promotion. The system uses the pricing start date to determine when the item should be priced at the promotion price and uses the pricing end date to determine when the item should be changed back to its regular store price.
• a minimum quantity and maximum quantity for each store rank. The system uses the minimum and maximum quantities to override the item's regular minimum and maximum quantities if the date when you perform the store restock falls between the minimum/maximum override start date and the minimum/maximum override end date for the store promotion.
Store promotion notifications: Once the current date is 7 days from the start date of a promotion, you can generate a Store Promotion Notification.
The store promotion notification lists the promotions assigned to each store and the items that are in the promotion. The store can use the notification to prepare for the store promotion.
Retail store promotion:
About retail store restock: Store restock orders are a means for you to pick inventory from your main warehouse for shipment to retail stores in order to replenish their stock.
You can use Working with Retail Store Restock (WRSR) to generate retail store restock orders. You can also enter restock orders in order entry.
Generating store restock orders automatically: As part of generating restock orders through Working with Retail Store Restock (WRSR), the system determines the items and quantities to include for each selected retail store by checking whether:
• the quantity available in the retail store is less than the maximum quantity required. The system uses the item warehouse information you have set up for the warehouse that represents the retail store to determine the maximum quantity for the item in the retail store.
• the item is in an active promotion for the retail store, and the maximum quantity of the item in the promotion is greater than the current quantity available in the store. You can set up a promotion for a retail store in Working with Store Promotions (WSPR).
In order to create retail store restock orders, you associate a Customer Sold To record with the warehouse representing the retail store. The Working with Retail Store Restock (WRSR) menu option uses this customer when creating the store restock orders.
Generating pick slips for retail store restock orders: The Working with Retail Store Restock (WRSR) menu option not only creates the retail store restock orders, it then applies pick slip preparation to the order and generates the pick slips that you use to pick the inventory from your main warehouse and prepare it for shipment to the retail stores. If you enter retail store restock orders in order entry, you need to generate pick slips in a separate step.
Picks are created for the From whse specified for the retail store, which is normally your main picking warehouse.
Confirming shipment of retail store restock orders: When you confirm shipment of a retail store restock order, the system normally processes a transfer inventory transaction rather than an issue transaction, as it does when you ship an order to a customer. You can also configure your retail stores so that backordered items cancel automatically at the time you confirm shipment.
Retail store restock:
The steps the system takes when generating store restock orders through the Working with Retail Store Restock (WRSR) menu option are described below.
Step 1: Which Stores are Eligible for Restock?
The system determines if the stores selected for store restock are eligible for restock. In order for a store to be eligible for restock:
• the Active restock field for the store must be unselected. This field indicates whether an open store restock order already exists for the store. You cannot submit another restock for the store until the existing restock order is completed (shipped or canceled).
• the Restock customer field for the store must specify a customer that also has the warehouse code identifying the retail store specified in the Warehouse field.
Step 2: Which Items in Each Store Need More Inventory?
The system uses the value in the Restock Type field for the store to determine which items in the store are in need of restock. You can set the Restock Type field to the following values:
• Full (full restock to highest maximum quantity) = the system restocks items whose on-hand quantity is less than or equal to the highest minimum.
• Out of Stock Only = the system restocks items whose on-hand quantity equals zero if the store's item maximum is greater than zero.
• Loose Pick = the system restocks items flagged with the Location Class for Loose Pick Store Restock (G22), and uses the “out-of-stock-items-only” restock logic to restock the item. For any items that are not flagged with a location class, the system uses the full restock logic to determine how to restock the item.
Full restock: When the Restock Type field for the store is set to Full (full restock to highest maximum quantity), the system restocks items whose on-hand quantity is less than or equal to the minimum:
Example: |
Item |
Minimum quantity |
Maximum quantity |
On-hand quantity |
|
A123 |
12 |
36 |
16 |
|
B456 |
24 |
40 |
6 |
|
C789 |
8 |
16 |
8 |
When you perform a restock for the store, the system:
• does not include item A123, because the on-hand quantity is above the minimum.
• includes item B456, because the on-hand quantity is less than the minimum, and uses a quantity of 34 so that the item is restocked to its maximum.
• includes item C789, because the on-hand quantity equals the minimum, and uses a quantity of 8 so that the item is restocked to its maximum.
Out of stock restock: When the Restock Type field for the store is set to Out of Stock Only, the system restocks items whose on-hand quantity is zero or less if the store's item maximum is greater than zero:
Example: |
Item |
Minimum quantity |
Maximum quantity |
On-hand quantity |
|
A123 |
12 |
36 |
16 |
|
B456 |
24 |
40 |
0 |
|
C789 |
8 |
16 |
-8 |
When you perform a restock for the store, the system:
• does not include A123, because the on-hand quantity is more than zero.
• includes item B456, because the on-hand quantity is zero, and uses a quantity of 40 since that is the maximum.
• includes item C789, because the on-hand quantity is less than zero (that is, it is backordered in the retail store), and uses a quantity of 16 since that is the maximum. Note: The system does not consider the backorder quantity when calculating the restock quantity.
Loose pick restock: When the Restock Type field for the store is set to L (loose pick), the system restocks items flagged with the Location Class for Loose Pick Store Restock (G22), using Out of Stock Only criteria.
If an item has not been assigned to a location class, the system restocks the item using the Full criteria.
Example: |
Location class for loose pick store restock = LP |
||||
|
Item |
Location class |
Minimum quantity |
Maximum quantity |
On-hand quantity |
|
A123 |
LP |
12 |
36 |
16 |
|
B456 |
LP |
24 |
40 |
0 |
|
C789 |
HL |
8 |
16 |
0 |
|
D123 |
|
4 |
8 |
1 |
When you perform a restock for these items, the system:
• does not include item A123, because the on-hand quantity is greater than zero.
• includes item B456, because the on-hand quantity is zero and the item’s class matches the Location Class for Loose Pick Store Restock (G22). The quantity is 40, since this is the maximum.
• does not include item C789, because the location class for the item does not match the Location Class for Loose Pick Store Restock (G22).
• includes item D123, because the on-hand quantity is less than the minimum and the item is not assigned to a location class. The quantity is 7, so that the item will be restocked to the maximum.
For each type of restock, you can also include any items from a store add-on request. For example, a store might require an additional quantity if an item was previously out of stock and the store has issued several rain checks. See Working with Add on Request Items (WSAI) for more information.
Items excluded from restock: Regardless of the setting of the Restock Type field, the system excludes items from restock if:
• the Excl store restock (Exclude from retail store restock) field for the item/SKU is selected. The system includes item/SKUs that have this field selected in a store add-on request, but the item is canceled immediately.
• the item’s Status matches the Default Item Status for Exclusion on Store Restock Orders (G24).
Determining the highest min/max: You can define minimum and maximum quantities for an item in the item warehouse, or any active store promotions for the store’s rank. When restocking an item, the system uses the highest minimum and maximum quantities it finds.
Note: The system can combine the minimum and maximum quantities from different sources. For example, it might use the highest minimum quantity from the item warehouse, and the highest maximum quantity from an active promotion.
Pieces per case?
• If a Pieces/case number has not been specified for the item, the system uses the restock quantity from the above calculation as the restock order quantity.
• If a Pieces/case number has been specified for the item, then the restock quantity is the multiple of the pieces/case number that is closest to the calculated restock quantity.
Example:
• If the pieces/case is 20 and the calculated restock quantity is 45, the system creates a restock quantity of 40 (20 * 2).
• If the pieces/case is 20 and the calculated restock quantity is 55, the system creates a restock quantity of 60 (20 *3).
You specify the pieces/case through Performing Initial Item Entry (MITM).
Note: The system does not consider the pieces/case for an item on a store add-on request.
Step 3: Creating a Store Restock Order
The system creates a store restock order for each store that has items in need of restock as described above. The Maximum Number of Lines to Include on Store Restock Order (I51) system control value identifies the number of order detail lines the system can include on a store restock order before creating a new order.
Store add-on request items: The system adds any store add-on request items to the end of the order. For each store add-on request item, the system creates an order line message indicating the item is a store add-on, using a print code of I so that the message prints on the shipping confirmation.
Store add-on request items that have the Exclude store restock field selected are added to the order, but the order detail line is canceled automatically using the Default Cancel Reason Code for Store Restock Orders (G21).
Order edits: Once the system creates the restock order, it edits the orders for correct data.
• If there are errors on the restock order, the system generates the Phone Errors Report and assigns the restock order to the next available order batch number. You can correct the errors in batch order entry.
• If there are no errors and the order is not placed on hold, the system performs pick slip preparation and generates a pick slip for the order using the pick slip generation selection option selected when you used Working with Retail Store Restock (WRSR).
See Setting up Store Restock Information for a description of the information that the system requires in order to generate store restock orders.
Troubleshooting: If using the Working with Retail Store Restock (WRSR) menu option does not produce a store restock order, confirm that the Restock Type is not blank for the retail store, and that the Active flag is unselected. If the Type is blank or the Active flag is selected, the system does not generate store restock orders. To reset the Active flag, you need to confirm shipment of or cancel any open orders for the Customer # assigned to the retail store. See the Create Store Screen for a discussion of these fields.
Step 4: Generating a Pick Slip for the Store Restock Order
If there are no errors on the store restock order, and the order is not placed on hold, the system performs pick slip preparation and generates a pick slip for the order using the pick slip generation selection option selected when you used Working with Retail Store Restock (WRSR).
Pick slips are generated in the From whse specified for the retail store, which is normally your main picking warehouse.
Which locations are used to fulfill the store restock request? The setting of the Fulfill Restock Orders from Bulk Only (J85) system control value controls which locations in the main picking warehouse are used to fulfill the store restock request.
• If this system control value is selected, the system fulfills the store restock order from eligible bulk locations in earliest placement date/item location creation sequence. See Fulfilling Restock Orders from Bulk Locations Only.
• If this system control value is unselected, the system fulfills the store restock order using regular pick slip generation allocation logic. See Fulfilling Restock Orders Using Pick Slip Allocation Logic.
Excluded locations: The system does not include locations in the store restock fulfillment if:
• The quantity in the location is already allocated to an outstanding replenishment.
• The location is on any type of freeze. The system considers a location frozen if:
• the Freeze field for the location is selected.
• the Reservation freeze field for the item warehouse is selected.
• the Reservation freeze field for the item location is selected.
• the Physical freeze field for the item location is selected.
Troubleshooting: If the system generates a store restock order but does not generate a pick slip, it might be because the order was put on hold. Use the Release Held Orders Screen (Working with Releases) to release the order from hold, and then use Streamlined Pick Slip Generation (WSPS) to generate pick slips, making sure to select an option that has the Restock orders only flag selected.
Fulfilling Restock Orders from Bulk Locations Only
If the Fulfill Restock Orders from Bulk Only (J85) system control value is selected, the system fulfills the store restock order from eligible bulk locations in earliest placement date/item location creation sequence.
Note: The bulk locations used to fulfill the store restock order can be flagged as pickable or non-pickable. Pickable bulk locations are not given a higher consideration over non-pickable bulk locations.
If the bulk locations cannot fulfill the store restock quantity: If the quantity that is available to pick from the eligible bulk locations does not cover the store restock quantity, the system does not include the item on the store restock request. The system displays the item on the Item Stock Allocation Error Report:
Loc |
Error |
Pick |
Order |
Item |
Ordered |
Avl |
C1 |
No Bulk Loc Avl |
999 |
9999 |
AB10 |
50 |
10 |
The setting of the Withhold Picks due to Item Allocation Error (F04) system control value controls whether the system generates a pick slip for the other items on the store restock order or whether the entire store restock order is excluded from pick slip generation until all of the items on the order can be fulfilled.
If the item does not have a bulk location defined: If the item on the store restock order is not associated with a bulk location, the system prints the item on the Item Stock Allocation Error Report:
Loc |
Error |
Pick |
Order |
Item |
Ordered |
Avl |
NOBULK |
No Bulk Loc Avl |
999 |
9999 |
AB10 |
50 |
0 |
To correct the error, you can:
• cancel the order line on the store restock order and perform a manual inventory adjustment to move the stock out of a primary location for the store. In this situation, the item will not display on the purchase order created in CWStore and the stock for the item will need to be manually adjusted into CWStore.
• perform a manual inventory adjustment to move the stock into a bulk location. When you run pick slip generation for the store restock order, the system will fulfill the item on the store restock order from the bulk location. In this situation, the item displays on the purchase order created in CWStore.
Store Restock, Fulfill from Bulk Locations Only: Example 1
In this example, the Fulfill Restock Orders from Bulk Only (J85) system control value is selected, indicating the system fulfills store restock orders from bulk locations only.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
500 |
0 |
0 |
9/1/07 |
0 (not bulk loc) |
C1 |
Bulk |
N |
50 |
0 |
0 |
8/1/07 |
50 |
C2 |
Bulk |
N |
750 |
0 |
0 |
9/1/07 |
750 |
C3 |
Bulk |
N |
50 |
0 |
0 |
7/5/07 |
50 |
Total quantity available to pick: |
850 |
||||||
A customer places a store restock order for item AB10 for a quantity of 150.
When you generate a pick slip for the store restock order, the system generates a pick slip for the store restock order, taking:
• 50 units from bulk location C3
• 50 units from bulk location C1
• 50 units from bulk location C2
Store Restock, Fulfill from Bulk Locations Only: Example 2
In this example, the Fulfill Restock Orders from Bulk Only (J85) system control value is selected, indicating the system fulfills store restock orders from bulk locations only.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
0 |
0 |
50 |
|
0 (not bulk loc) |
C1 |
Bulk |
N |
50 |
0 |
0 |
8/1/07 |
50 |
C2 |
Bulk |
N |
750 |
0 |
0 |
9/1/07 |
750 |
C3 |
Bulk |
N |
50 |
0 |
50- |
7/5/07 |
0 |
Total quantity available to pick: |
800 |
||||||
A customer places a store restock order for item AB10 for a quantity of 130.
When you generate a pick slip for the store restock order, the system generates a pick slip for the store restock order, taking:
• 50 units from bulk location C1
• 80 units from bulk location C2
Store Restock, Fulfill from Bulk Locations Only: Example 3
In this example, the Fulfill Restock Orders from Bulk Only (J85) system control value is selected, indicating the system fulfills store restock orders from bulk locations only.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
0 |
0 |
50 |
|
0 (not bulk loc) |
C1 |
Bulk |
N |
40 |
0 |
0 |
8/1/07 |
40 |
C2 |
Bulk |
N |
750 |
0 |
0 |
9/1/07 |
750 |
C3 |
Bulk |
N |
50 |
0 |
50- |
7/5/07 |
0 |
Total quantity available to pick: |
790 |
||||||
A customer places a store restock order for item AB10 for a quantity of 150.
When you generate a pick slip for the store restock order, the system generates a pick slip for the store restock order, taking:
• 40 units from bulk location C1
• 110 units from bulk location C2
Fulfilling Restock Orders Using Pick Slip Allocation Logic
If the Fulfill Restock Orders from Bulk Only (J85) system control value is unselected, the system fulfills the store restock order using regular pick slip generation allocation logic:
• Allocate the entire quantity from the item’s primary location.
• If multiple primary locations exist, the system attempts to allocate the entire quantity from a single primary location.
• If the quantity on the pick cannot be allocated in full from a single primary location, and the Check Location Quantities During Pick Generation (C54) system control value is selected, the system tries to allocate the entire quantity from a single pickable secondary location or bulk location (in that order).
• If the quantity on the pick cannot be allocated in full from a single pickable location, the system allocates the quantity across pickable primary, secondary, and bulk locations (in that order) in location sequence.
System control values related to allocating stock:
• Check Location Quantities During Pick Generation (C54): Determines whether the system considers available inventory in allocating stock, or allocates from the primary location only. See Replenish Primary Locations Overview.
• Let Down Replenishment (C36): Defines whether the system performs Let Down Replenishment when you generate pick slips, and whether the replenishments will be immediately processed based on the system-recommended inventory transfers, or will be recommended but not processed. See Let Down Replenishment for an overview.
• Include Bulk Locations in Primary Primary Availability (F87): If selected, the system includes bulk locations quantity in available pick quantity for the primary location. After you have generated pick slips, you must run the Replenish Primary Locations program to transfer inventory from the bulk location to the primary primary location
• Include Secondary Locations in Primary Primary Availability (F88): If selected, the system includes the quantity in secondary locations in the available pick quantity for the primary primary location. After you have generated pick slips, you must run the Replenish Primary Locations program to transfer inventory in the bulk location to the primary primary location.
If the locations cannot fulfill the store restock quantity: If the quantity that is available to pick from the eligible locations does not cover the store restock quantity, the system does not include the item on the store restock request. The system displays the item on the Stock Allocation Error report:
Loc |
Error |
Pick |
Order |
Item |
Ordered |
Avl |
C1 |
Loc unpickable |
999 |
9999 |
AB10 |
220 |
20 |
C2 |
Loc unpickable |
999 |
9999 |
AB10 |
220 |
20 |
C2 |
No stock in Pck |
999 |
9999 |
AB10 |
220 |
20 |
The setting of the Withhold Picks due to Item Allocation Error (F04) system control value controls whether the system generates a pick slip for the other items on the store restock order or whether the entire store restock order is excluded from pick slip generation until all of the items on the order can be fulfilled.
Store Restock, Fulfill Using Pick Allocation Logic: Example 1
In this example:
• The Fulfill Restock Orders from Bulk Only (J85) system control value is unselected, indicating the system fulfills store restock orders using regular pick slip allocation logic.
• The Check Location Quantities During Pick Generation (C54) system control value is selected, indicating the system attempts to allocate stock from the first pickable location (primary, secondary, or bulk) with enough inventory to fulfill the order.
• The Let Down Replenishment (C36) system control value is set to NONE, indicating the system does not perform Let Down Replenishment.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
A2 |
Primary |
Y |
30 |
10 |
0 |
1/7/08 |
20 |
B1 |
Secondary |
Y |
30 |
0 |
0 |
1/7/08 |
30 |
B2 |
Secondary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
C1 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
C2 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
Total quantity available to pick: |
60 |
||||||
A customer places a store restock order for item AB10 for a quantity of 28.
When you generate a pick slip for the store restock order, the system takes 28 units from location B1 to fulfill the store restock order.
Store Restock, Fulfill Using Pick Allocation Logic: Example 2
In this example:
• The Fulfill Restock Orders from Bulk Only (J85) system control value is unselected, indicating the system fulfills store restock orders using regular pick slip allocation logic.
• The Check Location Quantities During Pick Generation (C54) system control value is unselected, indicating the system allocates from the primary location only.
• The Let Down Replenishment (C36) system control value is set to NONE, indicating the system does not perform Let Down Replenishment.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
A2 |
Primary |
Y |
30 |
10 |
0 |
1/7/08 |
20 |
B1 |
Secondary |
Y |
30 |
0 |
0 |
1/7/08 |
30 |
B2 |
Secondary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
C1 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
C2 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
Total quantity available to pick: |
60 |
||||||
A customer places a store restock order for item AB10 for a quantity of 28.
When you generate a pick slip for the store restock order, the system takes 28 units from location A1 to fulfill the store restock order. Because location A1 only has 10 units available, you will need to move stock into the location in order to fulfill the store restock order.
Store Restock, Fulfill Using Pick Allocation Logic: Example 3
In this example:
• The Fulfill Restock Orders from Bulk Only (J85) system control value is unselected, indicating the system fulfills store restock orders using regular pick slip allocation logic.
• The Check Location Quantities During Pick Generation (C54) system control value is selected, indicating the system attempts to allocate stock from the first pickable location (primary, secondary, or bulk) with enough inventory to fulfill the order.
• The Let Down Replenishment (C36) system control value is set to NONE, indicating the system does not perform Let Down Replenishment.
The following item locations exist for item AB10 in the main picking warehouse.
Loc |
Type |
Pickable |
O/H |
Printed |
Pending |
Date |
Qty Avl to Pick |
A1 |
Primary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
A2 |
Primary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
B1 |
Secondary |
Y |
10 |
0 |
0 |
1/7/08 |
10 |
B2 |
Secondary |
Y |
15 |
0 |
0 |
1/7/08 |
15 |
C1 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
C2 |
Bulk |
N |
50 |
0 |
0 |
1/7/08 |
0 (not pickable) |
Total quantity available to pick: |
45 |
||||||
A customer places a store restock order for item AB10 for a quantity of 45.
When you generate a pick slip for the store restock order, the system takes:
• 10 units from location A1.
• 10 units from location A2.
• 10 units from location B1.
• 15 units from location B2.
Step 5: Confirming Shipment of a Store Restock Order
Billing updates: When you confirm shipment of the restock order, the billing async job performs the following updates:
• the Quantity sold, Dollars sold, Quantity no duplicate, and Dollars no duplicate fields in the Store Promotion Item table are increased.
• if the Automatic cancel backorder field for the sold-to customer on the restock order is selected, the Automatic cancel backorder field on the order was to selected when the order was created. As a result, any backorder quantity on an order detail line is canceled and the system uses the Default Cancel Reason Code for Store Restock Orders (G21) to cancel the order detail line.
Performing an inventory transfer: When you confirm shipment of a retail store restock order, the system processes a transfer inventory transaction. This transfer moves the inventory from your main picking warehouse (the From whse specified for the retail store) as follows:
• If there is an In-transit warehouse and In-transit location specified for the retail store, the inventory is transferred there when you confirm shipment. Using an in-transit warehouse and location enables you to track the status of inventory that is in shipment and has not yet arrived at the retail store. You will need to perform a transfer at a later date from the in-transit warehouse and location to the warehouse that represents your retail store and its Auto restock location. When the store receives the shipment, you can perform the transfer either through a menu option such as Working with Inventory Transactions in Batch Mode (WITB) or through the Generic Inventory Transaction Upload.
• If there is no In-transit warehouse and In-transit location specified for the retail store, the inventory is transferred directly to the warehouse that represents the retail store and its Auto restock location when you confirm shipment.
The updates that take place when you confirm shipment are the same regardless of whether you generated the retail store restock orders through the Working with Retail Store Restock (WRSR) menu option or in order entry.
Also, once the restock order has been billed and has been closed or canceled, the system unselects the Active field for the store so that the store is eligible for another restock order.
Troubleshooting:
• If an item stock allocation error occurs for any item on the retail store restock order, the system does not automatically cancel the order, and as a result does not reset the Active flag for the retail store warehouse. Until the Active flag for the retail store warehouse is unselected, you cannot use Working with Retail Store Restock (WRSR) to generate retail store restock orders for the retail store. To correct, use order maintenance to cancel the item on the order that caused the item stock allocation error. See the Item Stock Allocation Error Report for a list of conditions that can cause an item stock allocation error.
• If there is not either an Auto restock location or In-transit warehouse and In-transit location specified for the retail warehouse at the time you confirm shipment, the system does not process an item transfer; instead, it processes an issue transaction (I) as it would for a standard order shipment.
Reports generated: During the store restock process through Working with Retail Store Restock (WRSR), the system generates the following reports:
• Phone Errors Report: lists any errors on the store restock orders
• Store Selection Exception - Store Restock Generation Report: lists any stores that are not eligible for store restock
• Anticipated Store Restock Generation - Restock Summary Report: lists the stores that were eligible for store restock
• Order Batch Listing: this report is generated if the restock orders did not contain any errors; if the order had errors, you must first correct them
Store restock confirmations: Once you have confirmed the store restock order, you can generate a Store Restock Shipping Confirmation, which you can mail or fax to your retail store. The store restock shipping confirmation lists each store, the restock order number associated with the store, and the items that have been shipped to the store.
Anticipated retail store restock: When you generate an anticipated store restock, the system determines which stores are in need of restock, which items in each store need more inventory, and how much inventory is needed; it then produces two reports that allow you to “look ahead” to determine when you need to perform an actual store restock.
The two reports the anticipated store restock generates are:
• Store Selection Exception Report - Anticipated Store Restock
• Anticipated Store Restock Generation - Restock Summary Report
Creating Store Restock Orders in Order Entry
In addition to using the Working with Retail Store Restock (WRSR) menu option, you can enter store restock orders in order entry. The system identifies the order as a store restock order if:
• the order type matches Default Order Type for Store Restock Orders (G23) system control value
• the customer sold-to has a Warehouse specified at the Second Create Customer Sold To Screen that matches a retail store
In this situation, the system selects the Store restock order flag on the order header.
Generating pick slips: To generate pick slips for store restock orders you enter in order entry, use the Streamlined Pick Slip Generation (WSPS) menu option, making sure to select a pick slip generation template that has the Restock orders only flag selected. See Step 4: Generating a Pick Slip for the Store Restock Order for more information on how the system fulfills the store restock order.
Confirming shipment: When you confirm shipment of a store restock order entered in order entry, the system performs the same updates as described above under Step 5: Confirming Shipment of a Store Restock Order.
Advancing to the store screen: In order to set up a warehouse to represent a retail store, you must:
• select the Use Retail Store File (G15) system control value. This system control value controls whether you advance to the Store screen, where you can set up and maintain retail store information for the warehouse.
• select the Retail store field for the warehouse to indicate it represents a retail store.
If you do not have both of these values selected, you do not advance to the Store screen.
When you set up retail store information for a warehouse, you can define information for the store, such as:
• store information
• restock information
• sales information
• item warehouse information
Store information: You can define store information for the store, such as:
• the region and district where the store is located
• when the store opened, relocated, and closed
• the phone number, speed dial number, and modem number for the store
• whether the store is active (that is, the store is open for business), or inactive (that is, the store is new and not yet open for business)
Most of these fields are informational only; in other words, they do not control functionality in the system.
Setting up Store Restock Information
If you are going to be using store restock orders to transfer inventory from your main warehouse to the store location, you need to complete the following setup in addition to the Retail Store Related System Control Values:
Information |
Menu Option |
Used How? |
Field at Change Store screen |
customer who represents the retail store location |
The system assigns this customer to orders generated through the Working with Retail Store Restock (WRSR) menu option. Also, if you enter an order for this customer and use the Default Order Type for Store Restock Orders (G23), the system flags the order as a retail store restock order, processing a transfer when you confirm shipment of the order rather than a regular order shipment. If the Auto can B/O (Automatically cancel backorders) field for the restock customer is selected, the system sets the Cancel backorder field on the order to Selected. |
Customer # |
|
order type to identify store restock orders |
Specify this order type in the Default Order Type for Store Restock Orders (G23) system control value to have the system use this order type when you use the Working with Retail Store Restock (WRSR), and identify a store restock order when you use this order type in order entry |
N/A |
|
ship via to assign to store restock orders |
The system assigns this ship via to orders generated through the Working with Retail Store Restock (WRSR) menu option. |
Ship via |
|
source code to use on store restock orders |
The system assigns this source code to orders generated through the Working with Retail Store Restock (WRSR) menu option. Typically, you create a separate source code for these orders, using a different pricing method than on source codes you use for customer orders. |
Source |
|
pay type |
The system assigns this pay type to orders generated through the Working with Retail Store Restock (WRSR) menu option. Typically, you create a new cash pay type that has a very high Order $ limit in order to prevent retail store restock orders from going on hold, and to create separate postings to the General Ledger Interface table. |
Pay type |
|
restock location in retail store |
The location in the retail store where the system transfers the stock after you confirm shipment of the retail store restock order. You define this location at the Create Warehouse Screen or the Change Warehouse screen. See also the In-Trans whs (In-transit warehouse) and In-Trans location (In-transit location), described below. |
N/A |
Setting up additional replenishment fields at the Change Store screen: In addition to the information listed in the above table, use the Change Store screen to indicate:
• From warehouse: The main warehouse where the retail store restock orders should be reserved.
• Type (Restock type): Indicates the logic that the system should use in determining when an item needs to be restocked in the retail store. You must select a Type in order to have the Working with Retail Store Restock (WRSR) generate store restock orders for the retail store. See Understanding Store Restock for a discussion.
• In-Trans whs (In-transit warehouse) and In-Trans location (In-transit location): Optionally, you can specify an in-transit warehouse and location to have the system process a transfer to this warehouse and location when you confirm shipment of a store restock order. Using the in-transit warehouse and location allows you to better identify inventory that you have shipped from your main warehouse, but which has not yet arrived at the retail store.
The remaining fields in the Replenishment area of the screen are informational only.
Setting up item warehouse information for retail store restock: You need to set up an item warehouse record for each item you need to restock in the retail store, including:
• a minimum quantity and maximum quantity for the item in the store
• an original retail price for the item in the store
• a current retail price for the item in the store
You can use the Work with Item Warehouse Screen or the Work with Item Warehouse Values screen to specify these values.
Sales information: You can define sales information for the store, such as:
• the customer the system uses as the sold to and ship to customer when you upload retail orders from an external system if the order does not contain a customer number.
• the ship via code the system uses when you upload retail orders from the external system
• the source code the system uses when you upload retail orders from the external system.
Related secured features: You can update item warehouse information for warehouses that represent retail stores in Creating and Maintaining Warehouses (WWHS) or Working with Item Warehouse Values (WIWV).
• In order to update the Original retail price, Current retail price or Protect price fields for an item warehouse, you must have access to the Maintain Item Warehouse Retail Price (A91) secured feature.
• In order to update the Minimum quantity, Maximum quantity, or Protect minimum and maximum quantity fields for an item warehouse, you must have access to the Maintain Item Warehouse Minimum/Maximum Quantity (A92) secured feature.
Retail Store Related System Control Values
System Control Value |
Description |
Indicates whether you advance to the Store screen when you are working with a warehouse that represents a retail store. |
|
Store Promotion values: |
|
The number of days the system uses to calculate a pricing start date for a store promotion. |
|
The number of days the system uses to calculate a pricing end date for a store promotion. |
|
The number of days the system uses to calculate a minimum/maximum override start date for a store promotion. |
|
The number of days the system uses to calculate a minimum/maximum override end date for a store promotion. |
|
Store Restock values: |
|
Not currently implemented. |
|
The cancel reason code the system defaults to a restock order detail line that is automatically canceled during billing. |
|
The location class the system uses to determine the items that can be included in a loose pick store restock. |
|
The order type the system defaults to store restock orders. |
|
Default Item Status for Exclusion on Store Restock Orders (G24) |
The item status the system uses to determine if an item is excluded from store restock orders. |
The program name the system uses to translate CWSerenade item and SKU codes to another system's item and SKU codes. |
|
Maximum Number of Lines to Include on Store Restock Order (I51) |
The maximum number of order detail lines the system can include on a store restock order before creating a new order. When you perform a store restock, the system creates a separate order detail line for each item eligible for restock. |
Select this field if you wish to fulfill store restock orders from bulk locations only. |
|
Related menu options: In order to define a region or rank for a store you must create valid region and rank codes. Additionally, you must create store promotion type codes to identify the type of store promotion to run for a store. See:
• Working with Store Ranks (WSTR) on how to create and maintain codes that represent a store rank.
• Working with Store Regions (WSRG) on how to create and maintain codes that represent a region where a store is located.
• Working with Store Promotion Types (WSPT) on how to create and maintain codes that represent a type of store promotion.
| Retail Stores | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Store Ranks (WSTR) |
WH15_01 OROMS 5.0 2018 OTN