# Item Transactions
Full movement history of a single item over a selected period. Lists every transaction that changed the item's stock, with opening and closing balances and an optional value column.
Overview
Go to Inventory → Inventory Reports → Item Transactions.
What it shows. Choose an item and a date range to list every stock movement — receipt notes, delivery notes, transfers, adjustments, invoices, production vouchers and more — in date order. The report shows the Opening balance, each transaction's In and Out quantity, and the Closing balance. Turn on Show Value to add value columns. Click any row to open the underlying voucher.
When to use it. Use to trace exactly how an item's stock changed, to investigate discrepancies, and to find the documents behind a balance.
Use the Advanced Filter to narrow the list by center, transaction type, batch or work-in-progress.
Use Cases
- Inventory controller — What changed this item's stock during the period, and in what order? Run for the item and date range.
- Auditor — Which document caused a particular increase or decrease? Click the row to open the source voucher.
- Store keeper — What receipts and issues happened at a specific center? Filter by Center.
- Quality team — How did a specific batch move? Filter by Batch.
Filters
Item (required) and Date range. Advanced Filter: Center, Transaction Type (Receipt Note, Delivery Note, Inventory Transfer, Inventory Adjustment, Inventory Revaluation, Purchase Invoice, Sale Invoice, Debit Note, Credit Note, Opening Inventory, Production Voucher, Issue For Production, Receipt From Production, Inventory Conversion, Consumable Issue), Batch, WIP.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Transaction date and time. |
| Processed On | When the transaction was recorded in the system. |
| Voucher Type | Type of transaction (receipt note, delivery note, invoice, etc.). |
| Voucher Id | System reference of the transaction. |
| BillNumber | Document number of the transaction. |
| Center | Inventory center for the movement. |
| Inventory Bin | Warehouse bin (shown when bins are enabled). |
| Batch | Batch involved (shown when batches are enabled). |
| Note | Notes recorded on the transaction. |
| In | Quantity (and value) added to stock. |
| Out | Quantity (and value) removed from stock. |
| Balance | Running balance after the transaction (when applicable). |
The list begins with an Opening row and ends with a Closing row. When Show Value is on, the In and Out columns each show a Qty and Value sub-column.
Actions
- Generate — run the report for the selected item and date range
- Show Value / Hide Value — toggle the value columns
- Export — export the report to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
Why is the report empty?
An item is required. Select an item before generating; the report cannot run without one.
How do I open the document behind a movement?
Click any transaction row to open the underlying voucher.
Can I see only one type of movement, like adjustments?
Yes. Open the Advanced Filter and set Transaction Type.
Where do the Opening and Closing balances come from?
Opening is the item's balance just before the start date; Closing is the balance at the end of the range after all listed movements.
Why does the date range fail validation?
Most item transaction reports allow about 12 months maximum. Select a shorter period and generate again.
Which document statuses are included?
Approved and closed inventory movements only. Draft receipts and deliveries do not appear.
Can I include WIP movements?
Use transaction type and WIP filters in advanced filter when your company tracks production inventory separately.