Inventory Valuation Report

The Inventory Valuation Report will give you the total dollar amount of Materials Inventory on hand.  The report will list each inventory item separately, with a beginning balance, total moved, received, and balance on hand.  This will include cost per unit, total dollar amount on hand per inventory item and total dollar amount for all the inventory items.

The Inventory Valuation Report also updates inventory balances.  Either this report, the Warehouse Activity Report or the Physical Count Worksheet should be run regularly to update balances.

If you need more specific details on the quantities, such as quantity in transit, allocated and on hand, and do not need the dollar valuation, you should use the Inventory Activity Report instead of the Inventory Valuation Report.

The valuation amount that prints for each item always includes any freight costs that were recorded on the Purchase Orders.  When printing a report for current balances, the report will also show the freight amount that is included in the total value for each item.  When printing a report for a prior period, the freight amount will not be printed.

Go to Materials Inventory > Reports > Inventory Valuation Report.

Report Starting/Ending Dates

Enter the dates for the period you would like to see on the report.  The program will update inventory balances for the period you specify.

Starting/Ending Warehouse

You will need to enter a Warehouse location here, even if you only have one location.  If you only have one location, choose it from the lookup on both the Starting and Ending Warehouse.

If you are printing the valuation for multiple warehouses, select the starting and ending warehouse numbers from the lookup.

Starting/Ending Stock #

For valuation of all inventory items, leave these fields blank.

For specific inventory items, select the starting and ending stock numbers from the lookup.

Product Code From

For Materials Inventory Valuation, enter a Product Code range.

Report Type

Detail:  Will show details by item, each time there was movement on that item.

Summary:  Will show one line per item, with totals moved instead of one line for each transaction.

Report Order

Select ordering by Stock Number, Description, or Product Code.

When you have made your report selection criteria, you can preview the report on screen or print the report using the print options at the bottom of the window.