# Item Wise Material Request Report

<p class="doc-lead">Total requested quantity for each item across material requests in a selected period. Summarises demand by item so you can plan purchase or production from it.</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-material-request?id=overview">Overview</a>
<a href="#/inventory/reports/item-wise-material-request?id=use-cases">Use Cases</a>
<a href="#/inventory/reports/item-wise-material-request?id=filters">Filters</a>
<a href="#/inventory/reports/item-wise-material-request?id=columns">Columns</a>
<a href="#/inventory/reports/item-wise-material-request?id=actions">Actions</a>
<a href="#/inventory/reports/item-wise-material-request?id=faq">FAQ</a>
</div>
</div>

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

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

Go to <b>Inventory → Inventory Reports → Item Wise Material Request Report</b>.

<p><b>What it shows.</b> One row per item with the total <b>Quantity</b> requested across material requests in the selected period, along with the item group and unit. Each row has a checkbox for selecting items. Use the <b>Type</b> filter to limit it to a particular material-request purpose.</p>

<p><b>When to use it.</b> Use to consolidate material demand by item and to plan procurement or production from the requested quantities.</p>

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

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

<ul>
<li><b>Purchaser</b> — How much of each item has been requested? Review the Quantity column to plan procurement.</li>
<li><b>Production planner</b> — What producible items are in demand? Filter by type and review the requested quantities.</li>
<li><b>Store keeper</b> — Which items are being requested most? Review the Quantity column.</li>
<li><b>Branch in-charge</b> — What is requested at my center? Filter by <b>Center</b>.</li>
</ul>

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

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

<b>Date</b> range and a <b>Type</b> selector (Type-All, Purchase Order, Inventory Transfer, Issue For Production, Sale Order, Rework, Production Order, Consumable Issue, Off Load, Return Off Load, Custom). <b>Advanced Filter</b>: Item, Item Type, Center, Variant, Brand, Item Group, Route.

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

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

| **Column** | **Description** |
|------------|-----------------|
| (select) | Checkbox to select the item for a follow-up action. |
| Item Code | Item code. Click to open item enquiry. |
| Item | Item name. Click to open item enquiry. |
| Item Group | Item group of the item. |
| Unit | Inventory keeping unit. |
| Quantity | Total quantity requested in the period. |

<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>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>
<li><b>Selection action bar</b> — tick one or more rows to reveal follow-up actions (shown based on your permissions): <b>Create Purchase Order</b>, <b>Create Purchase Invoice</b>, <b>Create Production Order</b>, and <b>Create Inventory Conversion</b> for the selected items</li>
</ul>

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

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

<p><b>How is this different from Material Request Item Wise?</b><br>This report is an item summary — one total quantity per item. <a href="#/inventory/reports/material-request-item-wise">Material Request Item Wise</a> lists each request line with the voucher, ordered, pending and received quantities.</p>

<p><b>Can I raise a purchase order or production order from here?</b><br>Yes. Tick the items you need, then use the action bar that appears to <b>Create Purchase Order</b>, <b>Create Purchase Invoice</b>, <b>Create Production Order</b>, or <b>Create Inventory Conversion</b>. The available buttons depend on your access rights.</p>

<p><b>Can I limit it to one request purpose?</b><br>Yes. Use the <b>Type</b> selector (for example Purchase Order or Issue For Production).</p>

<p><b>Why is my report empty?</b><br>No open material request quantities match the period and type filters.</p>

<p><b>What is the difference from the Material Request document?</b><br>This report aggregates requested quantity by item across many requests; the Material Request document is a single request record.</p>

<p><b>Which request types appear?</b><br>Filter by Purchase Order, Issue For Production, Sale Order, and other <b>Request For</b> types configured in <a href="#/inventory/inventory-settings">Inventory Settings</a>.</p>
