# Stock Report
Current stock position of every item across all inventory centers. Shows item code, unit, brand and the quantity held in each center, with optional value, reservation and open purchase order columns.
Overview
Go to Inventory → Inventory Reports → Stock Report.
What it shows. One row per item with its code, unit and brand, followed by a quantity column for each inventory center, a Total Qty column and an optional Total Value. Extra columns for reservations, open purchase orders, report unit, minimum order and maximum stock quantities can be switched on from the More menu. Click an item to open its transaction history.
When to use it. Use for a quick stock check across centers, for stock-taking preparation, and to spot items that are over- or under-stocked.
Use Cases
- Store keeper — How much of each item is on hand in each center right now? Run before stock counts or replenishment.
- Purchase manager — Which items are low and have open purchase orders already covering them? Turn on Show Open Purchase Orders before generating.
- Sales coordinator — How much stock is free to sell after reservations? Turn on Show Reservations to see reserved and available quantity.
- Finance / inventory controller — What is the value of stock held by item? Turn on Show Value for the total value column.
Filters
Item name (type to search), Item type (All Items, Raw Materials, Consumable Items, Sellable Goods, Producible Goods, Packing Materials, Suspended Items), WIP (Including WIP, Excluding WIP, WIP only), and a sort selector (Sort by Sort order, Sort by name). Advanced Filter: Brand, Item Group, Item Sort Order, Item.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item | Item name. Click to open its transactions. |
| Item Code | Item code. |
| Barcode | Item barcode (shown when Show Barcode is on). |
| Unit | Inventory keeping unit. |
| Brand | Item brand. |
| Description | Item description (shown when Show Item Description is on). |
| Min Order Quantity | Minimum order quantity (shown when Show Min Order Qty is on). |
| Max Stock Quantity | Maximum stock quantity (shown when Show Max Stock Qty is on). |
| (one column per center) | Quantity held in each inventory center. |
| Total Qty | Total quantity across all centers. |
| Total in Report Qty | Total in the item's report unit (shown when Show Report Unit is on). |
| Total Value | Stock value of the item (shown when Show Value is on). |
| Reserved Qty | Quantity reserved against orders (shown when Show Reservations is on). |
| Available Qty | Quantity free to use after reservations (shown when Show Reservations is on). |
| Open PO Qty | 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). |
Actions
- Generate — run the report for the selected filters
- More — toggle optional columns: Show Zero Lines, Show Value, Show Report Unit, Show Min Order Qty, Show Max Stock Qty, Show Item Description, Show Barcode, Show Reservations, Show Open Purchase Orders
- Export All — export the full report to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
Why don't I see items with zero stock?
By default only items with stock are listed. Choose Show Zero Lines from the More menu to include items with no stock.
How do I see the value of my stock?
Select Show Value from the More menu. A Total Value column and total are added.
What does WIP only / Excluding WIP mean?
WIP is stock currently tied up in production. Use the WIP selector to include it, exclude it, or show only work-in-progress quantities.
How do I see the transactions behind a quantity?
Click the item name or item code to open its Item Transactions.
Why is my report empty?
No items have stock at the filtered center, or all items are excluded by item group, brand, or suspended-item filters.
Are service and asset items included?
Standard stock reports focus on inventory item types. Service and asset types are typically excluded from quantity stock views.
Does item group filter include sub-groups?
Yes. Selecting a parent item group usually includes items in child groups under it.