Inventory Value Report

Reports View --> Inventory --> Inventory Value-As-Of-A-Date

This report provides the ability to pull an inventory value based on a date entered.  It does this using the INs and OUTs inventory ledger system to "back out" transactions from the current day back to the date entered for the report.  It finds the last transaction on that date or before, and using the average cost and quantity on hand as of that date, computes the value for each item.

This is a very powerful report and only possible because of the INs/OUTSs inventory ledger and the fact that the ledger captures both the average cost and quantity on hand at the time of each transaction.

(A similar report is available for capturing A/R Value-As-Of-A-Date.)