# Item wise Report
Opening, inward, outward and closing stock for each item over a selected period. Optionally shows value, per-center movement, reservations, open purchase orders, and last purchase party and price.
Overview
Go to Inventory → Inventory Reports → Item wise Report.
Report title in ERP: Item Wise Inventory Report
What it shows. One row per item with the Opening, In, Out and Closing quantity for the selected date range. Turn on Show Value to add value columns under each stage and a closing average value; turn on Show Centers to break each item down by center; turn on Show Last Purchase to add the last purchase party and price. Use Internal Transfers under More to include or exclude transfers and production movement in In and Out. Click an item to open its transaction history.
When to use it. Use to track stock movement for a period, to reconcile opening and closing balances, and to review consumption or receipts item by item.
Use Cases
- Inventory controller — What moved in and out of each item this month and what is the closing balance? Run for the period and review In, Out and Closing.
- Finance — What is the opening and closing value of stock for a period? Turn on Show Value for valued movement.
- Branch manager — How did stock move across centers for an item? Turn on Show Centers to expand per-center rows.
- Purchase planner — Which items have open purchase orders against current stock? Turn on Show Open Purchase Orders. Who last supplied an item and at what price? Turn on Show Last Purchase.
Filters
Date range and Item Group. Advanced Filter: Item, Item Type, Center, Brand, Item Group.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item | Item name. Click to open its transactions. |
| Item Code | Item code. |
| Unit | Inventory keeping unit. |
| Min Order Qty | Minimum order quantity (shown when Show Min Order Qty is on). |
| Max Stock Qty | Maximum stock quantity (shown when Show Max Stock Qty is on). |
| Last Purchase Party | Supplier from the latest approved or paid purchase invoice (shown when Show Last Purchase is on). |
| Last Purchase Price | Unit price from that last purchase invoice line (shown when Show Last Purchase is on). |
| Center | Inventory center (shown when Show Centers is on). |
| Opening | Quantity (and value) at the start of the period. |
| In | Quantity (and value) received during the period. |
| Out | Quantity (and value) issued during the period. |
| Closing | Quantity (and value, plus average value) at the end of the period. |
| Reservations | Quantity reserved against orders (shown when Show Reservations is on). |
| Current Available | Quantity free to use after reservations (shown when Show Reservations is on). |
| Open POs | Quantity on open purchase orders (shown when Show Open Purchase Orders is on). |
| Future Available | Available quantity including open purchase orders (shown when Show Open Purchase Orders is on). |
When Show Value is on, the Opening, In, Out and Closing stages each show a Qty and Value sub-column.
Internal Transfers
Under More → Include, Internal Transfers controls whether inventory transfer, WIP transfer, and issue/receipt from production are counted in In and Out.
- Off by default. In and Out then show external movement only (purchase, sale, adjustment, and similar).
- Turn it on when you need transfer and production movement in the period totals.
- Closing quantity is the same either way — only the In and Out figures change.
- Generate again after toggling. Export All uses the same setting.
Actions
- Generate — run the report for the selected filters
- More — toggle Show Centers, Show Value, Show Items without movement, Show No Stock Items, Show Min Order Qty, Show Max Stock Qty, Show Reservations, Show Open Purchase Orders, Show Last Purchase, Internal Transfers
- Export All — export the full report to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
What do Opening, In, Out and Closing mean?
Opening is the balance at the start of the date range, In is everything received, Out is everything issued, and Closing is the balance at the end.
How do I see value, not just quantity?
Select Show Value from the More menu to add value sub-columns and a closing average value.
Can I see the movement per center?
Yes. Choose Show Centers to expand each item into per-center rows.
How do I see the last purchase party and price?
Select Show Last Purchase from the More menu. The party is the supplier on the latest approved or paid purchase invoice for that item; the price is the unit price on that invoice line. Items with no purchase history show a dash.
Do internal transfers change In and Out?
Only when Internal Transfers is selected under More → Include. Off by default. See Internal Transfers.
How do I open the documents behind the movement?
Click an item to open Item Transactions for the same period.
Why is my report empty?
No items had inventory movement in the date range, or filters exclude all rows.
Why does the date range fail validation?
About 12 months maximum. Shorten the from/to period if validation fails.
Are child item groups included?
Yes. Filtering by parent item group typically includes items in sub-groups.