Inventory Control Reports: Valuation Audit, Cost Layers, Reconciliation & Exceptions
Four reports that answer the questions an auditor asks about stock: who changed a cost and why, what each unit on the shelf actually cost, whether the stock records agree with the documents behind them, and what needs someone's attention today.
All four are under Reports → Inventory & Stock, need the permission to view reports, and are also in the AWRA mobile app. Three of them export to CSV and PDF.
Valuation Audit Trail
This report shows every change to an item's unit cost or buying price: when it happened, the old and new values, how much was on hand at the time, which valuation method was in use, the reason, the reference, and who made the change. The trail is written by the item record itself whenever either value changes, so no screen, import or background job can change a cost without leaving a row.
The reasons are: Stock received, Landed cost apportioned, Assembly or disassembly, POS return restocked, FIFO layers consumed, Edited on the item, Bulk import and System recalculation. You can filter by date, reason, item or reference. If a cost moved and nobody expected it, start here.
Cost Layers
Every receipt that still has stock on the shelf is listed oldest first, with its unit cost, its landed cost, and how much of it is left. The totals give the number of open layers, items and units and their combined value. Under FIFO this is the order stock leaves in, and the cost it leaves at. Under moving average the layers are still recorded as history, and the report says that they do not set the cost. See Inventory Costing for how the two methods differ and how to switch between them.
Stock Ledger Reconciliation
For each item, this compares three figures. Book is the item's total, Shelf is the sum of its locations, and Ledger is every document that moved it netted together: receiving, check-ins and check-outs, counts, POS, transfers, assembly and returns. Each movement column is signed, so you can see which kind of document added stock and which took it away.
- Matched: all three agree.
- Book ≠ Shelf: the item total and its locations disagree, which usually points to a write that updated only one of them.
- Unexplained: stock that no document accounts for. The report shows how many units that is.
By default it shows only the items that do not match. Switch the filter to see every item.
Inventory Exceptions
This is one live list of everything that needs a person. Nothing is stored, so an exception disappears the moment the stock is fixed.
- Negative: a shelf below zero, meaning stock was issued that was never there.
- Stale: stock that has not moved for your dead-stock period.
- Overstock: more in a warehouse than its maximum.
- Expired: units of a batch still on a shelf after their expiry date.
- Unassigned: stock with no bin, or in a bin that has been made inactive.
- Shortage: a fast mover (top quarter by 30-day usage) with less stock than will last its lead time.
Related
See Stock Mismatch, Inventory Reports and Transfers On The Floor for the In-Transit Ledger.
Need help with this topic?
Capture the module, record number, branch or warehouse, user, visible message, and what you expected to happen before contacting support.