IdealWare Online Users Manual

IY3-05-01 I/Y INQUIRY
30976 Product Information Inquiry, Selection

 

PURPOSE

 

The product information inquiry allows you to display product information using a variety of search criteria.

 

The product information inquiry is accessed from any data screen with a PRODUCT or PRODUCT CODE field. The inquiry can also be accessed from:

  • Inventory Maintenance menu.
  • Inventory General Maintenance menu.

The program is composed of the following components:

  1. SELECTION CRITERIA.
  2. PRODUCT DISPLAY OPTIONS.
  3. INDIVIDUAL PRODUCT DISPLAY.

 

PROCEDURE

 

When you press [F5] at any PRODUCT or PRODUCT CODE field, or select Product Inquiry from a menu, the following product selection criteria display.

 

Alternatively you can initiate a product search by key word at any product field by typing a word or partial word and pressing the [F5] key, or initiate a product group search by typing a group code or partial code and pressing the [F6] key.

 

If your system has been configured to display "quick" codes throughout, then pressing [F1], or entering a quick code or partial quick code followed by [F1], at the PRODUCT CODE field anywhere throughout IdealWare, the product inquiry by quick code displays.

 

INQUIRY SELECTION CRITERIA SCREEN - SHORT FORM

┌────────────────────────────────────────────────────────────────────────────────┐
│Oct18/07       ***** INVENTORY PRODUCT INFORMATION INQUIRY *****                â”‚
│                     COMPANY: 01 - D E M O   C O M P A N Y                      â”‚
│                                                                                â”‚
│** ENTER STORE CODE: 01  Ideal Computer Group                                   â”‚
│( 1)  PRODUCT CODE                                                              â”‚
│( 2)  PRODUCT DESCRIPTION                                                       â”‚
│( 3)  WORD SEARCH                                                               â”‚
│( 4)  PRODUCT GROUP & PRODUCT NAME                                              â”‚
│( 5)  QUICK CODE                                                                â”‚
│( 6)  PURCHASE ORDERS BY PRODUCT CODE                                           â”‚
│( 7)  PRODUCT STATUS COLORS                                                     â”‚
│( 8)  ORDER INQUIRY BY PRODUCT                                                  â”‚
│( 9)  EXTRA INQUIRY OPTIONS                                                     â”‚
│                                                                                â”‚
│** ENTER INQUIRY OPTION (F4 TO END): __                                         â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** ENTER STORE CODE:

 

Enter store code.

 

In a single store environment this defaults to the usual store code.

 


** ENTER INQUIRY OPTION (F4 TO END):

 

"1"..."9" to specify desired selection criterion.

 

[F4] to exit inquiry.

 

Selecting "9" EXTRA INQUIRY OPTIONS displays the selection criteria long form.

 

INQUIRY SELECTION CRITERIA SCREEN - LONG FORM

┌────────────────────────────────────────────────────────────────────────────────┐
│Oct18/07       ***** INVENTORY PRODUCT INFORMATION INQUIRY *****                â”‚
│                     COMPANY: 01 - D E M O   C O M P A N Y                      â”‚
│                                                                                â”‚
│** ENTER STORE CODE: 01  Ideal Computer Group                                   â”‚
│( 1)  PRODUCT CODE                                                              â”‚
│( 2)  PRODUCT DESCRIPTION                                                       â”‚
│( 3)  WORD SEARCH                                                               â”‚
│( 4)  LOCATION & PRODUCT CODE                                                   â”‚
│( 5)  QUICK CODE & PRODUCT CODE                                                 â”‚
│( 6)  LOGICAL CODE & PRODUCT CODE                                               â”‚
│( 7)  UPC BAR CODE & PRODUCT CODE                                               â”‚
│( 8)  PRODUCT GROUP & PRODUCT NAME                                              â”‚
│( 9)  SUPPLIER CODE & PRODUCT NAME                                              â”‚
│(10)  PRODUCT GROUP & SUPPLIER CODE & PRODUCT NAME                              â”‚
│(11)  SUPPLIER CODE & SUPPLIER'S PRODUCT CODE                                   â”‚
│(12)  SUPPLIER'S PRODUCT CODE                                                   â”‚
│(13)  PURCHASE ORDERS BY PRODUCT CODE                                           â”‚
│(14)  PRODUCT DISTRIBUTION INQUIRY                                              â”‚
│(15)  PRODUCT STATUS COLORS                                                     â”‚
│(16)  ORDER INQUIRY BY PRODUCT                                                  â”‚
│                                                                                â”‚
│** ENTER INQUIRY OPTION (F4 TO END): __                                         â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

SELECTION CRITERIA

 

 1 PRODUCT CODE

 

Specify a specific product code. When you know the product code of the product to display, select this criterion and enter the code.

 

** ENTER STARTING PRODUCT CODE:

 

Enter product code.

 

The display of products for selection will begin with the code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 2 PRODUCT DESCRIPTION

 

Search by a product description. You can enter a full or partial description of up to 30 characters.

 

** ENTER PRODUCT DESCRIPTION:

 

Enter product description.

 

The display of products for selection will begin with the product description you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 3 WORD SEARCH

 

Search by a specific key word to display only products containing the key word or string in the description. You can enter up to 14 characters. Alternatively, you can initiate a search by key word at any product field by typing word or partial word and pressing the [F5] key.

 

** ENTER WORD TO SEARCH FOR:

 

Enter key word or string of letters.

 

The display of products for selection will be limited to those containing the words or letters you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 4 LOCATION & PRODUCT CODE

 

Search by location code.

 

** ENTER STARTING LOCATION:

 

Enter product store code.

 

[Enter] to display from first store code.

 

The display of products for selection will begin with the store code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 5 QUICK CODE AND PRODUCT CODE

 

Search by quick code.

 

** ENTER STARTING QUICK PRODUCT CODE:

 

Enter product quick code.

 

[Enter] for all quick codes.

 

The display of products for selection will be limited to those containing the code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 6 LOGICAL CODE & PRODUCT CODE

 

Search by logical code.

 

** ENTER STARTING LOGICAL PRODUCT CODE:

 

Enter product logical code.

 

[Enter] for all logical codes.

 

The display of products for selection will begin with the logical code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 7 UPC BAR CODE & PRODUCT CODE

 

Search by UPC bar code.

 

** ENTER STARTING UPC BAR CODE:

 

Enter product UPC bar code.

 

[Enter] for all UPC bar codes.

 

The display of products for selection will begin with the UPC bar code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

 8 PRODUCT GROUP & PRODUCT NAME

 

Search by product group and product name. Alternatively you can initiate a search by product group at any product field by typing a group code or partial code and pressing the [F6] key.

 

** ENTER GROUP CODE: ________

 

Enter product group code.

 

[Enter] to display from first group code.

 

The display of products for selection will be limited to the group you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

[F6] for group inquiry beginning with level 1.

 

Alternatively you can enter a group code followed by [F6] for a group inquiry beginning with the group code entered.

 

 

 9 SUPPLIER CODE & PRODUCT NAME

 

Search by supplier code and product description.

 

** ENTER SUPPLIER CODE:

 

Enter supplier code.

 

[Enter] for all supplier codes.

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

** ENTER PRODUCT DESCRIPTION:

 

Enter product description.

 

You can enter up to 30 characters.

 

 

[Enter] for all products of selected supplier.

 

The display of products for selection will be limited to the supplier and description you enter here.

 

 

[F3] to re-enter supplier code.

 

[F4] to exit inquiry.

 

10 PRODUCT GROUP & SUPPLIER CODE & PRODUCT NAME

 

Search by product group, supplier and product name.

 

** ENTER GROUP CODE:

 

Enter product group code.

 

You can enter any 2, 4, 6 or 8 character group code.

 

 

[Enter] for all groups.

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

** ENTER SUPPLIER CODE:

 

Enter supplier code.

 

[Enter] for all suppliers.

 

[F3] to re-enter product group code.

 

[F4] to exit inquiry.

 

** ENTER PRODUCT DESCRIPTION:

 

Enter product description.

 

You can enter up to 30 characters.

 

 

[Enter] for all products of selected supplier.

 

The display of products for selection will be limited to the supplier, product description and group code you enter here.

 

 

[F3] to re-enter supplier code.

 

[F4] to exit inquiry.


11 SUPPLIER CODE & SUPPLIER'S PRODUCT CODE

 

Search by supplier code and supplier's product code.

 

** ENTER SUPPLIER CODE:

 

Enter supplier code.

 

[Enter] for all suppliers.

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

** ENTER SUPPLIER'S PRODUCT CODE:

 

Enter supplier product code.

 

[Enter] for first product code in system for supplier.

 

The display of products for selection will begin with the product code of the supplier you enter here.

 

 

[F3] to re-enter supplier code.

 

[F4] to exit inquiry.

 

12 SUPPLIER'S PRODUCT CODE

 

Specify supplier's product code.

 

** ENTER SUPPLIER'S PRODUCT CODE:

 

Enter supplier product code.

 

[Enter] for first supplier product code in system.

 

The display of products for selection will begin with the supplier product code you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

13 PURCHASE ORDERS BY PRODUCT CODE

 

Search through purchase orders by product.

 

** ENTER PRODUCT CODE: _______________

 

Enter product code to display PO information for product.

 

The program displays a list purchase orders containing the product you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

14 PRODUCT DISTRIBUTION INQUIRY

 

Specify a product code to inquiry upon on-hand and on-order quantities.

 

** ENTER PRODUCT CODE:

 

Enter product code.

 

The program displays a list of on-hand and on-order quantities for the product you enter here.

 

 

[F3] to re-enter selection criterion.

 

[F4] to exit inquiry.

 

15 PRODUCT STATUS COLORS

 

When you select criterion 6, the following information screen displays, indicating the color coding currently active in the inventory module.

 

PRODUCT STATUS COLOR CODE

┌──────────────────────────────────────┐
│  ***** PRODUCT STATUS INQUIRY *****  â”‚
│──────────────────────────────────────│
│    STATUS               COLOR        â”‚
│──────────────────────────────────────│
│    REGULAR              YELLOW       â”‚
│    SPECIAL PURCHASE     MAGENTA      â”‚
│    SPECIAL ORDER        WHITE        â”‚
│    BEST PRICE           LIGHT BLUE   â”‚
│    DISCONTINUED         DARK BLUE    â”‚
│    PROMO PRICE          RED          â”‚
│──────────────────────────────────────│
│** PRESS CR TO CONTINUE: _            â”‚
└──────────────────────────────────────┘
** PRESS CR TO CONTINUE:

 

[Enter] to return to selection criteria.

 

16 ORDER INQUIRY BY PRODUCT

 

Search by product code and invoice number.

 

** ENTER PRODUCT CODE:

 

Enter product code.

 

[F3] to re-enter selection criterion.

 

** ENTER CUSTOMER CODE:

 

Enter customer code.

 

[F3] to re-enter product code.

 

[F5] to access customer code inquiry for selection.

 

** ENTER DATE ENTERED: MMDDYY

 

Enter date order was entered.

 

[Enter] for current system date.

 

[F2] for earliest date.

 

[F3] to re-enter customer code.


Example Order Inquiry by Product display:

┌────────────────────────────────────────────────────────────────────────────────┐
│04/10/07        ** ORDER INQUIRY BY: ORDER INQUIRY BY PRODUCT **                â”‚
│                            COMPANY: 01 - IDEALWARE                             â”‚
│STORE:    01                                                                    â”‚
│PRODUCT:  320570  16 OZ CLAW HAMMER                    COMMITTED: 305.50  EA    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│   INVOICE    LINE CUSTOMER   ENTERED  QUANTITY UNIT      PRICE PER   ExTENSION â”‚
│────────────────────────────────────────────────────────────────────────────────│
│ 1 01-A100187 0010 ACTDEV   10/06/94      10.00 EA        28.59 EA       285.90 â”‚
│ 2 01-A100187 0020 ACTDEV   10/06/94       1.00 EA        28.59 EA        28.59 â”‚
│ 3 01-A100527 0010 ABACON   08/16/95       1.00 EA        28.59 EA        28.59 â”‚
│ 4 01-A100535 0010 AHCON    08/25/95       2.00 EA        28.59 EA        57.18 â”‚
│ 5 01-A100564 0010 *02      09/17/95       1.00-EA        14.57 EA        14.57-│
│ 6 01-A100589 0010 *02      09/20/95       1.00 EA        14.57 EA        14.57 â”‚
│ 7 01-A100679 0020 MAGCED   01/08/96       1.00 EA        28.59 EA        28.59 â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
│                                                                                â”‚
│** SELECT INQUIRY OPTION (F12 FOR OPTIONS); F4 TO EXIT INQUIRY: ___             â”‚
│   (PAGE MODE)                                                                  â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** SELECT INQUIRY OPTION (F12 FOR OPTIONS); F4 TO EXIT INQUIRY:

 

[F12] See 31587 - ORDER INQUIRY, ORDERS DISPLAY OPTIONS.

 

[F4] to exit display and return to selection criteria.

 

 

FIELDS

 

INVOICE

 

Displays invoice number.

 

LINE

 

Displays order detail line number.

 

CUSTOMER

 

Displays customer name code.

 

ENTERED

 

Displays date of order.

 

QUANTITY

 

Displays product quantity.

 

UNIT

 

Displays product quantity unit.

 

PRICE

 

Displays product price.

 

PER

 

Displays product pricing unit.


EXTENSION

 

Displays product quantity x pricing extension.