The Inventory Value Report gives you a dollar value of your current inventory on hand.

The "Inv Value Date/Time" prompt is accessible by using the <Up Arrow> key from the Status prompt, as long as there is captured data available. Inventory Value data can be captured at any time from TCL with the CAPTURE.IVAL program or to capture value at month end you may setup the program to run in “Batch Processing Entry” in SYSTEM MANAGEMENT (10.10.1).

When running the report based on previous data, the following prompts will not be available:  Status, Beginning Date Created, Ending Date Created, Manufacturer Sort Code, Inventory Group Code, Price Code (Locked at 99), Popularity Codes, Periods WithOut Sales and OL and SL = 00. Additionally, the Overstock Options (Show QOH - <O> & <O2>) are not available. Note that not all data fields are saved when running CAPTURE.IVAL. A note at the bottom of the report further explains the nature of the output:  All Columns except for QOH, Average Cost, Value, and Total Value are from Current Data. There may be Parts and/or Units of Measure included on the Report that no longer exist.

If you choose ALL Locations or Regions, you will have the options of showing a breakdown of each Location or Region on the report or a summary of All locations/regions.

The Beginning & Ending Date Created refers to the Part Number Creation Date located in “Inventory Entry” (5.1.1).

You may identify those items that have Quantity on Hand but no Sales. This is accomplished by entering those periods that you want to select parts without sales history. You must use this feature in conjunction with the “Show Only Non-Zero or Positive Only QOH” selection criteria below.

If printing the Inventory Value Report on systems with more than one location, and Periods Without Sales History have been entered, then the following prompt will appear:  “Print Parts Without Sales History in ALL Locations”. If <Y> is entered, then a part will only print if there are NO sales for ALL Locations and for ALL Units of Measure. If <N> is entered, then any Location or Unit of Measure without sales history will print. This is very useful if you want to identify those parts that did not sell company-wide. If you are running the report for a particular Region, the prompt options are a little different:  Enter <Y> to only print parts Without Sales History in this Region, or Enter <A> to only print parts Without Sales History in ALL Locations.

The Last Date Received option allows the user to select items that have not been received since particular date to help identify dead stock. If ALL locations are selected, each part number/unit of measure will be validated against the date last received in each location to determine whether to include the QOH on the report.

You may list only those part number units of measure with Order Level and Stock Level = 00. This is useful for identifying parts that have Quantity on Hand but the Order Level and Stock Level = 00. Part Numbers with OL and SL =00 will always be ignored when generating an Automatic Purchase Order in "Generate Automatic Purchase Order for Vendor" in PURCHASING (3.2.1).

The Totals Only prompt gives you the option of including the Part Numbers on the report.

Y = Do NOT include the part numbers on the report.

N = Include the part numbers on the report.

G = Grand Totals only.

The Total Inventory Value does not include Consignment Orders.

You may narrow this report further by choosing items based on the Quantity on Hand.

N = Show Negative Quantity on Hand Only.

P = Show Positive Quantity on Hand Only.

O = Show Overstock Quantity on Hand Only (QOH >= Stock Level).

O2 = Show Overstock Quantity on Hand Only (QOH > Stock Level).

O3 = Show Overstock Quantity on Hand Only (QOH > Calculated Stock Level).

Z = To Not Show Zero Quantity on Hand Parts.

Enter = Show all Part Numbers.

If the Z option is chosen (Z = Do not show Zero Quantity on Hand Parts), the Inventory Value Report will run significantly faster. With this option, if the Quantity on Hand is Zero for the entire line, the Manufacturer’s information will not be printed on the report.

You have the option of Consolidating Overstock for multi-location systems. If you are printing “ALL Locations” and choose one of the Overstock options, you will be prompted with “Consolidate Overstock”. If you choose to consolidate, the Inventory Value Report will only print the part number units of measure that are overstocked if the Quantity on Hand is greater than the Stock Level when all location values are added together. Enter <A> to compare and show All locations even if not overstocked at all locations. If either <Y> or <A> are selected, then only those parts that are overstocked for the total for all locations are selected. The only difference between the <Y> and <A> option is that the <Y> option only prints and calculates overstock for those locations that actually have overstock, and the <A> option prints and calculates for All locations. This feature will help you avoid ordering more stock when it is available in another location.

If the <O3> Option is selected, 2 additional prompts will appear prior to the Consolidate Overstock prompt:

Number of Months to Calc Avg Sold

Number of Months to Calc Stock Level

In the output, the Stock Level column will show the calculated value, and the report will show all parts that exceed the calculated stock level. If an item had no sales over the requested months (or the average sale per month calculated to zero), the resulting stock level will be zero.  These items will be considered overstocked if any quantities exist on hand. Case Lot items will be summarized to the largest unit of measure for the purposes of calculating the Average Sold Per month. As with the <O> and <O2> overstock versions of the report, only the largest unit of measure in case lot items will be printed on the report if overstocked.

You have the ability to include the Quantity on Hold (QHD) in the Quantity on Hand (QOH) when calculating the Inventory Value.  Since the QHD is not actually gone from inventory yet, you don’t have to delete all your Hold Orders or run a Hold Order Report to include those quantities in your Inventory Value Report.

There is a prompt to “Include Defective QOH” in the Inventory Value report. Enter <Y> to include Defective QOH in the Quantity on Hand when calculating Inventory Value.  Enter <O> to use Defective QOH only. If the option <O> is chosen, then the QOH and QHD will not be included on the report, even if the option to include QHD was chosen.

You may generate the report to a <P>rinter, <S>creen, <F>ile, or F<A>x. When running the report to a File with Totals Only <N> option, only the part detail will be included in order to maintain a consistent file layout. If Subtotals are desired by Group Code or MFR Code, you will need to select the Totals Only <Y> option. This will create a file layout based on the Subtotals and Grand Totals only.

The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in “Port Entry” in POINT OF SALE (1.10) to enable this function.

       

After the report is displayed to the screen you also have the option of entering a <D> to download the report to your local hard drive. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.

Note: The <F>ax option also includes Email capability. Emailing and Faxing require optional Software and additional Setups. Please contactPerfection Software Sales Department for more detailed information.

If a part number is flagged as Case Lot "Y" in "Inventory Entry" (5.1.1field 6), the sub-units will not appear on the Inventory Value Report if the Overstock option is chosen.