Value the stock on hand
Determine what stock is on hand and what it is worth.Updated Nov 5 2026
Who this is for
Accounting reports the value of inventory at month and year end. Warehouse leads use the same reports to see what is where, and to answer "why did this quantity change?"
Who can see what: cost and value columns need permission to see cost; Parts > Reports
is in the menu for the Manager role; the ledger check is for Accounting Admin. Without
them you still see quantities and a part's own history.
Why it matters: inventory is often the biggest number on the balance sheet. If the inventory report and the general ledger disagree, one of them is wrong, and the auditors will want to know which.
-
Run the inventory report
- Open
Parts > Lists > List By Bin. The screen is headed Part List By Bin. - Click
Filters, pick theLocation(warehouse), and narrow byPrcpart,BinorLot Codeif you need to. Pick a part from the suggestions; typed text alone is ignored. - Click
Apply. Each row is one bin of one part, so a part in three bins shows three times.Bin Qtycounts everything in the bin, including parts already picked to orders.Pick Qtyis the picked part, andShelf Qtyis what is physically on the shelf. - Read the total value at the foot of the
Bin Ext Valuecolumn. - Click
Exportto keep a copy for the period.
- Open
-
Trace a change in stock
- Open
Parts > Reports > Inventory Activity. - Click
Filtersand filter byLocation,Prcpart,Binand dates, and byReasonto see one kind of change, such as Receipt, Shipment or Miscount. - Click
Apply. Each row shows the quantity change, the new bin quantity, the user and the reason, and the old and new cost if you can see cost.
- Open
-
Check it against the ledger
- Open
Accounting > Audit > Inventory Activity Vs Ledger. - Set the
From Date,To DateandLocation, and run it. - Look into any day where inventory activity and the general ledger differ.
- Open
Other ways to do this
One row per part
For one row per part instead of per bin, use Parts > Reports > Inventory Value.
Trace one part's changes without the Reports menu
From a part, Activity > History opens the same Inventory Activity report for that part
only, from about 30 days back. This works without the Reports menu.