Purpose: Use the Work with Item Warehouse function to indicate the warehouses where you keep an item, and to define information particular to that item/warehouse combination.
In this topic:
• Work with Item Warehouse Screen
• Create Item Warehouse Screen
• Change Item Warehouse Screen
• Display Item Warehouse Screen
• Enter Serial Numbers Screen (Performing a Count)
Work with Item Warehouse Screen
How to display this screen: From the Work with Items Screen:
• for a non-SKUed item, enter 13 next to the item
• for a SKUed item, first enter 7 next to the item to advance to the Work with SKUs Screen, then enter 13 next to the SKU
INR0114 DISPLAY Work with Item Warehouse 10/25/05 13:12:57 KAB Co
Item : FR78 GREEN PEEPER FROG PLUSH TOY SKU : Resv Opt Whse Description On Hand On Order Protected Freeze
Type options, press Enter. 2=Change 4=Delete 5=Display 18=Serial # Count 20=Locations 21=Pending Details 98=User Field
3 TAN CATALOG WAREHOUSE N 9 PENDING PUTAWAY WAREHOUSE 3 3 N 20 WAREHOUSE 20 FOR YEAR 2002 999972 36 N 30 THE STAGING WAREHOUSE 1 N 40 WAREHOUSE 40 N
F3=Exit F6=Create F12=Cancel F21=Print list |
Field |
Description |
Whse (Warehouse) |
The warehouse where you keep an item. Numeric, 3 positions; optional. |
Description |
The description of the warehouse. Alphanumeric, 30 positions; optional. |
On hand |
The number of units of this item across all locations in the warehouse. Numeric, 7 positions; optional. |
The number of units that are due to be received in this warehouse through purchase orders. Numeric, 7 positions; optional. |
|
Protected |
An amount of inventory protected from reservation for this item or SKU across all locations in this warehouse. The system uses the value in this field to reserve the component items on a finished good work order if Use Work Order Processing (E37) is set to Y in the System Control file. See Warehousing Finished Good Work Order Processing (WWOR) for more information on work orders. Numeric, 7 positions; optional. |
Resv Freeze (Reservation freeze) |
This value indicates whether the item or SKU in this warehouse is frozen. Valid values are: Y = The item/SKU warehouse is frozen. N = The item/SKU warehouse is not frozen. If an item or SKU warehouse is frozen: • Pick Slip Generation ignores the item warehouse when determining where inventory should be picked to fulfill an order. See Introducing Pick Slip Generation. • Inventory does not reserve during Order Entry. See Reviewing Reservation Types. • Replenish Warehouses and Replenish Primary Locations do not replenish stock to or from the location. Alphanumeric, 1 position; optional. |
.
Screen Option |
Procedure |
Create an item warehouse record |
Press F6 to advance to the Create Item Warehouse Screen. |
Change item warehouse information |
Enter 2 next to an item warehouse record to advance to the Change Item Warehouse Screen. |
Delete item warehouse information |
Enter 4 next to an item warehouse record to delete it. If there are dependent records associated with this warehouse, the system will display a warning message. Deleting this warehouse will also delete the following dependent records: • Item location • Item transaction history • Item transaction summary • Item warehouse history • Physical inventory Note: You cannot delete an item/warehouse record if there are open orders, quantity on hand, or quantity on order. |
Display item warehouse information |
Enter 5 next to an item warehouse record to advance to the Display Item Warehouse Screen. |
Perform a serial number count |
Enter 18 next to an item warehouse record to advance to the Enter Serial Numbers Screen (Performing a Count). |
Work with item locations |
Enter 20 next to an item warehouse record to advance to the Work with Item Locations Screen. See Warehousing Creating and Maintaining Item Warehouses. |
Review pending putaways details |
Enter 21 next to an item warehouse record to advance to the Display Pending Putaway Details Screen (PO Warehouse View). An error message displays if the warehouse is not defined as a pending putaway (PP) or pending transfer (PT) warehouse in the Working with Default Warehouse Locations (WWDL) menu option: No Pending Putaway Details associated with Warehouse. |
Work with user defined fields |
Enter 98 next to an item warehouse to advance to the Work with User Fields Screen. |
Purpose: At the Work with Item Warehouse Screen, press F6.
INR0112 ENTER Create Item Warehouse 5/19/99 13:37:08 KAL Co.
Item . . : GO87 COLORING BOOK SKU . . . : Warehouse .
Reservation freeze . . (Y/N)
Protected qty . . . : Min qty . . . . . . . Protect Min/Max . N Max qty . . . . . . . Economic order qty . . Reorder qty . . . . .
Original retail price Protect Price . . N Current retail price .
User Field 1 . . . . . User Field 2 . . . . .
F3=Exit F12=Cancel |
Field |
Description |
Warehouse |
A code that represents a warehouse or retail store. Warehouse codes are defined in and validated against the Warehouse file. See Warehousing Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions. Create screen: required. Change screen: display-only. |
This value indicates whether the item or SKU in this warehouse is frozen. Valid values are: Y = The item/SKU warehouse is frozen. N = The item/SKU warehouse is not frozen. If an item or SKU warehouse is frozen: • Pick Slip Generation ignores the item warehouse when determining where inventory should be picked to fulfill an order. See Introducing Pick Slip Generation. • Inventory does not reserve during Order Entry. See Reviewing Reservation Types. • Replenish Warehouses and Replenish Primary Locations do not replenish stock to or from the location. Alphanumeric, 1 position; required. |
|
The unit quantity of this item/SKU protected from reservation. The system will not reserve this inventory except through Working with Interactive Reservation (MIRV), which you might use for large wholesale orders or preferred mail order customers. Protected quantity is included in on-hand quantity. This quantity is also protected from being used to replenish another warehouse. You cannot enter an amount in this field if the Use Work Order Processing (E37) field in the System Control file is set to Y. Numeric, 7 positions; optional. |
|
Min qty. (Minimum quantity) |
The minimum number of units to be kept on hand in the warehouse. When the on-hand quantity falls below this amount, the item is eligible for replenishment through standard warehouse replenishment. The system updates the minimum quantity if you enter a new minimum quantity in Work with Item Warehouse Values and the Protect minimum/maximum field is set to N. See Warehousing Working with Item Warehouse Values (WIWV). Numeric, 7 positions; optional. |
Protect min/max (Protect minimum and maximum quantities) |
This value indicates whether the system overrides the minimum or maximum quantity when you change the minimum or maximum quantity in Working with Item Warehouse Values (WIWV). Valid values are: Y = The system does not update the minimum or maximum quantity when you define a new minimum or maximum quantity in Work with Item Warehouse Values, and instead, keeps the existing quantity. N (default) = The system updates the minimum or maximum quantity with the minimum or maximum quantity you defined in Work with Item Warehouse Values. This field displays only if the Use Retail Store File (G15) system control value is set to Y. |
|
An error message displays if you try to change this value and you do not have authority to the Maintain Item Warehouse Minimum/Maximum Quantity (A92) secured feature:
Not authorized to change.
Alphanumeric, 1 position; required. |
Max qty. (Maximum quantity) |
The maximum number of units to be kept on hand. If you do not specify a reorder quantity (below), the system uses this value to determine the quantity to reorder by subtracting the on-hand quantity from the maximum quantity. The system updates the maximum quantity if you enter a new maximum quantity in Working with Item Warehouse Values (WIWV) and the Protect minimum/maximum field is set to N. Numeric, 7 positions; optional. |
Economic order qty. (Economic order quantity) |
The recommended optimum ordering quantity for this item or SKU, based on a set of criteria such as quantity, cost, etc. This value is used for inventory reporting purposes only. Numeric, 7 positions; optional. |
Reorder qty. (Reorder quantity) |
The quantity of this item or SKU that should be replenished when the item or SKU reaches the minimum stock level for the warehouse. This value is used in Replenish Warehouses. Numeric, 7 positions; optional. |
Original retail price |
The original price of this item in the retail store. You can use this field to track the original retail price for the item if the warehouse represents a retail store. This field displays only if the Use Retail Store File (G15) system control value is set to Y. Numeric, 7 positions with a 2-place decimal; optional. |
Protect price (Protect current price) |
This value indicates whether the system overrides the price defined in the Current retail price field when you change the retail price in Working with Item Warehouse Values (WIWV). Valid values are: Y = The system does not update the price defined in the Current retail price field when you define a new retail price in Work with Item Warehouse Values, and instead, keeps the existing price. N (default) = The system updates the price defined in the Current retail price field with the retail price you defined in Work with Item Warehouse Values. This field displays only if the Use Retail Store File (G15) system control value is set to Y. An error message displays if you try to change this value and you do not have authority to the Maintain Item Warehouse Retail Price (A91) secured feature: Not authorized to change. Alphanumeric, 1 position; required. |
Current retail price |
The current price of this item in the retail store. You can use this field to track the current retail price for the item if the warehouse represents a retail store. The system updates the current retail price if you enter a new retail price in Working with Item Warehouse Values (WIWV) and the Protect price field is set to N. This field displays only if the Use Retail Store File (G15) system control value is set to Y. Numeric, 7 positions with a 2-place decimal; optional. |
User field 1 |
An informational field where you can enter additional item warehouse information. Alphanumeric, 10 positions; optional. |
User field 2 |
An informational field where you can enter additional item warehouse information. Alphanumeric, 10 positions; optional. |
To change: Enter 2 next to a warehouse at the Work with Item Warehouse Screen to advance to the Change Item Warehouse screen. At this screen you can change any information except the Item and Warehouse. See Create Item Warehouse Screen for field descriptions.
Note: You cannot change the Protected quantity field on this screen if you have entered values in the Use Work Order Processing (E37) field in the System Control file.
Secured features:
• The system displays the following error message if you try to change the Minimum quantity, Maximum quantity, or Protect minimum/maximum field and you do not have authority to the Maintain Item Warehouse Minimum/Maximum Quantity (A92) secured feature:
Not authorized to change.
• The system displays the following error message if you try to change the Original retail price, Current retail price, or Protect price field and you do not have authority to the Maintain Item Warehouse Retail Price (A91) secured feature:
Not authorized to change.
To display: Enter 5 next to a warehouse at the Work with Item Warehouse Screen to advance to the Display Item Warehouse screen. You cannot change any information on this screen. See Create Item Warehouse Screen for field descriptions.
Enter Serial Numbers Screen (Performing a Count)
Purpose: Use this screen to enter each serial number currently on-hand for an item or SKU in a warehouse. You might use this screen if you believe that the serial number records for an item or SKU are inaccurate, or if you have just turned on serial number tracking for the item and need to create the serial number records. When you complete this screen, the system updates the serial number records for this item or SKU, creating new records or flagging unentered serial numbers as unavailable, as appropriate.
Before entering a count: Before entering a serial number count, you should make sure that any pending transactions against any unit of the serial numbered item is complete, including any shipments in the process of confirmation, warehouse transfers, and so on. Taking this step will help prevent potential errors.
Additional information: You can also use the Work with Serial Numbers Screen, available through option 18 at the Work with Items Screen or Work with SKUs Screen, to create, change, or delete serial number records individually.
Screens related to serial numbers are available only for items whose Serial number field is set to Y.
See the Work with Serial Numbers Screen for an overview of how serial numbers are tracked through the system.
How to display this screen: Enter 18 next to an warehouse at the Work with Item Warehouse Screen. (Note: this option is available only through the Work with Items/SKUs menu option (fast path = MITM), and only for items set up for serial number processing.)
INR1070 CHANGE Enter Serial Numbers 7/01/97 9:03:05 EZK Mail Order
Item: PR600 Qty: 24 Whse: 2
Serial #
F3=Exit F9=Accept F12=Cancel |
Field |
Description |
Item |
The item code and SKU, if any, for which you are entering a serial number count. Item code: alphanumeric, 12 positions; display-only. SKU: alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only. |
Qty (Quantity) |
The total unit quantity of the item or SKU in the warehouse indicated. The screen provides a field for entry of a serial number for each unit on hand. Numeric, 7 positions; display-only. |
Whse (Warehouse) |
The code representing the warehouse where the item or SKU is kept. Numeric, 3 positions; display-only. |
Serial # |
The serial number(s) of each unit of the item or SKU in the warehouse indicated. This screen provides a field for entry of a serial number for each unit on hand. Alphanumeric, 20 positions each field; required. |
Instructions: To complete a serial number count:
1. Enter the serial number for each unit of the item in the warehouse indicated in each field provided.
1. When you have completed each serial number field on the screen, press Enter. The system highlights any serial number fields that are not complete. Complete any fields and press Enter again.
2. Press F9 to submit the serial number count; otherwise, press F3 or F12 to cancel. If you press F9, the confirm accept window displays:
Confirm Accept
Press ENTER to confirm Accept.
F12=Cancel
|
3. Press Enter to confirm; otherwise, press F12 to cancel.
Serial number updates: When you process the serial number count, the system updates the serial number records for the item in the warehouse as follows:
• If you entered a serial number that already existed:
• if the serial number was on-hand, with a status of received (R) or customer return (C), there is no change.
• if this was a serial number that you had previously recorded as being not on hand, with a status of returned to vendor (V), not on-hand (D), or shipped (S), the status of the serial number is changed to received (R), which makes it eligible for shipment, transfer, and so on. In addition, the system changes the warehouse code of the serial number to match the warehouse where you are currently working, if necessary. (Note: If the serial number is currently in use (status of U) because of a pending shipment, transfer, etc., the system does not change the serial number.)
• If you entered a serial number that did not already exist, the system creates a new serial number record for the item in the warehouse. The serial number will have a status of received (R), which makes it eligible for shipment, transfer, and so on, and the Receipt date will contain the date of the serial number count; however, there will be no purchase order associated with the serial number.
• If you did not enter a serial number that existed previously:
• if this was a serial number that you had previously recorded as being not on hand, with a status of returned to vendor (V), did not exist (Z), not on-hand (D), or shipped (S), there is no change to the serial number record.
• if this was a serial number that you had recorded as being on-hand, with a status of received (R) or customer return (C), the status of the serial number changes to not on-hand (D), and the Not on-hand date will contain the date of the serial number count.
• If you enter a serial number that exists in a different warehouse: the warehouse code changes to reflect the warehouse where you are performing the serial number count.
| Assigning Items/SKUs to Offers | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Entering Additional Item Information |
ME03_05 CWDirect 18.0.x 2018 OTN