Items > Inventory > IN-F Print Inventory Value

IN-F Print Inventory Value

Purpose of Program

Use this program to get an inventory value of all or selected inventory items, either at actual (average) cost or including both standard and actual cost. Standard costs are broken out into material, setup, labor, outside processing, fixed overhead, and variable overhead. This report can be run as of a prior date in which case it takes the current on hand and extended value and backs out transactions back to arrive at the value as of the specified date.

The report automatically subtotals by item class when run sorted by class.

General Program Operation

The first field lets you select All item numbers in range (meaning the from/thru range you will be entering later) or All except zero-value parts meaning items with zero book value will be excluded or Include On-Hand with $0 cost meaning that anything with on-hand quantity will be included even if the value is $0.

Under Inventory Types you can click the checkbox for the various types you want included on the report. To exclude a type, clear the field.

You then can indicate Active status to include (Y,N,O,E,D,P, Q, R, S), Include standard costs?, Include units in QC?, Print Subtotals only?, Print 2nd line part description?

If you have multiple Inventory Locations defined, you can select the Location(s) to be included and then click Go.

NOTE: The GL Book Value is not maintained by Location and will only be reported if printing all Locations.

You can further limit the report by entering from/thru ranges of item numbers, item classes, and GL asset accounts.

If you enter an as-of date, the report will calculate today's inventory value and then back out all transactions back to the date specified to calculate the value as of that date. If any of the transactions encountered are denoted as "Consolidate Inventory Transactions" then the report will indicate that it may be inaccurate as the consolidated transaction may contain activity both before and after the as of date.