9 Using Inventory Inquiry

Inventory inquiry enables you to request inventory information on an item. Oracle Retail Store Inventory Management must be purchased and implemented in order to use inventory inquiry. Inventory inquiry is disabled in transaction re-entry mode.

Inventory Inquiry can be accessed on the Main Options and Price Inquiry screens. For information on Price Inquiry, see "Price Inquiry" in Chapter 3.

The following functions are described in this chapter:

• "Searching for Inventory Information"

• "Searching for Item Inventory"

• "Searching for Item Inventory on the List of Items"

• "Viewing the Inventory Results"

Searching for Inventory Information

The Item Inquiry fields are described in Table 9-1. The item number and item description fields are always available. The other search fields are only available when that search criteria has been enabled.

All or part of the item number, item description, or manufacturer can be entered. An asterisk can be used as a wildcard. The following formats are accepted. Item description is used for the examples:

• If part of the description is entered, such as dishes, Point-of-Service searches for item descriptions that have dishes in any part of the description. For example, dinner dishes, dishes for kids, and seasonal dishes to order would be matches.

• If an asterisk is used as a suffix, such as dishes*, Point-of-Service searches for item descriptions that start with dishes. For example, dishes for kids would be a match.

• If an asterisk is used as a prefix, such as *dishes, Point-of-Service searches for item descriptions that end with dishes. For example, dinner dishes would be a match.

• The asterisk can also be placed anywhere in the description. For example, dinner dishes and dishes for kids would be matches for di*s.

• To see all items, you enter just an asterisk.

To search for inventory information on an item:

1. On the Main Options screen, press Inventory Inquiry/F9.

2. Enter your user ID and password. After logging in, the Item Inquiry screen appears.

   Figure 9-1 Item Inquiry Screen

   
   

   Table 9-1 Item Inquiry Fields

   Field	Description
   Item Number	Unique identifying number or SKU number used to identify the item. All or part of the item number can be entered or an asterisk can be used as a wildcard, as described above.
   Item Description	Description of the item. All or part of the item description can be entered or an asterisk can be used as a wildcard, as described above.
   Manufacturer	Name of the manufacturer of the item. This field is only displayed if searching for an item by manufacturer is enabled. All or part of the manufacturer name can be entered or an asterisk can be used as a wildcard, as described above.
   Department	Department where the item is defined. If <All> is selected, you must enter an item number, item description, or manufacturer in any of those fields. A wildcard can be used. This field is only displayed if searching for an item by department is enabled.
   Item Type	The type of item, which may be stock item, service item, store coupon, or unknown. An example of a service item is delivery. This field is only displayed if searching for an item by item type is enabled.
   Unit of Measure	How the item is measured, for example, pounds or liters. This field is only displayed if searching for an item by unit of measure is enabled.
   Style	Style of the item, generally used for apparel. This field is only displayed if searching for an item by style is enabled.
   Color	Color of the item, generally used for apparel. This field is only displayed if searching for an item by color is enabled.
   Size	Size of the item, generally used for apparel. This field is only displayed if searching for an item by size is enabled.

   
   

3. Enter the search information and press Next/Enter.

   • If one item is found that matches the search information, the Item Inq - Item Display screen appears. Continue at "Searching for Item Inventory".

   • If more that one item is found that matches the search information, the Item Inq - Item List screen appears. Continue at "Searching for Item Inventory on the List of Items".

   • If the item is not found in the current store, the Item Not Found Notice dialog appears. Press Enter. The Item Inq - Item Display screen appears. You can search for the item at other stores. Continue at "Searching for Item Inventory".

Searching for Item Inventory

If one item is found that matches the search information, the Item Inq - Item Display screen appears. If a picture of the item is available, it appears.

Figure 9-2 Item Inq - Item Display Screen

1. Select the stores to be searched for inventory:

   • To search the current store, press Home Store/F2.

   • To search in those stores most often used for transfers to the current store, press Buddy Store/F3. The Minimum Qty Available screen appears. Enter the minimum quantity of the item required, and press Next/Enter.

   • To search in any store that allows transfers to the current store, press Transfer Zone/F4. The Minimum Qty Available screen appears. Enter the minimum quantity of the item required and press Next/Enter.

   • To search a specific store, press Specific Store/F5. The Specific Store screen appears. Enter the store number and press Next/Enter.

2. The Inventory Results screen appears. Continue at "Viewing the Inventory Results".

Searching for Item Inventory on the List of Items

If more than one item is found that matches the search information, the Item Inq - Item List screen appears.

Figure 9-3 Item Inq - Item List Screen

1. Select an item in the list.

2. Select to view details on the item or select the stores to be searched for inventory:

   • To see detailed information on the item, press Detail/F2. The Item Inq - Item Display screen appears. Continue at "Searching for Item Inventory".

   • To search the current store, press Home Store/F3.

   • To search in those stores most often used for transfers to the current store, press Buddy Store/F4. The Minimum Qty Available screen appears. Enter the minimum quantity of the item required and press Next/Enter.

   • To search in any store that allows transfers to the current store, press Transfer Zone/F5. The Minimum Qty Available screen appears. Enter the minimum quantity of the item required and press Next/Enter.

   • To search a specific store, press Specific Store/F6. The Specific Store Input screen appears. Enter the store number and press Next/Enter.

3. The Inventory Results screen appears. Continue at "Viewing the Inventory Results".

Viewing the Inventory Results

The Inventory Results screen shows the inventory information for the selected item.

Figure 9-4 Inventory Results Screen

Note: Price is only displayed for results on the Home Store.

Select a store and choose an option:

• To print the item, store, and inventory information, press Print/F2. A receipt prints with the information.

• To view details of the inventory in the selected store, press Detail/F3. The Inventory Details screen appears.

  Figure 9-5 Inventory Details Screen

  
  
  
  

  Note: Price is only displayed for results on the Home Store.

  
  

  When done viewing the information, press Done/F2. You are returned to Main Options or Price Inquiry screen.

• To view information on the selected store, press View Store Info/F4. The Store Info screen appears.

  Figure 9-6 Store Info Screen

  
  

  When done viewing the information, press Done/F2. You are returned to the Main Options or Price Inquiry screen.

• To search for another item, press New Search/F5. You are returned to the Item Inquiry or Price Inquiry screen.

• When done viewing the information, press Done/F6. You are returned to the Main Options or Price Inquiry screen.