Using Inventory Inquiry (DINI)
Purpose: Inventory inquiry allows you to review on hand quantities in each warehouse and in each location in a warehouse. This function can be used by several departments within your organization and provides a way to display item/SKU information quickly.
Other options: You can use the following additional menu options for inventory inquiry:
• Inventory Inquiry by Item (IIQI): to review item information organized by the base item and the first SKU element
• Inventory Status Inquiry (ISIQ): to review order activity for any item or SKU broken out by offer
In this chapter:
• Inventory Quantity Inquiry Prompt Screen
• Display Item/Warehouse Information Screen
• Display Inventory Warehouses Screen
• Display Inventory Locations Screen
• Inventory On Hand by Location Selection Screen
• Inventory On Hand by Location Screen
• Display Open Purchase Orders Screen
• Display Item Warehouse History Screen
• Display SKU (Base Information) Screen (Non-SKU’ed Item)
• Display SKU - 1 of 2 (With Overrides) Screen
• Display SKU - 2 of 2 (With Overrides) Screen
Inventory Quantity Inquiry Prompt Screen
Purpose: Use this screen to enter information for the Item/SKU/Warehouse that you want to review.
How to display this screen: Enter DINI in the Fast Path field at the top of any menu.
Using this screen:
• Use the top portion of the screen to enter warehouse, item and SKU information for inquiry. You advance to the Display Item/Warehouse Information Screen. The Default Warehouse (A04) from the System Control table defaults.
• If you enter only the base item code and not a specific SKU for a SKU’ed item, the quantity information you see will be the sum of all SKUs for the item.
• Use the lower portion of the screen to scan quickly for items by class, item status, item description, buyer, department, vendor, SKU status, SKU description, compatibility, or category, or a combination of these fields. You advance to the Item/SKU Selection Screen.
Field |
Description |
Class |
A code to identify a group of items. Item class codes are used as a high- level method to sort inventory, define information templates at the item class level, assign city/state restrictions, and assign customer class restrictions, and are defined in and validated against the Item Class table; see Working with Item Classes (WICL). Alphanumeric, 3 positions; optional. |
Item Status |
A code that represents an item's status, such as obsolete, discontinued, etc. You can define this code at the item or the SKU level. Item status codes are defined in and validated against the Item Status table; see Working with Item Status (WIST). Alphanumeric, 1 position; optional. |
Item description |
The description of the item. You can enter any portion of the description. Alphanumeric, 120 positions; optional. |
Buyer |
A person authorized to make purchases. Buyer codes are defined in and validated against the Buyer table; see Working with Buyers (WBUY). Alphanumeric, 3 positions; optional. |
Department |
The department to which the item belongs. Department codes are defined in and validated against the Long SKU Department table; see Working with Long SKU Departments (WLSD). Numeric, 4 positions; optional. |
Vendor |
The supplier of an item. Vendor numbers are defined in and validated against the Vendor table; see Working with Vendors (WVEN). Numeric, 7 positions; optional. |
SKU Status |
A code that represents a SKU’s status, such as obsolete, discontinued, etc. You can search for an item through either its item or SKU status. The status might differ at the item and SKU level if, for example, you discontinue the "Green" SKU for the base item "Sweater." All other SKUs will have the status you defined at the base item level, but you assign the green sweater a discontinued SKU status in addition to the defined item status. This SKU status now overrides the base item status throughout the system. SKU status codes are defined in and validated against the Item Status table; see Working with Item Status (WIST). Alphanumeric, 1 position; optional. |
SKU description |
The description of the SKU. You can enter any portion of the description. Alphanumeric, 40 positions; optional. |
Compatibility |
A code assigned to items/SKUs to identify them as compatible items. You might assign a compatibility code of IBM, for example, to all IBM products such as a PC, printer, etc., to indicate that these items work together. The compatibility code is a user-defined code that is not validated by the system. Alphanumeric, 3 positions; optional. |
Category |
A category assigned to the item to classify and group similar items. The Item Category is a level below the Item Class. Validated against the Item Category table; see Working with Item Category Codes (WITG). Alphanumeric, 4 positions; optional. |
Purpose: Use this screen to select a specific item/SKU for inventory inquiry.
How to display this screen: Complete scanning information on the lower portion of the Inventory Quantity Inquiry Prompt Screen.
Selecting an item: You can use the fields in the top portion of this screen to scan further for an item, or you can select an item by selecting it. See Inventory Quantity Inquiry Prompt Screen for field descriptions.
Screen Option |
Procedure |
Select an item |
Select an item to advance to the Display Item/Warehouse Information Screen. |
Display item details |
Select Item Details for an item to advance to the Display Item Screen. |
Display SKU details |
Select SKU Details for a non-SKU’d item to advance to the Display SKU (Base Information) Screen (Non-SKU’ed Item); or select SKU Details for a SKU’d item to advance to the Display SKU - 1 of 2 (With Overrides) Screen. |
Display Item/Warehouse Information Screen
Purpose: Use this screen to review information for an item/SKU in the warehouse.
How to display this screen:
• Select an item at the Item/SKU Selection Screen
• Enter a valid item and warehouse number at the Inventory Quantity Inquiry Prompt Screen
• Select Display Info at the Display Inventory Warehouses Screen, the Display Inventory Locations Screen, the Inventory On Hand by Location Selection Screen, or the Inventory On Hand by Location Screen
All fields are display-only.
Field |
Description |
Item description (unlabeled field) |
The description of the item. Alphanumeric, 120 positions; display-only. |
Item |
A code to identify a unit of inventory. Alphanumeric, 12 positions; display-only. |
SKU unlabeled field to the right of the item |
The item’s unique characteristics, such as its color and size. Alphanumeric, three 4-position fields; display-only. |
SKU description unlabeled field below the item description |
The description of the SKU, if this is a SKU’ed item. Alphanumeric, 40 positions; display-only. |
U/M Unit of measure |
The multiples in which you buy the item from the vendor. See Working with Units of Measure (WUOM). Alphanumeric, 3 positions; display-only. |
The Status for the SKU, if any; otherwise, the Status for the item, if any. The description is to the right. Alphanumeric, 1 position; display-only. |
|
Whse Warehouse |
A code that represents the warehouse where the item is stored. Warehouse codes are defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; display-only. |
Location |
The “primary primary” location, which is stored in the Primary location field in the SKU table. The location code represents the area within the warehouse that contains the item/SKU. Typically, the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates: Zone Aisle Shelf Bin A 01 02 01 See Creating and Maintaining Locations (WLOC). Alphanumeric, 7 positions; display-only. |
Buyer |
This code identifies the person who purchased this item from the vendor. Validated against the Buyer table (see Working with Buyers (WBUY)), and used primarily for reporting purposes. It does not default on POs. Alphanumeric, 3 positions; display-only. |
Short SKU |
The short SKU code for the item/SKU, as defined in the SKU table. The system assigns the short SKU number when the item/SKU is created using the next number available in the Short SKU (A12) number assignment value. Numeric, 7 positions; display-only. |
Offer |
The code for the offer (catalog) where the item currently appears. You use the Create Item Offer Screen or the Create SKU Offer Screen to assign an item or SKU to an offer. Defaults from the most current SKU/offer with a current price, if any; otherwise, it defaults from the most current item/offer with a current price. If there is no current item/offer or SKU offer, the system displays a message: NO CURRENT OFFER Alphanumeric, 3 positions; display-only. |
Page |
The Page number for the displayed SKU/offer or item/offer, as specified at the Create Item Offer Screen or the Create SKU Offer Screen. Numeric, 5 positions; display-only. |
Offer price |
The price at which you are selling the item or SKU in this offer before applying any discounts. The price defaults from the offer. Numeric, 7 positions with a 2-place decimal; display-only. |
Vendor |
The primary vendor or supplier of the item, as defined in the Item table. Vendor codes are defined in and validated against the Vendor table; see Working with Vendors (WVEN). Numeric, 7 positions; display-only. |
Weight |
The Ship weight for the SKU, if any; otherwise, the Ship wgt. (Shipping weight) for the item, if any. Numeric, 7 positions with a 3-place decimal. |
Kit type |
Identifies a type of kit or set item. Defaults from the Kit type for the item. The description is to the right. Alphanumeric, 1 position. |
S/O control |
The S/O control (Soldout control) code, if any, assigned to the item or SKU. The description is to the right. Soldout control code: alphanumeric, 2 positions; display-only. Description: alphanumeric, 30 positions; display-only. |
The number of units of this item in all locations in this warehouse. Numeric, 7 positions; display-only. |
|
On order |
The total quantity of this item in this warehouse that is due to be received on open purchase orders. This quantity increases when you enter a purchase order and decreases when you receive a purchase order. If you receive purchase orders into suspense, the suspended quantity remains in this total until you place the suspended stock. The Purchase Order Layering process updates this total if the UPDATE_ON_ORDER_FROM_PO_LAYERING property is set to TRUE. However, you should leave this property set to FALSE if you use the Enterprise Order Integration (Future Receipts and Pre-Order Processing). If you use the Enterprise Order Integration (Future Receipts and Pre-Order Processing), the on-order quantity for pre-order items is the same as the PO On Order quantity minus the PO Receipts quantity. Numeric, 7 positions; display-only. |
Next exptd delivery (Next expected delivery) |
The date that you expect to receive this item from your vendor; this is the date from the PO Layering table. Note: If no entry exists in the PO Layering table or if the PO Layering record has a quantity of zero, then a next expected Po date does not display. This date is displayed for drop ship items only if the Assign Drop Ship Expected Ship Date (I59) system control value is selected. Numeric, 6 positions (in user date format); display-only. |
The quantity of this item/SKU in this warehouse that is reserved for existing orders. This total increases through immediate, batch, and interactive reservation, and decreases through confirmation or pick void/reprint. Numeric, 7 positions; display-only. |
|
All whses (All warehouses) |
The total number of units of this item across all warehouses. Numeric, 7 positions; display-only. |
Last receipt date |
The most recent date when you received the item into the warehouse. Does not update when you receive the item into a different warehouse. Numeric, 6 positions (in user date format); display-only. |
The quantity of the item/SKU in this warehouse that is currently on open orders but not available in your warehouse. Numeric, 7 positions; display-only. |
|
The quantity of this item/SKU in this warehouse that is reserved and flagged for some type of special handling, such as monogramming, hemming, etc. This total increases through reservation of items/SKUs assigned a special handling code in order entry or maintenance, and decreases through confirmation or pick void/reprint. Numeric, 7 positions; display-only. |
|
Out of stock date |
The last date the on hand level for this item went to zero. Numeric, 6 positions (in user date format); display-only. |
Protected |
The quantity of this item or SKU that is protected from immediate or batch reservation across all locations in this warehouse. The system reserves this inventory only through Working with Interactive Reservation (MIRV), which is used for the manual disbursement of large wholesale orders or preferred mail order customers. Numeric, 7 positions; display-only. |
The total units remaining to be shipped for all open order detail lines, including any quantity reserved and quantity backordered. Reset: You can use the Reset SKU Open Order Quantity (MRSO) option to reset this quantity if the total in the SKU table is incorrect. Numeric, 7 positions; display-only. |
|
Out of stock freq (Out of stock frequency) |
Incremented whenever the on-hand level for this item or SKU reaches zero. Numeric, 7 positions; display-only. |
The quantity of this item or SKU currently available to sell in this warehouse. This quantity includes only reservable locations, not locations defined as defective or return to-vendor. Item availability is calculated as follows: On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity available Numeric, 7 positions; display-only. |
|
SKU future |
The number of units needed to fulfill future orders. Normally, you would run the Evaluate Future Orders periodic function daily to evaluate each order detail line marked as a "future order." This function calculates arrival date as described below and determines if orders should be moved to open and reserved (Immediate Reservation) or open and backordered. Arrival Date calculation: Arrival date - Reservation Lead Days (from system control value) = Date If the resulting date is today's date or earlier, the system attempts to reserve inventory. See the Reservation Lead Days (B27) system control value. Numeric, 7 positions; display-only. |
Open D/S |
The total quantity on open drop-ship orders. Reset: You can use the Reset SKU Open Order Quantity (MRSO) option to reset this quantity if the total in the SKU table is incorrect. Numeric, 7 positions; display-only. |
Pickable |
The total quantity of pickable stock in this warehouse. The pickable quantity is equal to the sum of all on hand quantity in all pickable locations in the warehouse. Numeric, 7 positions; display-only. |
Pre-order |
Indicates whether this is a pre-order item for which you can accept orders before you expect to have inventory to fulfill. The OCDSFA and PREORDER periodic functions, which are part of the Enterprise Order Integration (Future Receipts and Pre-Order Processing), set this flag and handle updates and orders for pre-order items that are fulfilled through the integration with Order Broker. Possible settings: • selected = This is a pre-order item, and orders will be submitted to Order Broker as inventory becomes available. • unselected = This is not a pre-order item. This flag is unselected at item creation, and you cannot change its setting at a screen. Only the periodic functions mentioned above update this flag. Display-only. |
SKU - susp (SKU suspended) |
The total quantity received but not yet placed into a specific location. Increases through purchase order receiving and decreases through purchase order suspense placement. Numeric, 7 positions; display-only. |
Recv’d (Received) |
The number of units received in this warehouse. • MTD = Month to date • YTD = Year to date • LTD = Life to date These totals increase through receiving (not suspense placement). Numeric, 7 positions each; display-only. |
Issued |
The total number of units shipped from this warehouse. • MTD = Month to date • YTD = Year to date • LTD = Life to date These totals increase through billing. Increases occur for drop ship, variable sets, and sets. Returns do not decrease this number. If you ship merchandise without affecting inventory (e.g., express bill), this field does not update. Numeric, 7 positions each; display-only. |
Retn’d (Returned) |
The total number of units that have been returned by customers into this warehouse. • MTD = Month to date • YTD = Year to date • LTD = Life to date. These update through order or return authorization processing. Numeric, 7 positions each; display-only. |
Adjusted |
The total number of inventory adjustments that have been made through A type inventory transactions only. • MTD = Month to date • YTD = Year to date • LTD = Life to date. The net value is indicated. For example, if you adjust one location up 10 units, and another location down 3, the total adjusted quantity is 7. Numeric, 7 positions each; display-only. |
The total quantity on purchase orders for a pre-order item. From the RMS On-order quantity, as set by the OCDSFA periodic function. Used to determine the maximum number of pre-order units allowed on orders before selling out the item. This quantity does not decrease based on the PO Receipts quantity; however, the PREORDER periodic function sets this quantity to 0 if the PO Receipts quantity is greater than or equal to the PO On Order quantity, indicating that all open units of the pre-order item have been received on purchase orders, and the item is no longer eligible for pre-order processing. See Enterprise Order Integration (Future Receipts and Pre-Order Processing) for more information. Numeric, 7 positions each; display-only. |
|
The total quantity received on purchase orders for a pre-order item. From the RMS Receipt quantity, as set by the OCDSFA periodic function. Used to determine the number of units of a pre-order item to release to Order Broker for fulfillment. The PREORDER periodic function sets this quantity to 0 if the PO Receipts quantity is greater than or equal to the PO On Order quantity, indicating that all open units of the pre-order item have been received on purchase orders, and the item is no longer eligible for pre-order processing. See Enterprise Order Integration (Future Receipts and Pre-Order Processing) for more information. Numeric, 7 positions each; display-only. |
|
Pre-orders Released |
The total quantity of a pre-order item that has been released to Order Broker for fulfillment. From the RMS Released quantity. See Releasing Eligible Orders to Order Broker for more information. Numeric, 7 positions each; display-only. |
Pre-order Updated |
The most recent date when the pre-order fields (PO On Order, PO Receipts, and Pre-orders Released) were updated through the Enterprise Order Integration (Future Receipts and Pre-Order Processing). Date; display-only. |
Screen Option |
Procedure |
Display inventory warehouse information |
Select Whses/Item to advance to the Display Inventory Warehouses Screen. |
Display inventory location information |
Select Locs/Item to advance to the Display Inventory Locations Screen. |
Display inventory on hand by location |
Select On hand by loc to advance to the Inventory On Hand by Location Selection Screen. |
Display open purchase orders |
Select Open POs to advance to the Display Open Purchase Orders Screen. |
Display components |
Select Display Components to advance to the Work with Set (Variable, Finished good, etc.) screen. If this is a set item, you advance to the appropriate screen based on the type of set: • Work with Set Component Items Screen • Work with Variable Set Components Screen • Work with Finished Good Component Items Screen An error message displays if the item is not defined as a kit type (the Kit type field for the item is blank): Kit Type is blank. You cannot use Display Components. |
Display item warehouse history |
Select History to advance to the Display Item Warehouse History Screen. |
Display Inventory Warehouses Screen
Purpose: Use this screen to review quantity information for an item/SKU across all warehouses.
How to display this screen: Select Whses/Item at the Display Item/Warehouse Information Screen, the Display Inventory Locations Screen, the Inventory On Hand by Location Selection Screen, or the Inventory On Hand by Location Screen. All fields are display-only.
Field |
Description |
Item |
A user-defined code that represents a unit of inventory. Alphanumeric, 12 positions; display-only. |
Warehouse |
A code that represents the warehouse. Warehouse codes are defined in and validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; display-only. |
On hand |
The number of units of this item across all locations in this warehouse. Numeric, 7 positions; display-only. |
Available |
The quantity of this item currently available to sell in the designated warehouse. Takes into account only reservable locations (not locations defined as defective or return to-vendor). Item availability is calculated as follows: On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity available Numeric, 7 positions; display-only. |
Pickable |
The total quantity of pickable stock in this warehouse. The pickable quantity is equal to the quantity on hand minus the quantity printed. Numeric, 7 positions; display-only. |
On order |
The total quantity of this item in this warehouse that is due to be received on open purchase orders. This quantity increases when you enter a purchase order and decreases when you receive a purchase order. If you receive purchase orders into suspense, the suspended quantity remains in this total until you place the suspended stock. If you use the Enterprise Order Integration (Future Receipts and Pre-Order Processing), the PREORDER periodic function sets the on-order quantity for pre-order items to the PO On Order quantity minus the PO Receipts quantity. Numeric, 7 positions; display-only. |
Screen Option |
Procedure |
Display buyer information |
Select Buyer Info to return to the Display Item/Warehouse Information Screen, where buyer information is displayed. |
Display inventory location information |
Select Locs/Item to advance to the Display Inventory Locations Screen. |
Display inventory on hand by location |
Select On hand by Location to advance to the Inventory On Hand by Location Selection Screen. |
Display open purchase orders |
Select Open POs to advance to the Display Open Purchase Orders Screen. |
Display components |
Select Display Components to advance to the Working with Set (Variable, Finished good, etc.) screen. See Working with Sets. Note: Select this option only for items identified as a set, finished good, or variable set. |
Display Inventory Locations Screen
Purpose: Use this screen to review item location information for the specified item or SKU and warehouse.
How to display this screen: Select Locs/Item at the Display Item/Warehouse Information Screen, Display Inventory Warehouses Screen, the Inventory On Hand by Location Selection Screen, or the Inventory On Hand by Location Screen. All fields are display-only.
Field |
Description |
Item |
A code that represents a unit of inventory. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; display-only. |
Warehouse |
The code and description of the warehouse. Warehouse codes are defined in and validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Code: numeric, 3 positions; display-only. Description: alphanumeric, 30 positions; display-only. |
Location |
A code representing the area within the warehouse that contains the item/SKU. Typically, the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates: Zone Aisle Shelf Bin A 01 02 01 Alphanumeric, 7 positions; display-only. |
Location type |
A code that defines the type of location. Valid values are: • Primary = The primary, or main location where the item is picked. The system does not delete a primary item/location record when the on-hand quantity equals zero. • Secondary = Typically, you would use a secondary location for storage when the primary location is full. The system allocates from a secondary location when the total order quantity cannot be filled from the primary location. The system allocates from both the primary and secondary locations when neither location contains enough stock to fulfill the entire order. You can use secondary locations to replenish primary locations. • Bulk = Typically, you would use a bulk location to store unbroken lots or cartons. Bulk locations serve as the replenishment source for primary locations. |
|
• Temporary = Typically, you would use a temporary location to place merchandise that you want recognized as received before you have assigned a permanent location. A temporary location cannot exist without at least one item/location record associated with it. When stock is moved into a temporary location, the system creates an item/location record. When the on-hand in the item/location reaches zero, the system will delete the location and the item/location record. Note: Order Management System will not allocate merchandise from a temporary location even if the location is defined as pickable. In order to allocate stock, you must move the merchandise to a non-temporary, pickable location. Display-only. |
Maximum |
The total unit quantity of the item to keep in this location. Numeric, 7 positions; display-only. |
Minimum |
The least amount of inventory on hand for this item/SKU. Numeric, 7 positions; display-only. |
On hand |
The number of units of this item in this location. Numeric, 7 positions; display-only. |
Printed |
The total quantity printed on an open (unconfirmed) pick slip for the item in this location. Numeric, 7 positions; display-only |
Pending |
The total quantity of the item in this location with a pending batch inventory transaction or work order. Numeric, 7 positions; display-only. |
Pickable |
A code indicating whether inventory can be picked from the location. • Selected = Inventory can be picked from the location. • Unselected = Inventory cannot be picked from the location. Bulk locations, or locations where you keep defective merchandise, might be defined as non-pickable. |
Placement dt (Placement date) |
The date when you first placed the item in this location through purchase order receiving, a customer return, or an adjustment. Numeric, 6 positions (in user date format); display-only. |
Screen Option |
Procedure |
Display buyer information |
Select Buyer Info to return to the Display Item/Warehouse Information Screen, where buyer information is displayed. |
Display inventory warehouse information |
Select Whses/Item to advance to the Display Inventory Warehouses Screen. |
Display inventory on hand by location |
Select On hand by Location to advance to the Inventory On Hand by Location Selection Screen. |
Display open purchase orders |
Select Open POs to advance to the Display Open Purchase Orders Screen. |
Display components |
Select Display Components to advance to the Working with Set (Variable, Finished good, etc.) screen. See Working with Sets. |
Inventory On Hand by Location Selection Screen
Purpose: Use this screen to review the locations that are available for inquiry.
How to display this screen: Select On hand by Location at the Display Item/Warehouse Information Screen, the Display Inventory Warehouses Screen, or the Display Inventory Locations Screen. All fields are display-only.
Field |
Description |
Warehouse |
A code that represents the warehouse, validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; display-only. |
Location |
A that represents a warehouse location where merchandise is stored. The warehouse location code can consist of a zone/aisle/shelf/bin combination, or it can be any user-defined code. The location code prints on picks slips and reports. Example: The location A010201 indicates: Zone Aisle Shelf Bin A 01 02 01 Alphanumeric, 7 positions; display-only. |
Type |
A code that defines the type of location. Valid values are: • P = Primary. The primary, or main location where the item is picked. The system does not delete a primary item/location record when the on-hand quantity equals zero. • S = Secondary. Typically, you would use a secondary location for storage when the primary location is full. The system allocates from a secondary location when the total order quantity cannot be filled from the primary location. The system allocates from both the primary and secondary locations when neither location contains enough stock to fulfill the entire order. You can use secondary locations to replenish primary locations. • B = Bulk. Typically, you would use a bulk location to store unbroken lots or cartons. Bulk locations serve as the replenishment source for primary locations. |
|
• T = Temporary. Typically, you would use a temporary location to place merchandise that you want recognized as received before you have assigned a permanent location. A temporary location cannot exist without at least one item/location record associated with it. When stock is moved into a temporary location, the system creates an item/location record. When the on-hand in the item/location reaches zero, the system will delete the location and the item/location record. Note: Order Management System will not allocate merchandise from a temporary location even if the location is defined as pickable. In order to allocate stock, you must move the merchandise to a non-temporary, pickable location. Alphanumeric, 1 position; display-only. |
Zone/Aise/Shelf/Bin # |
If your warehouse locations consist of a warehouse zone, aisle, bin number, and shelf number combination, separate fields are provided for these values. • Zone = the warehouse zone where the location is situated. Assigning zone codes provides for inventory analysis reporting by zone. Zone codes are also used to sort pick slips when the Cart Bin Picking method is used. • Aisle = the warehouse aisle of the location. • Shelf = the location's shelf number within the aisle. • Bin = the location's bin number on the shelf. Example: The location A010201 indicates: Zone Aisle Shelf Bin A 01 02 01 Alphanumeric, 7 positions; display-only. |
Units |
The total number of units that can fit in the location. Numeric, 7 positions; display-only. |
Weight |
The total weight the location can hold, expressed in pounds. Numeric, 7 position with a 3-place decimal; display-only. |
Volume |
The cubic capacity of the location. The volume calculation multiplies the height, by the length, by the width of the location. Numeric, 7 positions; display-only. |
Screen Option |
Procedure |
Display on hand information |
Select a location to advance to the Inventory On Hand by Location Screen. |
Display buyer information |
Select Buyer Info to return to the Display Item/Warehouse Information Screen, where buyer information is displayed. |
Display inventory warehouse information |
Select Whses/Item to advance to the Display Inventory Warehouses Screen. |
Display inventory location information |
Select Locs/Item to advance to the Display Inventory Locations Screen. |
Inventory On Hand by Location Screen
Purpose: Use this screen to review on hand inventory for items in a particular location.
How to display this screen: At the Inventory On Hand by Location Selection Screen, select a location. All fields are display-only.
Field |
Description |
Whse (Warehouse) |
A code that represents the warehouse, validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; display-only. |
Location |
A code that represents a warehouse location where merchandise is stored. The warehouse location code can consist of a zone/aisle/shelf/bin combination, or it can be any user-defined code. The location code prints on picks slips and reports. Example: The location A010201 indicates: Zone Aisle Shelf Bin A 01 02 01 Alphanumeric, 7 positions; display-only. |
Type |
A code that defines the type of location. Valid values are: • P = Primary. The primary, or main location where the item is picked. The system does not delete a primary item/location record when the on-hand quantity equals zero. • S = Secondary. Typically, you would use a secondary location for storage when the primary location is full. The system allocates from a secondary location when the total order quantity cannot be filled from the primary location. The system allocates from both the primary and secondary locations when neither location contains enough stock to fulfill the entire order. You can use secondary locations to replenish primary locations. • B= Bulk. Typically, you would use a bulk location to store unbroken lots or cartons. Bulk locations serve as the replenishment source for primary locations. |
|
• T = Temporary. Typically, you would use a temporary location to place merchandise that you want recognized as received before you have assigned a permanent location. A temporary location cannot exist without at least one item/location record associated with it. When stock is moved into a temporary location, the system creates an item/location record. When the on-hand in the item/location reaches zero, the system will delete the location and the item/location record. Note: Order Management System will not allocate merchandise from a temporary location even if the location is defined as pickable. In order to allocate stock, you must move the merchandise to a non-temporary, pickable location. Alphanumeric, 1 position; display-only. |
Item |
A code that represents a unit of inventory. Alphanumeric, 12 positions; display-only. |
SKU |
The code that represents the special characteristics of the item (e.g., color, size, width). Alphanumeric, three 4-position fields; display-only. |
On hand |
The number of units of this item in this location in the warehouse. Numeric, 7 positions; display-only. |
Printed |
The number of pick slips printed for this item in the specific location. Numeric, 7 positions; display-only. |
Screen Option |
Procedure |
Display buyer information |
Select Buyer Info to return to the Display Item/Warehouse Information Screen, where buyer information is displayed. |
Display inventory warehouse information |
Select Whses/Item to advance to the Display Inventory Warehouses Screen. |
Display inventory location information |
Select Locs/Item to advance to the Display Inventory Locations Screen. |
Display Open Purchase Orders Screen
Purpose: Use this screen to obtain information about the unreceived or partially received purchase orders for an item. This screen includes the purchase order numbers, vendors, quantities and expected delivery dates for the item.
How to display this screen: Select Open POs at the Display Item/Warehouse Information Screen, the Display Inventory Warehouses Screen, or the Display Inventory Locations Screen
Field descriptions: The Item, SKU and Description fields are described at the Display Item/Warehouse Information Screen. The remaining fields on this screen are:
Field |
Description |
Whs (Warehouse) |
The warehouse where the item will be delivered. Numeric, 3 positions; display-only. |
PO# |
The number of the purchase order on which you ordered the item from the vendor. Numeric, 7 positions; display-only. |
Ln# |
The line number of item on the purchase order. Numeric, 3 positions; display-only. |
Vendor # |
A code to identify the supplier of the item. Vendor codes are defined in and validated against the Vendor table; see Working with Vendors (WVEN). Numeric, 7 positions; display-only. |
Name |
The name of the vendor associated with the vendor number. Blank if the Vendor Name Display (D41) system control value is unselected. Alphanumeric, 30 positions; display-only. |
Qty due (Quantity due) |
The number of units of the item expected in the shipment. Numeric, 7 positions; display-only. |
Date |
The date when the shipment of the item is expected; this is the date from the PO Layering table. If no entry exists in the PO Layering table or if the PO Layering record has a quantity of zero, then a next expected Po date does not display. Numeric, 6 positions (in user date format); display-only. |
Display Item Warehouse History Screen
Purpose: Use this screen to review sale and return information for an item in the specified warehouse.
How to display this screen: Select History at the Display Item/Warehouse Information Screen.
Field |
Description |
Year (Accounting period year) |
The year when the activity occurred. Numeric, 2 positions (YY format); optional. |
Period (Accounting period number) |
The accounting period within the specified year. Accounting periods are defined in and validated against the Accounting Period table; see Working with Accounting Periods (WACP). Numeric, 2 positions; optional. |
Item |
A code that represents a unit of inventory. Alphanumeric, 12 positions; display-only. |
Whse (Warehouse) |
A code that represents the warehouse; defined in and validated against the Warehouse table. Numeric, 3 positions; display-only. |
Today |
Total Sales, Value sales, returns, and Value returns for the current date. These totals are updated during billing and are cleared by the Daily Clear Process periodic function (program name MSR0574). |
Sales today |
The number of sales for this item/SKU in this warehouse for today. Numeric, 11 positions with a 2-place decimal; display-only. |
Value sales today |
The actual dollars sold (shipped and billed) for this item/SKU for today. This total is updated during billing with the actual merchandise dollars billed on the shipment. Numeric, 11 positions with a 2-place decimal; display-only. |
Returns today |
The number of units of this item/SKU in this warehouse returned for today. This total is updated when you receive a returned item through order entry, order maintenance, or return authorizations. Numeric, 11 positions with a 2-place decimal; display-only. |
Value returns today |
The dollar value of all returns that have been received today for this item/SKU in this warehouse. This total is updated when you receive the return through order entry, order maintenance, or return authorizations, using the actual price from when you shipped the item/SKU. Numeric, 11 positions with a 2-place decimal; display-only. |
Purpose: Use this screen to review information for an item.
How to display this screen: Select Display for an item at the Item/SKU Selection Screen.
For more information: See Create Item Screen for field descriptions.
Display SKU (Base Information) Screen (Non-SKU’ed Item)
Purpose: Use this screen to display SKU-level detail information for a non-SKU’ed item.
Non-SKU’ed items: Although a non-SKU’ed item does not contain SKU elements such as color and size, every non-SKU’ed item has one SKU record. This SKU record contains the type of detail information that is kept at the SKU level for SKU’ed items, such as warehouse, location, and costing information.
How to display this screen: Select SKU Details for a non-SKU’d item at the Item/SKU Selection Screen.
For more information: See Create Item (Base Information) Screen for information on each field and option on this screen.
Display SKU - 1 of 2 (With Overrides) Screen
Purpose: Use this screen to review information about a specific SKU.
How to display this screen: Select SKU Details for a SKU’d item at the Item/SKU Selection Screen.
For more information: See Create SKU 1 of 2 (With Overrides) Screen for information on each field and option on this screen.
Display SKU - 2 of 2 (With Overrides) Screen
Purpose: Use this screen to review additional information about a specific SKU.
How to display this screen: Select OK at the Display SKU - 1 of 2 (With Overrides) Screen.
For more information: See Create SKU 2 of 2 (With Overrides) Screen for information on each field and option on this screen.
