Inventory Value Reports
Reports Menu -> Inventory -> Inventory Value Reports
The inventory value reports are separated for Sales Inventory and Rental Inventory.
The inventory reports list the current inventory value, unless the By Date option is selected.
Reports include:
•Rental Inventory Value Report
By Date option:
These programs can calculate the Inventory Value as of a date in the past using the Inventory Adjustment records, Warehouse Receipts, and the Detailed Revenue History (Sales History INSH) to reconstruct the inventory quantities as of a selected date.
When the By Date option is selected, the inventory QUANTITY is reconstructed as at a prior date, but the INVENTORY VALUE will not necessarily be correct for either sales or rentals.
This is because the value is calculated by multiplying the Quantity at the prior date, by the Average Cost currently in the Sales Inventory or Rental Inventory, and this average cost is updated each time a product is purchased and received into stock.
If there is no value in the sales product reports, check the Cost Type defined in Sales Inventory for that item.
For sales products flagged as Zero Cost, no average cost will be recorded as the assumption is that the stock has been expensed upon purchase, and therefore no inventory value for reporting purposes is required.
Note: When sales parts are used on a W.O., these reports respect the date issued from the product detail line, rather than the invoice or W.O. header date.
Serialized Sales:
If your firm has serialized sales items, Sales Inventory Value Report provides the option to lists the serialized inventory as a separate report from the non-serialized inventory.
It also lists each serial # and cost. The cost can be average cost or the serialized cost on each serial # record.