Quantity Control Report

The quantity control report program prints a product listing that shows quantities on-hand, on order from suppliers, re-order information and recommended purchase quantities.

Select Inventory Reports from the Inventory Processing menu. The inventory reports menu displays.

** ENTER REPORT NUMBER OR F4 TO RETURN TO MENU:

[F4] to exit to menu.

"1" to access quantity control report.

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

** STORE OPTIONS:
( 1) ALL STORES
( 2) SPECIFY STORE(S)
** ENTER OPTION DESIRED (CR=1):

"1" to select all stores.

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

"2" to list specific stores.

** 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.

** SEPARATE REPORT PER STORE? (Y/N):

Applicable in multistore environments only.

"Y" to print a separate report for each store.

"N" to, print a single report.

Information for each store will be grouped together by product.

** SORTING OPTIONS
( 1) BY GROUP
( 2) BY SUPPLIER
( 3) BY SUPPLIER AND GROUP
( 4) BY LOCATION (AISLE)

"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.

** PRINT GROUP TOTALS ONLY? (Y/N):

"Y" to print group totals only.

** WHICH GROUP LVL TOTALS? (NONE/1/2/3/4/CR=ALL):

You can print totals for any, all or no group levels.

[Enter] to include all product group levels.

"1" to include level 1 product groups only.

"2" to include level 2 product groups only.

"3" to include level 3 product groups only.

"4" to include level 4 product groups only.

"N""O""N""E" to include no group level totals.

"N" to print product details.

** 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.

** PRINT GROUP TOTALS ONLY? (Y/N):

"Y" to print group totals only.

** WHICH GROUP LVL TOTALS? (NONE/1/2/3/4/CR=ALL):

You can print totals for any, all or no group levels.

[Enter] to include all product group levels.

"1" to include level 1 product groups only.

"2" to include level 2 product groups only.

"3" to include level 3 product groups only.

"4" to include level 4 product groups only.

"N""O""N""E" to include no group level totals.

"N" to print product details.

** 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.

FOLIO NUMBER PRINT OPTIONS:
( 1) FOLIO NUMBER
( 2) ITEM CODE
( 3) LOGICAL CD
( 4) SUPPLIER PRODUCT CODE
** ENTER OPTION DESIRED (CR=1):

[Enter] to accept default value "1".

"1" to print folio number.

"2" to print item code.

"3" to print logical code.

"4" to print supplier product code.

** 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.

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.

** 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 TYPE OPTIONS:
( 1) ALL PRODUCTS
( 2) TRANSFER ITEMS
( 3) WAREHOUSE SOURCED ITEMS
( 4) SUPPLIER SOURCED ITEMS
( 5) INTERNALLY SOURCED ITEMS
( 6) CONTRACT ITEMS ONLY
( 7) SS AND IS ORDER CONTROL ITEMS
** ENTER OPTION DESIRED (CR=2):

[Enter] to accept default value "2".

"1" to include all products

"2" to include transfer items only.

"3" to include warehouse sourced items only.

"4" to include supplier sourced items only.

"5" to include internally sourced items only.

"6" to include contract items only.

"7" to include supplier and internally sourced items.

QUANTITY OPTIONS:
( 1) ALL PRODUCTS
( 2) ONLY PRODUCTS BELOW MINIMUM QTY
( 3) ONLY PRODUCTS WITH AN 'ON HAND' QTY
( 4) ONLY PRODUCTS WITH A 'COMMITTED' QTY
( 5) ONLY PRODUCTS WITH AN 'ON HAND', 'ON ORDER' OR 'COMMITTED' QTY
( 6) ONLY PRODUCTS WITH ON HAND QTY/VALUE, BUT NO YTD OR LYR SALES
( 7) ONLY PRODUCTS WITH NEGATIVE ON HAND QTY
** ENTER OPTION DESIRED (CR=1):

[Enter] to accept default value "1".

"1" to include all products regardless of quantity.

"2" to include only products below minimum quantity.

"3" to include only products with onhand quantity.

"4" to include only products with committed quantity.

"5" to include only products with onhand, or order or committed quantity.

"6" to include only products with onhand quantity or value and no YTD or LYR sales.

"7" to include only products with negative onhand quantity.

INFORMATION TO INCLUDE:
( 1) RE-ORDER INFO
( 2) RE-ORDER INFO AND TOTAL RE-ORDER VALUE
( 3) AVE COST, PRICE AND ONHAND VALUE (NO RE-ORDER INFO)
( 4) SUPP COST, PRICE AND ONHAND VALUE (NO RE-ORDER INFO)
( 5) AVE COST, ONHAND VALUE, YTD MARG%, TURNS (NO RE-ORDER INF
( 6) ONHAND VALUE, YTD MARG%, TURNS, INDEX (NO RE-ORDER INFO)
** ENTER OPTION DESIRED (CR=1):

[Enter] to accept default value "1".

"1" to print re-order information.

"2" to print re-order information and total re-order value.

"3" to print average cost, price and onhand value.

"4" to print supplier cost, price and onhand value.

"5" to print average cost, onhand value YTD margin % and turns.

"6" to print onhand value, YTD margin %, turns and index.

LUMBER QUANTITY UNIT OF MEASURE OPTIONS:
( 1) PIECES (IF RANDOM LENGTH PRODUCT, THEN FBM)
( 2) FBM
( 3) PACKS (IF NON-PACK PRODUCT, THEN PIECES)
( 4) PACKS (IF NON-PACK PRODUCT, THEN FBM)
** ENTER OPTION DESIRED (CR=1):

[Enter] to accept default value "1".

"1" to print pieces and fbm for random length lumber.

"2" to print fbm.

"3" to print packs and pieces for non-pack lumber.

"4" to print packs and fbm for non-pack lumber.

** NUMBER OF COPIES (CR=1):

Enter number of copies to print.

[Enter] to print one copy.

** 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.

** 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.


                                                  IDEAL BUILDING SUPPLIES LTD.
09/16/07  16:12:19                                                                                                     PAGE: 3
                               INVENTORY QUANTITY CONTROL REPORT - 01 'IDEAL BUILDING SUPPLY LTD'
                           PRODUCT DETAIL - ALL GROUP LEVEL TOTALS - ALL PRODUCT TYPES - NO PACKAGES
---------------------------------------------------------------------------------------------------------------------------------
PRODUCT                                      UNITS               IN         ON  UNSHIPPED  AVAILABLE    R'ORD     R'ORD     TO BE
 CODE           DESCRIPTION                   OF                STOCK     ORDER   ORDERS                 QTY      POINT     ORD'D
---------------------------------------------------------------------------------------------------------------------------------

LU-FI        FIR

113410       1/2X2 KD CL S4S FIR R/L         FBM              1024136         0         0   1024136         0         0         0
113420       1/2X3 KD CL S4S FIR R/L         FBM                  366         0         0       366         0         0         0
113440       1/2X5 KD CL S4S FIR R/L         FBM                  333         0         0       333         0         0         0
113460       1/2X8 KD CL S4S FIR R/L         FBM                  493         0         0       493         0         0         0
113500       1X12 KD CL S4S FIR R/L          FBM                 2516         0         0      2516         0         0         0
113510       1X2 KD CL S4S FIR R/L           FBM                 1767         0         0      1767         0         0         0
274320       1X4 S4S UTIL&BTR GRN FIR R/L    FBM                68538         0         0     68538         0         0         0
113570       1X6 KD CL S4S FIR R/L           FBM                 4206         0         0      4206         0         0         0
113590       1X8 KD CL S4S FIR R/L           FBM                 4671         0         0      4671         0         0         0
108930       2X10 S4S 2&BTR GRN FIR 08       PIECE                357-        0         2       359-        0         0         0
108940       2X10 S4S 2&BTR GRN FIR 10       PIECE                444         0         0       444         0         0         0
108950       2X10 S4S 2&BTR GRN FIR 12       PIECE                395-        0        50       445-        0         0         0
108955       2X10 S4S 2&BTR GRN FIR 8-12     FBM                  480-        0         0       480-        0         0         0
108960       2X10 S4S 2&BTR GRN FIR 14       PIECE               1794         0        50      1744         0         0         0
108970       2X10 S4S 2&BTR GRN FIR 16       PIECE                143-        0       120       263-        0         0         0
108975       2X10 S4S 2&BTR GRN FIR 14-16    FBM                    0         0         0         0         0         0         0
108980       2X10 S4S 2&BTR GRN FIR 18       PIECE                 32-        0         0        32-        0         0         0
108990       2X10 S4S 2&BTR GRN FIR 20       PIECE                587         0         0       587         0         0         0
108995       2X10 S4S 2&BTR GRN FIR 18-20    FBM                    0         0         0         0         0         0         0
109000       2X10 S4S 2&BTR GRN FIR 22       PIECE                 81-        0         0        81-        0         0         0
109010       2X10 S4S 2&BTR GRN FIR 24       PIECE               1380         0         0      1380         0         0         0
108810       2X10 S4S UTIL GR FIR 08         PIECE                207         0         0       207         0         0         0
108820       2X10 S4S UTIL GR FIR 10         PIECE                113         0         0       113         0         0         0
108830       2X10 S4S UTIL GR FIR 12         PIECE                234         0         0       234         0         0         0
108840       2X10 S4S UTIL GR FIR 14         PIECE                 86         0         0        86         0         0         0
108850       2X10 S4S UTIL GR FIR 16         PIECE                143         0         0       143         0         0         0
108860       2X10 S4S UTIL GR FIR 18         PIECE                106         0         0       106         0         0         0
108800       2X10 S4S UTIL&BTR GRN FIR 06    PIECE                  2         0         0         2         0         0         0
274690       2X10X12CC BRIDGING              PCE                 1525         0         0      1525         0         0         0
274700       2X10X16CC BRIDGING              PCE                  875         0         0       875         0         0         0
109190       2X12 S4S 2&BTR GRN FIR 08       PIECE                 55         0         0        55         0         0         0
109200       2X12 S4S 2&BTR GRN FIR 10       PIECE                  0         0         0         0         1         0         0
109235       2X12 S4S 2&BTR GRN FIR 8-16     FBM                 1532-        0         0      1532-        0         0         0
109250       2X12 S4S 2&BTR GRN FIR 20       PIECE                 32         0         0        32         0         0         0
109260       2X12 S4S 2&BTR GRN FIR 22       PIECE                 22         0         0        22         0         0         0
109270       2X12 S4S 2&BTR GRN FIR 24       PIECE                 67         0         0        67         0         0         0
274710       2X12X12CC BRIDGING              PCE                 1850         0         0      1850         0         0         0
274720       2X12X16CC BRIDGING              PCE                 6600         0         0      6600         0         0         0
275080       2X2 CANT STRIP R/L              FBM                  559         0         0       559         0         0         0
113700       2X2 KD CL S4S FIR R/L           FBM                 1610         0         0      1610         0         0         0
109520       2X2 S4S 2&BTR GR HEM/FIR R/L    FBM                 2590-        0         0      2590-        0         0         0
110610       4X4 S4S 2&BTR GRN FIR R/L       FBM                10427-        0         0     10427-        0         0         0
110970       6X6 S4S 2&BTR GRN FIR R/L       FBM                13215         0         0     13215         0         0         0
113390       8X8 RGH 2&BTR GRN FIR R/L       FBM                  774-        0         0       774-        0         0         0
                                                           ----------   -------   -------   -------   -------   -------   -------
**** GROUP 'LU-FI' TOTALS:                                    1113749         0     19170   1110187         7         1         5
 *** GROUP 'LU-FI' TOTALS:                                    1113749         0     19170   1110187         7         1         5
  ** GROUP 'LU-FI' TOTALS:                                    1113749         0     19170   1110187         7         1         5
   * GROUP 'LU' TOTALS:                                       1113749         0     19170   1110187         7         1         5

RECORDS PRINTED:   101

IdealWare Online Users Manual

IY5-12 I/Y LISTINGS, REPORTS AND FORMS
31097 Quantity Control Report

IdealWare Online Users Manual

IY5-12 I/Y LISTINGS, REPORTS AND FORMS31097 Quantity Control Report

IY5-12 I/Y LISTINGS, REPORTS AND FORMS
31097 Quantity Control Report