Show/Hide Toolbars

SpendMap User Guide (v14.5)

Navigation: Inventory Control > Reports

Inventory Valuation Report

Scroll Prev Top Next More

INVENTORY CONTROL > Reports > Inventory valuation

 

This report lists the quantity and dollar value of the items that you have in-stock and on open (un-received) Purchase Orders and Releases, for one or many items, in addition to other high-level inventory-related information for the selected item(s).

The report can be based on the actual price that you paid for the items (i.e. the First-In-First-Out or FIFO value) or based on a standard value for each item, depending on the applicable setting in Inventory Options.

You can run the report for one or many inventory locations and there are various other options for the report.

hmtoggle_arrow0        Related settings and reports

hmtoggle_arrow0        Related information

 

Noteworthy Questions & Options

If you use Standard Value for your inventory valuation method (per setting in in Inventory Options), you will be prompted for an “inventory value as of” date. You can use this to show on-hand value as of a date in the past. However, if you run the report for any date other than the current date, the report will not include the on-order balances (the column will show “N/A”).

While non-stock items will never have an in-stock value, you may choose to include non-stock items as they may be on-order. Items can be set up as either stock or non-stock in the Item Master File.

You can include or exclude items with ZERO stock balances and items with negative stock balances. Excluding these items will shorten the report.

You can include or exclude items whose values have been charged directly to cost centers when purchased/invoiced but are being kept in stock at zero dollar value. This feature can be enabled for items in the Item Master File.

You may want to exclude these items since, while they are actually in stock, their value has already been distributed to the end-user cost centers.