Inventory Items — Qty on hand — Transactions
The Qty on Hand - Transactions screen shows detailed inventory movements for a specific inventory item and inventory location.
This report displays all transactions that have affected inventory quantities, providing a complete audit trail of inventory changes.
Each transaction shows the quantity change and maintains a running balance to help you track inventory levels over time.
Date
The date when the inventory movement occurred.
Transactions are displayed with the most recent first, making it easy to see current inventory activity.
Transaction
The type of transaction and its reference number.
Click on the transaction to view or edit its details.
Customer
The customer associated with this inventory movement.
This column appears when inventory is sold or delivered to customers.
Inventory Item
The inventory item being tracked in this report.
When viewing transactions for a specific item, this column shows the same item for all rows.
Supplier
The supplier associated with this inventory movement.
This column appears when inventory is received from suppliers or returned to them.
Inventory Location
The inventory location where this movement occurred.
When viewing transactions for a specific location, this column shows the same location for all rows.
Qty on hand
The quantity change for this transaction.
Positive values increase inventory (purchases, goods receipts, production orders, customer returns).
Negative values decrease inventory (sales, deliveries, inventory write-offs, supplier returns).
The running total column shows the cumulative inventory quantity after each transaction, helping you track inventory levels over time.