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
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
Transaction

The type of transaction and its reference number.

Click on the transaction to view or edit its details.

Customer
Customer

The customer associated with this inventory movement.

This column appears when inventory is sold or delivered to customers.

Inventory Item
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
Supplier

The supplier associated with this inventory movement.

This column appears when inventory is received from suppliers or returned to them.

Inventory Location
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
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.