IdealWare Online Users Manual

IY3-06 I/Y INQUIRY
30979 Product Inquiry by Length

 

PURPOSE

 

The product inquiry by length is used to display information pertaining to a family of products which are associated with each other by their logical codes. It is typically used for lumber and gyprock products to show on hand and available quantities of various lengths.

 

When the product inquiry by length program is accessed via sale order entry program, the length part of the product's logical code is displayed either in green to indicate a positive available quantity or red to indicate a negative available quantity.

 

The Product Inquiry by Length is accessed from:

  • Sale Order Entry, detail entry - product lines, pieces & lengths.
  • Inventory Processing Menu, Lumber Report by Length.

 

PROCEDURE

 

Select Lumber Report by Length from the Inventory Processing menu, or press [F7] the pieces & lengths option prompt in sale order entry. The product inquiry by length screen displays.

 

Example Product Inquiry by Length display:

┌────────────────────────────────────────────────────────────────────────────────┐
│04/17/07               ***** PRODUCT INQUIRY BY LENGTH *****                    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│STORE:       01 IDEALWARE                                                       â”‚
│DESCRIPTION: 02042FG4--                                                         â”‚
│────────────────────────────────────────────────────────────────────────────────│
│    PRODUCT         QTY   <------------- QUANTITY ------------->   AVERAGE      â”‚
│     CODE          UNITS  ON HAND  ON ORDER  COMMITTED AVAILABLE     COST       â”‚
│────────────────────────────────────────────────────────────────────────────────│
│    02042FG408     PIECE      197       580        635       142    413.25      â”‚
│    02042FG410     PIECE    2,609         0      1,529     1,080    402.01      â”‚
│    02042FG412     PIECE    3,950         0        270     3,680    492.47      â”‚
│    02042FG414     PIECE    3,240         0        140     3,100    496.77      â”‚
│    02042FG416     PIECE    3,318         0        152     3,166    504.43      â”‚
│    02042FG418     PIECE    1,317         0        160     1,157    536.15      â”‚
│    02042FG420     PIECE      409         0        100       309    546.31      â”‚
│                        --------- ---------  --------- ---------                â”‚
│RECORDS: 7                 15,040       580      2,986    12,634                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│** PRESS CR TO CONTINUE: _                                                      â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO CONTINUE:

 

[Enter] to exit inquiry.

 

If there is more than one screen of products press [Enter] to advance and [F3] to view the previous screen. Press [Enter] at the final screen to exit the inquiry.

 

 


FIELDS

 

STORE

 

Displays store code location.

 

DESCRIPTION

 

Displays first 8 characters of product logical code.

 

PRODUCT CODE

 

Displays product code.

 

QTY UNITS

 

Displays product quantity unit.

 

ON HAND

 

Displays quantity units on hand.

 

ON ORDER

 

Displays quantity units on order.

 

COMMITTED

 

Displays quantity units committed to current orders.

 

AVAILABLE

 

Displays quantity units available.

 

This is the total on hand and on order but not committed.

 

 

COST

 

Displays product unit cost.