IdealWare Online Users Manual

IY5-09 I/Y LISTINGS, REPORTS AND FORMS
31094 Product Master Listing

 

PURPOSE

 

The product master listing program prints a list of product information from the product master file.

 

The Product Master Listing is accessed from the:

  • Inventory Maintenance menu.

 

PROCEDURE

 

Select Product Listing Reports from the Inventory Maintenance menu. The product listing reports menu displays.

 

PRODUCT LISTING REPORTS MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│01/23/08              ***** PRODUCT LISTING REPORTS *****                3YIYR1 â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│            â”Œâ”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”             â”‚
│            â”‚PRODUCT LISTING OPTIONS:                             â”‚             â”‚
│            â”‚( 1)  FOLIO NUMBER/NAME LISTING                      â”‚             â”‚
│            â”‚( 2)  PRODUCT MASTER LISTING                         â”‚             â”‚
│            â”‚( 3)  INVENTORY MASTER LISTING                       â”‚             â”‚
│            â”‚( 4)  PRICE LIST REPORT                              â”‚             â”‚
│            â”‚( 5)  COMPREHENSIVE PRICING REPORT                   â”‚             â”‚
│            â”‚ENTER REPORT NUMBER OR F4 TO RETURN TO MENU:      __ â”‚             â”‚
│            â””─────────────────────────────────────────────────────┘             â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
ENTER REPORT NUMBER OR F4 TO RETURN TO MENU:

 

[F4] to exit to menu.

 

"2" to access product master listing report.

 

The following prompts enable you to select the desired report options.

 

 

STORE OPTIONS:
( 1)  MASTER REGION (00)
( 2)  ALL REGIONS
( 3)  ALL STORES
( 4)  SPECIFY STORE/REGION(S)
** ENTER OPTION DESIRED (CR=1):

 

[Enter] to accept default value "1".

 

"1" to select master region.


"2" to select all regions.

 

"3" to select all stores.

 

"4" to specify stores and/or regions.

 

** STORE CODE (CR TO END LIST):

 

Enter store code.

 

Press [Enter] a second time to end list. To remove stores from list, re-enter store code.

 

 

[Enter] to indicate selection complete.

 

** SORTING OPTIONS
( 1)  BY GROUP
( 2)  BY SUPPLIER
( 3)  BY SUPPLIER AND GROUP
( 4)  BY LOCATION (AISLE)
( 5)  BY FOLIO NUMBER
( 6)  BY ITEM CODE

 

"1" to sort report by product groups.

 

** RANGE OF GROUPS OR SELECTED GROUPS? (R/S):

 

"R" to select range of product groups.

 

** STARTING GROUP (CR=FIRST):

 

Enter product group code to begin range.

 

[Enter] to begin at first product group code.

 

[F5] to display list of product group codes for selection.

 

** ENDING GROUP (CR=LAST):

 

Enter product group code to end range.

 

[Enter] to end at last product group code.

 

[F5] to display list of product group codes for selection.

 

"S" to select specific product groups.

 

** SELECTED GROUPS:

 

Enter product groups to include.

 

[Enter] for all.

 

[F5] to display list of product group codes for selection.


** SORT WITHIN GROUP:
( 1)  DESCRIPTION
( 2)  QUICK CODE
( 3)  PRODUCT CODE
( 4)  EXTRA DESCRIPTION 1
( 5)  EXTRA DESCRIPTION 2
( 6)  EXTRA DESCRIPTION 3
** ENTER OPTION DESIRED (CR=1):

 

[Enter] to accept default value "1".

 

"1" to sort within product groups by product description.

 

"2" to sort within product groups by product quick code.

 

"3" to sort within product groups by product code.

 

"4" to sort within product groups by product extra desc. 1.

 

"5" to sort within product groups by product extra desc. 2.

 

"6" to sort within product groups by product extra desc. 3.

 

** PAGE BREAK BY GROUP LEVEL? (0=NONE,1,2,3,4):

 

[Enter] to accept default value "0".

 

"0" to not add a page break after group levels.

 

"2", "3" or "4" to insert page break after specified group level.

 

"2" to sort report by suppliers.

 

** ENTER BEGINNING SUPPLIER CODE (CR FOR FIRST):

 

Enter supplier code to begin range.

 

[Enter] to begin at first supplier code.

 

[F5] to access supplier inquiry for selection.

 

** ENTER ENDING SUPPLIER CODE (CR FOR LAST):

 

Enter supplier code to end range.

 

[Enter] to end at last supplier code.

 

[F5] to access supplier inquiry for selection.

 

** SUPPLIER#1 PRODUCTS ONLY? (Y/N):

 

"Y" to display supplier#1 products only.

 

"N" to not display supplier#1 products only.

 

"3" to sort report by suppliers and product groups.

 

** ENTER BEGINNING SUPPLIER CODE (CR FOR FIRST):

 

Enter supplier code to begin range.

 

[Enter] to begin at first supplier code.

 

[F5] to access supplier inquiry for selection.

 

** ENTER ENDING SUPPLIER CODE (CR FOR LAST):

 

Enter supplier code to end range.

 

[Enter] to end at last supplier code.

 

[F5] to access supplier inquiry for selection.

 

** SUPPLIER#1 PRODUCTS ONLY? (Y/N):

 

"Y" to display supplier#1 products only.

 

"N" to not display supplier#1 products only.

 

** STARTING GROUP (CR=FIRST):

 

Enter product group code to begin range.

 

[Enter] to begin at first product group code.

 

[F5] to display list of product group codes for selection.

 

** ENDING GROUP (CR=LAST):

 

Enter product group code to end range.

 

[Enter] to end at last product group code.

 

[F5] to display list of product group codes for selection.

 

** SORT WITHIN GROUP:
( 1)  DESCRIPTION
( 2)  QUICK CODE
( 3)  PRODUCT CODE
( 4)  EXTRA DESCRIPTION 1
( 5)  EXTRA DESCRIPTION 2
( 6)  EXTRA DESCRIPTION 3
** ENTER OPTION DESIRED (CR=1):

 

[Enter] to accept default value "1".

 

"1" to sort within product groups by product description.

 

"2" to sort within product groups by product quick code.

 

"3" to sort within product groups by product code.

 

"4" to sort within product groups by product extra desc. 1.

 

"5" to sort within product groups by product extra desc. 2.

 

"6" to sort within product groups by product extra desc. 3.

 

** PAGE BREAK BY GROUP LEVEL? (0=NONE,1,2,3,4):

 

[Enter] to accept default value "0".

 

"0" to not add a page break after group levels.

 

"2", "3" or "4" to insert page break after specified group level.


"4" to sort report by location.

 

>> TO SORT BY LOCATION, YOU MUST SELECT STORE OPTION 4
AND SPECIFY ONLY ONE YARD. CR TO CONTINUE:

 

You can print a report sorted by location for a single store only. Press [Enter] to clear the alert and reselect the store code.

 

SORT WITHIN LOCATION BY:
( 1)  DESCRIPTION
( 2)  ITEM CODE
( 3)  FOLIO NUMBER
( 4)  EXTRA DESCRIPTION 1
( 5)  EXTRA DESCRIPTION 2
( 6)  EXTRA DESCRIPTION 3

 

[Enter] to accept default value "1".

 

"1" to sort within location by product description.

 

"2" to sort within location by product code.

 

"3" to sort within location by product folio number.

 

"4" to sort within location by product extra desc. 1.

 

"5" to sort within location by product extra desc. 2.

 

"6" to sort within location by product extra desc. 3.

 

** BASED ON PRODUCTS FIRST LOCATION ONLY? (Y/N):

 

If not based on 1st location only a product may print on the report multiple times.

 

 

[Enter] to accept default value "N".

 

"Y" base report of first location of products only.

 

"N" to not base report of first location of products only.

 

"5" to sort report by product folio number.

 

** ENTER BEGINNING FOLIO NUMBER (CR FOR FIRST):

 

Enter product folio number to begin range.

 

[Enter] to begin at first product folio number.

 

[F5] to display list of products by folio number for selection.

 

** ENTER ENDING FOLIO NUMBER (F2 FOR LAST):

 

Enter product folio number to end range.

 

[Enter] or [F2] to end at last product folio number.

 

[F5] to display list of products by folio number for selection.


"6" to sort report by item code.

 

** ENTER BEGINNING ITEM CODE (CR FOR FIRST):

 

Enter product item code to begin range.

 

[Enter] to begin at first product code.

 

** ENTER ENDING ITEM CODE (F2 FOR LAST):

 

Enter product item code to end range.

 

[Enter] or [F2] to end at last product code.

 

** PRINT SET/KITS? (1=NO/2=YES/3=ONLY; CR=NO):

 

[Enter] to accept default value "1".

 

"1" to not include package type products.

 

"2" to include package type products.

 

"3" to include only package type products.

 

** PRODUCT STATUS (RE/SC/DI/SO/SP/DL; CR=ALL):
ENTER 'XX' FOR PRODUCTS WITH INVALID STATUS.

 

Multiple status parameters are allowed, eg RESCDI (include REgular, Seasonal Clearance and DIscontinued).

 

[Enter] to include products of all status types.

 

"R""E" to include only REgular products.

 

"S""C" to include only Seasonal Clearance products.

 

"D""I" to include only DIscontinued products.

 

"S""O" to include only Special Order products.

 

"S""P" to include only Special Purchase products.

 

"D""L" to include only DeLeted products.

 

"X""X" to include only products with an invalid status code.

 

** SELECTED BUYER CODES (CR=FINISH, F6=ALL):

 

Enter buyer codes.

 

Press [Enter] a second time to end list.

 

 

[Enter] to indicate selection complete.

 

[F6] for all buyers.

 

** PRODUCT TYPE: SA/SM/SE/G/I/L/P; CR=ALL):

 

[Enter] for to include all product types.

 

"S""A" to include only Store Average type products.

 

"S""M" to include only Store Markup type products.

 

"S""E" to include only SErvice type products.

 

"G" to include only Gyprock type products.

 

"I" to include only Insulation type products.

 

"L" to include only Lumber type products.

 

"P" to include only Plywood type products.

 

DELETED PRODUCT OPTIONS:
( 1)  ONLY NON-DELETED PRODUCTS
( 2)  ONLY DELETED PRODUCTS
( 3)  BOTH NON-DELETED AND DELETED PRODUCTS
** ENTER OPTION DESIRED (CR=1)

 

[Enter] to accept default value "1".

 

"1" to include only non-deleted products.

 

"2" to include only deleted products.

 

"3" to include both non-deleted and deleted products.

 

PST CODE OPTIONS:
( 1) ALL PRODUCTS
( 2) PST EXEMPT PRODUCTS
( 3) PST NON-EXEMPT PRODUCTS
** ENTER OPTION DESIRED (CR=1):

 

[Enter] to accept default value "1".

 

"1" to include all products.

 

"2" to include only PST exempt products.

 

"3" to include only PST non-exempt products.

 

** NUMBER OF COPIES (CR=1):

 

Enter number of copies to print.

 

[Enter] to print one copy.


Example Completed Parameters Entry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/23/08               ***** PRODUCT MASTER LISTING *****                3YIYR1 â”‚
│                                                                                â”‚
│** STORE OPTION:                                  MASTER REGION (00)            â”‚
│** SEPARATE REPORT PER STORE? (Y/N):              Y                             â”‚
│** SORTING OPTIONS:                               BY GROUP                      â”‚
│** RANGE OF GROUPS OR SELECTED GROUPS? (R/S):     R                             â”‚
│** STARTING GROUP (CR=FIRST):                     FIRST GROUP                   â”‚
│** ENDING GROUP (CR=LAST):                        LAST GROUP                    â”‚
│** SORT WITHIN GROUP BY:                          DESCRIPTION                   â”‚
│** PAGE BREAK BY GROUP LEVEL? (0=NONE,1,2,3,4):   0                             â”‚
│** PRINT SET/KITS? (1=NO/2=YES/3=ONLY; CR=NO):    1                             â”‚
│** PRODUCT STATUS: RE/DI/SO/SP/BP; CR=ALL):       STATUS: ALL                   â”‚
│** SELECTED BUYER CODES (CR=ALL, F6=ALL):         ALL BUYERS                    â”‚
│** PRODUCT TYPE: SA/SM/SE/G/I/L/P; CR=ALL):       TYPE: ALL                     â”‚
│** DELETED OPTION:                                ONLY NON-DELETED PRODUCTS     â”‚
│** PST OPTION:                                    ALL PRODUCTS                  â”‚
│** NUMBER OF COPIES (CR=1):                       1_                            â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO CONTINUE OR F1 TO CONTINUE AND PRINT THE OPTIONS:

 

[Enter] to continue to printer selection menu.

 

[F1] to print selected options with the report.

 

[F3] to return to previous field.

 

You can press [F3] at any field to return to the previous field.

 

 

[F4] to exit to menu.

 

The print selection menu displays.

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example Inventory Price List Report printout follows.

  



                                                    IDEAL BUILDING SUPPLIES LTD.
09/16/07  11:15:51                                                                                                        PAGE: 1
                                                       PRODUCT MASTER LISTING
                                          ALL STATUS - NO DELETED PRODUCTS - NO PACKAGES
-----------------------------------------------------------------------------------------------------------------------------------
PRODUCT                                  PROD  PROD             FBM       LIN   BASE    ALT-1    CONV1    ALT-2   CONV2
 CODE     DESCRIPTION                    TYPE  GROUP            FACTOR    FR   U OF M   U OF M   FACT     U OF M  FACT    U.P.C.
-----------------------------------------------------------------------------------------------------------------------------------

LU-FI        FIR

113410    1/2X2 KD CL S4S FIR R/L         L    LUFI****           .16667       LIN      MFBM    5999.88   PCE
113420    1/2X3 KD CL S4S FIR R/L         L    LUFI****           .25          LIN      MFBM    4000      PCE
113440    1/2X5 KD CL S4S FIR R/L         L    LUFI****           .41667       LIN      MFBM    2399.9808 PCE
113460    1/2X8 KD CL S4S FIR R/L         L    LUFI****           .66667       LIN      MFBM    1499.9925 PCE
113500    1X12 KD CL S4S FIR R/L          L    LUFI****          1.            LIN      MFBM    1000      PCE
113510    1X2 KD CL S4S FIR R/L           L    LUFI****           .16667       LIN      MFBM    5999.88   PCE
274320    1X4 S4S UTIL&BTR GRN FIR R/L    L    LUFI****           .33334       LIN      MFBM    2999.94   PCE
113570    1X6 KD CL S4S FIR R/L           L    LUFI****           .5           LIN      MFBM    2000      PCE
113590    1X8 KD CL S4S FIR R/L           L    LUFI****           .66667       LIN      MFBM    1499.9925 PCE
108930    2X10 S4S 2&BTR GRN FIR 08       L    LUFI****          1.66667   8   LIN      MFBM   599.9988   PCE     8.
108940    2X10 S4S 2&BTR GRN FIR 10       L    LUFI****          1.66667  10   LIN      MFBM   599.9988   PCE    10.
108950    2X10 S4S 2&BTR GRN FIR 12       L    LUFI****          1.66667  12   LIN      MFBM   599.9988   PCE    12.
108955    2X10 S4S 2&BTR GRN FIR 8-12     L    LUFI****          1.66667       LIN      MFBM   599.9988   PCE    10.
108960    2X10 S4S 2&BTR GRN FIR 14       L    LUFI****          1.66667  14   LIN      MFBM   599.9988   PCE    14.
108970    2X10 S4S 2&BTR GRN FIR 16       L    LUFI****          1.66667  16   LIN      MFBM   599.9988   PCE    16.
108975    2X10 S4S 2&BTR GRN FIR 14-16    L    LUFI****          1.66667       LIN      MFBM   599.9988   LIN     1.
108980    2X10 S4S 2&BTR GRN FIR 18       L    LUFI****          1.66667  18   LIN      MFBM   599.9988   PCE    18.
108990    2X10 S4S 2&BTR GRN FIR 20       L    LUFI****          1.66667  20   LIN      MFBM   599.9988   PCE    20.
108995    2X10 S4S 2&BTR GRN FIR 18-20    L    LUFI****          1.66667       LIN      MFBM   599.9988   LIN     1.
109000    2X10 S4S 2&BTR GRN FIR 22       L    LUFI****          1.66667  22   LIN      MFBM   599.9988   PCE    22.
109010    2X10 S4S 2&BTR GRN FIR 24       L    LUFI****          1.66667  24   LIN      MFBM   599.9988   PCE    24.
108810    2X10 S4S UTIL GR FIR 08         L    LUFI****          1.66667   8   LIN      MFBM   599.9988   PCE     8.
108820    2X10 S4S UTIL GR FIR 10         L    LUFI****          1.66667  10   LIN      MFBM   599.9988   PCE    10.
108830    2X10 S4S UTIL GR FIR 12         L    LUFI****          1.66667  12   LIN      MFBM   599.9988   PCE    12.
108840    2X10 S4S UTIL GR FIR 14         L    LUFI****          1.66667  14   LIN      MFBM   599.9988   PCE    14.
108850    2X10 S4S UTIL GR FIR 16         L    LUFI****          1.66667  16   LIN      MFBM   599.9988   PCE    16.
108860    2X10 S4S UTIL GR FIR 18         L    LUFI****          1.66667  18   LIN      MFBM   599.9988   PCE    18.
108800    2X10 S4S UTIL&BTR GRN FIR 06    L    LUFI****          1.66667   6   LIN      MFBM   599.9988   PCE     6.
274690    2X10X12CC BRIDGING              SA   LUFI****                        PCE      BDLE    25.
274700    2X10X16CC BRIDGING              SA   LUFI****                        PCE      BDLE    25.
109190    2X12 S4S 2&BTR GRN FIR 08       L    LUFI****          2.        8   LIN      MFBM   500.       PCE     8.
109200    2X12 S4S 2&BTR GRN FIR 10       L    LUFI****          2.       10   LIN      MFBM   500.       PCE
109235    2X12 S4S 2&BTR GRN FIR 8-16     L    LUFI****          2.            LIN      MFBM   500.       LIN     1.
109250    2X12 S4S 2&BTR GRN FIR 20       L    LUFI****          2.       20   LIN      MFBM   500.       PCE    20.
109260    2X12 S4S 2&BTR GRN FIR 22       L    LUFI****          2.       22   LIN      MFBM   500.       PCE    22.
109270    2X12 S4S 2&BTR GRN FIR 24       L    LUFI****          2.       24   LIN      MFBM   500.       PCE    24.
274710    2X12X12CC BRIDGING              SA   LUFI****                        PCE      BDLE    25.
274720    2X12X16CC BRIDGING              SA   LUFI****                        PCE      BDLE    25.
275080    2X2 CANT STRIP R/L              L    LUFI****           .66667       LIN      MFBM    1499.9925 PCE
113700    2X2 KD CL S4S FIR R/L           L    LUFI****           .33334       LIN      MFBM    2999.94   PCE
109520    2X2 S4S 2&BTR GR HEM/FIR R/L    L    LUFI****           .33334       LIN      MFBM    2999.94   PCE
109630    2X3 S4S 2&BTR GRN FIR R/L       L    LUFI****           .5           LIN      MFBM    2000      PCE
109631    2X3 S4S 2&BTR GRN FIR 8         L    LUFI****           .5       8   LIN      MFBM    2000      PCE
109632    2X3 S4S 2&BTR GRN FIR 10        L    LUFI****           .5      10   LIN      MFBM    2000      PCE     8.
109633    2X3 S4S 2&BTR GRN FIR 12        L    LUFI****           .5      12   LIN      MFBM    2000      PCE    10.
109634    2X3 S4S 2&BTR GRN FIR 14        L    LUFI****           .5      14   LIN      MFBM    2000      PCE    12.
109635    2X3 S4S 2&BTR GRN FIR 16        L    LUFI****           .5      16   LIN      MFBM    2000      PCE    14.
109636    2X3 S4S 2&BTR GRN FIR 18        L    LUFI****           .5      18   LIN      MFBM    2000      PCE    16.
113730    2X4 KD CL S4S FIR R/L           L    LUFI****           .66667       LIN      MFBM    1499.9925 PCE

RECORDS PRINTED:    49



FIELDS                                   

PROD TYPE       Product type.
PROD GROUP      Product group.
FBM FACTOR      Foot board measure factor.
LIN FR          Lineal form.
BASE U OF M     Base unit of measure.
ALT-1 U OF M    Alternative "1" unit of measure.
CONV1 FACT      Conversion "1" factor.
ALT-2 U OF M    Alternative "2" unit of measure.
CONV2 FACT      Conversion "2" factor.
U.P.C.          Universal product code.