Movements
The Asset Movements list is a ledger-style audit trail of every transaction against an asset. It tracks quantity in, quantity out and the resulting quantity on hand across locations and dates, which is what lets you reconcile the physical count with the system record.
Where to find it
Go to Fixed Assets and click the Movements tab.
Filters Section
Use these to dig into one asset's history, or to reconcile physical stock against the records.
| Filter | Description |
|---|---|
| Item | Select the asset to see its unique history. |
| Show inactive | Includes history for assets disposed of or deactivated. |
| Location | Narrow to one warehouse, office or branch. |
| Date Range | The period to report on. |
| Batch No & Item Color | Filter by batch number or product variation, where these apply. |
| Filter Type & Expiry Date | Find items by shelf life or expiry timeline. |
| Audit Trail Order | Sorts movements chronologically, so you follow the exact sequence of events. |
| Search | Generates the report from the filters set. |
Movements Table
The table works as a financial ledger, showing the flow of assets in and out of your records.
| Column | Description |
|---|---|
| Type | The nature of the movement — typically a journal entry, or an opening or closing balance. |
| Reference | The source document ID for the movement. |
| Standard Cost | The asset's recorded standard cost at the time of the movement. |
| Quantity In / Quantity Out | Units received or removed. |
| Quantity on Hand | The running balance after the movement. |
Movement Summaries
| Row | What it shows |
|---|---|
| Quantity on hand before [Date] | The opening balance and value at the start of your date range. |
| Quantity on hand after [Date] | The closing balance and quantity once every movement in the period is applied. |
Turn on Audit Trail Order when the closing balance does not agree with the physical count. Reading the movements in the exact sequence they happened is how you find the transaction that put them out of step.
What to use it for
- Proving an asset's history to an auditor from purchase to disposal.
- Reconciling a site count against the register before year end.
- Confirming a transfer actually posted, rather than being left in draft.