IdealWare Online Users Manual

IY5-17 I/Y LISTINGS, REPORTS AND FORMS
31102 Valuation Report

 

PURPOSE

 

The valuation report program prints a product list showing quantities on hand, average costs, total value on hand and last costs. The product group total line also indicates the group's inventory G/L code. This allows you to reconcile the inventory valuation totals with the amounts found in your G/L more easily.

 

The Valuation Report is accessed from:

  • Inventory Processing Menu.

 

PROCEDURE

 

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

 

INVENTORY REPORTS MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│01/31/08                ***** INVENTORY REPORTING *****                  3YIYR1 â”‚
│                                                                                â”‚
│                                                                                â”‚
│            â”Œâ”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”€â”             â”‚
│            â”‚INVENTORY REPORTING OPTIONS:                         â”‚             â”‚
│            â”‚( 1)  QUANTITY CONTROL                               â”‚             â”‚
│            â”‚( 2)  VALUATION                                      â”‚             â”‚
│            â”‚( 3)  VALUATION (BEFORE/AFTER) BY STORE              â”‚             â”‚
│            â”‚( 4)  SALES SUMMARY BY PRODUCT                       â”‚             â”‚
│            â”‚( 5)  SALES SUMMARY - STORE SUMMARY                  â”‚             â”‚
│            â”‚( 6)  SALES SUMMARY - LAST 12 MONTHS                 â”‚             â”‚
│            â”‚( 7)  SALES ANALYSIS                                 â”‚             â”‚
│            â”‚( 8)  MOVEMENT                                       â”‚             â”‚
│            â”‚( 9)  DISTRIBUTION                                   â”‚             â”‚
│            â”‚(10)  PRODUCT PERFORMANCE LISTING                    â”‚             â”‚
│            â”‚(11)  RATE OF SALE                                   â”‚             â”‚
│            â”‚(12)  QUANTITY TRACKING                              â”‚             â”‚
│            â”‚(13)  ZERO QUANTITY                                  â”‚             â”‚
│            â”‚(14)  DAILY SALES STATISTICS                         â”‚             â”‚
│            â”‚** 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 valuation 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.

 

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

 

"Y" to print separate report for each store.

 

"N" to not print separate report for each store.

 

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

 

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

 

** VARIANCE % BETWEEN AVE & LAST COST (CR=ALL):

 

Enter variance between average and last costs as percentage.

 

This option enables you to limit the products to include in the report only to those whose average and last costs variance is exactly the percentage you enter. You can include up to 2 decimal places in your entry. If you do not enter a decimal value, the program will add .00 to whatever number you enter. If you enter a value the following prompts display.

 

 

** ALSO PRINT IF QTY=0 AND VALUE ONHAND<>0?:

 

[Enter] to accept default value "Y".

 

"Y" to include if quantity is zero and on hand value non-zero.

 

"N" to not include if quantity is zero and on hand value non-zero.

 

** ALSO PRINT IF QTY<0?:

 

[Enter] to accept default value "Y".

 

"Y" to include if quantity is less than zero.

 

"N" to not include if quantity is less than zero.

 

[Enter] for all variance percentages.


OTHER COSTING OPTIONS:
( 1)  ALL PRODUCTS
( 2)  ONLY PRODUCTS WITH A QTY OR VALUE ON HAND
( 3)  ONLY PRODUCTS WITH AN AVERAGE OR LAST COST
( 4)  ONLY PRODUCTS WITH NO AVERAGE AND LAST COST
( 5)  ONLY PRODUCTS WITH NEGATIVE VALUE OR QTY
( 6)  ONLY PRODUCTS WITH A QTY ON HAND
** ENTER OPTION DESIRED (CR=1):

 

[Enter] to accept default value "1".

 

"1" to include all products.

 

"2" to include only products with quantity or value on hand.

 

"3" to include only products with average or last cost.

 

"4" to include only products with no average and last cost.

 

"5" to include only products with negative quantity or value.

 

"6" to include only products with quantity on hand.

 

** SHOW SUB# BREAKDOWN? (Y/N):

 

[Enter] to accept default value "N".

 

"Y" to show quantity and value breakdown.

 

"N" to not show quantity and value breakdown.

 

** INCLUDE PRODUCT WEIGHT? (Y/N):

 

[Enter] to accept default value "Y".

 

"Y" to include product weight.

 

"N" to not include product weight.

 

** PRINT ONLY PRODUCTS WITH ZERO WEIGHTS? (Y/N):

 

If you select option "N" at the previous field, this field defaults to "N".

 

 

[Enter] to accept default value "Y".

 

"Y" to include only products with zero weight.

 

"N" to not include only products with zero weight.

 

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.

 

** LAST RECEIVED START DATE (CR=FIRST;F1='UNSET'):

 

Enter last receipt date to begin range in format YYYYMMDD.

 

[Enter] for first system date.

 

[F1] to clear previously entered date.

 

** LAST RECEIVED END DATE (CR=LAST;F1='UNSET'):

 

Enter last receipt date to end range in format YYYYMMDD.

 

[Enter] for last system date.

 

[F1] to clear previously entered date.

 

** NUMBER OF COPIES (CR=1):

 

Enter number of copies to print.

 

[Enter] to print one copy.

 

Example Completed Parameters Entry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/31/08             ***** INVENTORY VALUATION REPORT *****              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 GROUP TOTALS ONLY? (Y/N):                N                             â”‚
│** WHICH GROUP LVL TOTALS? (NONE/1/2/3/4/CR=ALL): ALL                           â”‚
│** PRODUCT STATUS: RE/DI/SO/SP/BP; CR=ALL):       STATUS: ALL                   â”‚
│** SELECTED BUYER CODES (CR=ALL, F6=ALL):         ALL BUYERS                    â”‚
│** DELETED OPTION:                                ONLY NON-DELETED PRODUCTS     â”‚
│** PRINT SET/KITS? (1=NO/2=YES/3=ONLY; CR=NO):    1                             â”‚
│** VARIANCE % BETWEEN AVE & LAST COST (CR=ALL):   10.00                         â”‚
│** ALSO PRINT IF QTY=0 AND VALUE ONHAND<>0?:      Y                             â”‚
│** ALSO PRINT IF QTY<0?:                          Y                             â”‚
│** OTHER COSTING OPTIONS:                         ALL PRODUCTS                  â”‚
│** SHOW SUB# BREAKDOWN? (Y/N):                    Y                             â”‚
│** INCLUDE PRODUCT WEIGHT? (Y/N):                 Y                             â”‚
│** PRINT ONLY PRODUCTS WITH ZERO WEIGHTS? (Y/N):  N                             â”‚
│** LUMBER QUANTITY UNIT OF MEASURE OPTIONS:       PIECES (IF RANDOM LENGTH PRODU│
│** LAST RECEIVED START DATE (CR=FIRST;F1='UNSET'):01/01/08                      â”‚
│** LAST RECEIVED END DATE (CR=LAST;F1='UNSET'):   99999999                      â”‚
│** NUMBER OF COPIES (CR=1):                       1                             â”‚
│** PRESS CR TO CONTINUE OR F1 TO CONTINUE AND PRINT THE OPTIONS:                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** 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.

 


The printer 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 Valuation Report printout follows.

  



                                                    IDEAL BUILDING SUPPLIES LTD.
10/10/07  16:26:22                                                                                                        PAGE: 1
                                    INVENTORY VALUATION REPORT - 01 'IDEAL BUILDING SUPPLY LTD'
                                       PRODUCT DETAIL - ALL GROUP LEVEL TOTALS - NO PACKAGES
-----------------------------------------------------------------------------------------------------------------------------------
                                              SUPPLIERS'S           <--QUANTITY--><-------------COSTS------------->           VALUE
PRODUCT       DESCRIPTION                     PROD CODE             ON HAND  UNIT SUPPLIER   AVERAGE      LAST UNIT  VAR%    ON HAND
-----------------------------------------------------------------------------------------------------------------------------------

ST-HT-CH     CHISELS

343490        12LB CHISEL POINT BAR 48"       BAR12                       4  EA       .000    11.593    10.950 EA     5.9    46.37
312290        16-204 HANDYMAN CHISEL 1/4"     16204                       0  EA       .000     6.880     6.880 EA     0.0     0.00
312300        16-208 HANDYMAN CHISEL 1/2"     16208                       0  EA       .000     7.020     7.020 EA     0.0     0.00
312310        16-212 HANDYMAN CHISEL 3/4"     16212                       0  EA       .000     7.360     7.360 EA     0.0     0.00
323100        18LB CHISEL POINT BAR 60"       BAR18                       0  EA       .000    14.490    14.490 EA     0.0     1.45-
                                                                  ---------                ---------                    ----------
**** GROUP 'ST-HT-CH' TOTALS:                                             4                   11.230                         44.92
 *** GROUP 'ST-HT-CH' TOTALS:                                             4                   11.230                         44.92

ST-HT-HA     HAMMERS

320570        16 OZ CLAW HAMMER               SAUDIHAMMER               395  EA     14.990    25.257    25.980 EA     2.8  9976.55
331760        2-1/2LB CLUB HAMMER             TOO205-2.5                  0  EA       .000     2.990     2.990 EA     0.0     0.00
323320        3LB CLUB HAMMER                 TOO205-3                    0  EA       .000     5.950     5.950 EA     0.0     0.00
323310        4LB CLUB HAMMER                 TOO205-4                    1  EA       .000     6.610     6.600 EA     0.2     6.61
311550        4LB SLEDGE HAMMER 306-04        SLE306-04                   4  EA       .000     9.018     8.830 EA     2.1    36.07
334190        51-110 WORKMASTER HAMMER 22oz   51110                      14  EA       .000    18.130    16.960 EA     6.9   253.82
605130        51-361 HAMMER CH/FACE AXE 25oz  51361                       2  EA       .000    27.320    27.320 EA     0.0    54.64
603700        51-441 GRAPHITE HAMMER 16oz     51441                       3  EA       .000    23.510    23.510 EA     0.0    70.53
404440        51-605 NAIL HAMMER 52-605       51605                      45  EA       .000    12.900    12.900 EA     0.0   580.50
320591        8 X 8 WEST PAML DUNES TILE      SAUDITILE                  75  PIEC     .530      .530      .530 PIECE  0.0    39.75
320576        AGAG                                                        0  EA     19.990      .000      .000 EA     0.0     0.00
320575        AGDSAG                                                      0  EA       .000      .000      .000 EA     0.0     0.00
                                                                  ---------                ---------                    ----------
**** GROUP 'ST-HT-HA' TOTALS:                                           539                   20.442                      11018.47
 *** GROUP 'ST-HT-HA' TOTALS:                                           539                   20.442                      11018.47
  ** GROUP 'ST-HT' (011300) TOTALS:                                     543                   20.375                      11063.39
   * GROUP 'ST' TOTALS:                                                 543                   20.375                      11063.39

RECORDS PRINTED:   17