# Value Table

<p class="doc-lead">The valued stock layers behind an item — quantity, average value and total value broken down by center, batch, warehouse bin, variant and work-in-progress.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/inventory/reports/value-table?id=overview">Overview</a>
<a href="#/inventory/reports/value-table?id=use-cases">Use Cases</a>
<a href="#/inventory/reports/value-table?id=filters">Filters</a>
<a href="#/inventory/reports/value-table?id=columns">Columns</a>
<a href="#/inventory/reports/value-table?id=actions">Actions</a>
<a href="#/inventory/reports/value-table?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Inventory → Inventory Reports → Value Table</b>.

Report title in ERP: <b>Inventory value table</b>

<p><b>What it shows.</b> Each valued stock line for the selected item — quantity, average value per unit and total value — split by center, batch, warehouse bin, variant and whether it is work-in-progress. Totals for quantity and value appear at the bottom. Click an item to open its transactions, or a batch to open the batch enquiry.</p>

<p><b>When to use it.</b> Use to understand how an item's stock value is built up across its layers, and to investigate average costing per center or batch.</p>

<p><img src="inventory/images/value-table.webp" alt="Inventory Value Table view" loading="lazy"></p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Finance / costing</b> — What is the average and total value of an item's stock by layer? Run for the item and read the value columns.</li>
<li><b>Inventory controller</b> — How is value spread across centers and batches? Review the Center and Batch columns.</li>
<li><b>Auditor</b> — Are there stock lines awaiting a value? Choose <b>Show Pending values</b>.</li>
<li><b>Warehouse supervisor</b> — What value sits in each bin? Review the Inv Bin column where bins are enabled.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<b>Item</b> and a status selector: <b>Status-all</b> or <b>Show Pending values</b>.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| Item Name | Item name. Click to open its transactions. |
| Variant | Item variant (where variants are enabled). |
| Item code | Item code. |
| Center | Inventory center for the stock layer. |
| Batch | Batch for the stock layer. Click to open batch enquiry. |
| Inv Bin | Warehouse bin (where bins are enabled). |
| WIP | Marks the layer as work-in-progress. |
| Quantity | Quantity in the stock layer. |
| Avg Value | Average value per unit. |
| Total Value | Total value of the layer (quantity × average value). |

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected item</li>
<li><b>Export</b> — export the report to Excel</li>
<li><b>Print</b> — print the report</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>What does Show Pending values do?</b><br>It limits the table to stock lines that are still waiting for a value to be assigned, which is useful when investigating un-costed receipts.</p>

<p><b>Why does one item have several rows?</b><br>Stock is valued in layers by center, batch, bin, variant and WIP, so an item can appear once for each distinct combination.</p>

<p><b>How is Total Value calculated?</b><br>Total Value is the layer's quantity multiplied by its average value.</p>

<p><b>How do I see the movements behind a layer?</b><br>Click the item name to open <a href="#/inventory/reports/item-transactions">Item Transactions</a>, or the batch to open the batch enquiry.</p>

<p><b>Why is my report empty?</b><br>All stock layers may already have assigned values, or filters exclude items with pending costing.</p>

<p><b>When should I use Show Pending values?</b><br>When investigating receipts or adjustments that posted quantity before unit cost was finalized.</p>

<p><b>Does this change inventory value?</b><br>No. This is a read-only analysis report. Post value corrections through <a href="#/inventory/inventory-revaluation">Inventory Revaluation</a> or related documents.</p>
