# Item Wise Consumable Issue

<p class="doc-lead">Total quantity issued for each consumable item over a selected period. Summarises consumable issues by item, with optional value.</p>

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

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

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

Go to <b>Inventory → Inventory Reports → Item Wise Consumable Issue</b>.

<p><b>What it shows.</b> One row per item with the total <b>Quantity</b> issued as consumables in the selected period, plus a grand total. Turn on <b>Show Value</b> to add the issued value. Click a row to open the item's consumable-issue transactions for the same period.</p>

<p><b>When to use it.</b> Use to see which consumables were used most, to monitor consumable spend, and to review issues by reason, by issuer or by recipient.</p>

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

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

<ul>
<li><b>Store keeper</b> — Which consumables were issued the most this period? Review the Quantity column.</li>
<li><b>Cost controller</b> — What did consumable issues cost? Turn on <b>Show Value</b>.</li>
<li><b>Department head</b> — What was issued to a particular person? Filter by <b>Issued To</b>.</li>
<li><b>Auditor</b> — Why were items issued? Filter by <b>Inventory Adjustment Reason</b> and open a row for the documents.</li>
</ul>

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

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

<b>Date</b> range, <b>Inventory Adjustment Reason</b>, <b>Issued By</b> and <b>Issued To</b>. <b>Advanced Filter</b>: Item, Center, Branch, Variant, Brand, Item Group.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Item | Item name. Click to open its consumable-issue transactions. |
| Item Code | Item code. |
| Unit | Inventory keeping unit. |
| Quantity | Total quantity issued in the period. |
| Value | Value of the issues (shown when Show Value is on). |

<i>A Total row sums the quantity and, when shown, the value.</i>

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

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

<ul>
<li><b>Generate</b> — run the report for the selected filters</li>
<li><b>Show Value / Hide Value</b> — toggle the value column</li>
<li><b>Export</b> — export the report to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>clear</b> — reset active advanced filters</li>
</ul>

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

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

<p><b>How is this different from Consumable Issue Item Wise?</b><br>This report is an item summary — one total per item. <a href="#/inventory/reports/consumable-issue-item-wise">Consumable Issue Item Wise</a> lists every issue line with date, voucher, issued by/to and reason.</p>

<p><b>How do I see the issue value?</b><br>Turn on <b>Show Value</b> to add the value column and total.</p>

<p><b>Can I filter by who received the items?</b><br>Yes. Set the <b>Issued To</b> filter (and <b>Issued By</b> for who issued them).</p>

<p><b>How do I open the underlying documents?</b><br>Click an item row to open its <a href="#/inventory/reports/item-transactions">Item Transactions</a> for consumable issues in the period.</p>

<p><b>Why is my report empty?</b><br>No consumable issues were posted for items in the period, or filters exclude all rows.</p>

<p><b>Which consumable issue statuses are included?</b><br>Approved and closed issues only.</p>

<p><b>Why does the date range fail validation?</b><br>About 12 months maximum on item-wise consumable reports.</p>