Inventory Movements
Inventory Movements is the audit trail for a single item — every transaction that changed its stock, in date order, showing quantity in and quantity out. When physical stock and system stock disagree, this is where the answer is.
Where to find it
Go to Inventory > Inventory Movements.
Filters Section
| Filter | What it does |
|---|---|
| Item | The product to trace. Movements are reported one item at a time. |
| Location | Restrict to one warehouse. |
| Date range | The period to report over. |
Opening and Closing Balances
The report brackets the period with an opening and a closing balance. Opening plus everything in, less everything out, equals closing — if it does not, the discrepancy is inside the period you are looking at.
Movements Table
| Column | Description |
|---|---|
| Date | When the movement occurred. |
| Type | What caused it — delivery, goods receipt, adjustment, transfer, disposal. |
| Reference | The source document. Click through to the transaction itself. |
| Quantity In | Units added by this movement. |
| Quantity Out | Units removed. |
| Balance | Running stock after the movement. |
Audit Insights
Read the Type column first. Sales and purchases explain themselves; a run of adjustments usually means somebody is correcting a problem rather than fixing its cause. Frequent adjustments on one item are worth investigating.
Related pages
- Items View — the transactions tab on an item
- Reconcile — correcting after a physical count
- Adjustments List — manual corrections
- Transfer List — movements between locations