# Item Wise Material Request Report

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.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Inventory → Inventory Reports → Item Wise Material Request Report.

What it shows. One row per item with the total Quantity requested across material requests in the selected period, along with the item group and unit. Use the Type filter to limit it to a particular material-request purpose. Select one or more rows to create a Purchase Order, Purchase Invoice, Production Order, or Inventory Conversion directly from the demand.

When to use it. Use to consolidate material demand by item, to plan procurement or production, and to raise the next document straight from the requested quantities.

Use Cases

Purchaser — How much of each item has been requested? Select rows and create a purchase order or invoice.
Production planner — What producible items are in demand? Filter by type and create a production order.
Store keeper — Which items are being requested most? Review the Quantity column.
Branch in-charge — What is requested at my center? Filter by Center.

Filters

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

Columns

| **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. |

Actions

Generate — run the report for the selected filters
Create Purchase Order — select rows, then raise a purchase order from the requested items
Create Purchase Invoice — select rows, then raise a purchase invoice
Create Production Order — select rows, then raise a production order
Create Inventory Conversion — select rows, then open the Multi Inventory Conversion popup pre-seeded with the selected items to create one BOM-based conversion per item
Export — export the report to Excel
Print — print the report
Advanced Filter — open additional filter fields
clear — reset active advanced filters

FAQ

How is this different from Material Request Item Wise?
This report is an item summary — one total quantity per item. Material Request Item Wise lists each request line with the voucher, ordered, pending and received quantities.

Can I raise a purchase or production document from here?
Yes. Select the item rows and use Create Purchase Order, Create Purchase Invoice, Create Production Order, or Create Inventory Conversion.

How does Create Inventory Conversion work?
Select the item rows and click Create Inventory Conversion. A popup opens pre-filled with the selected items and quantities; pick a BOM for each and save to create one Multi Inventory Conversion per item.

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

Why is the create-button list different for me?
The available create actions depend on your access to purchase and production documents.

Why is my report empty?
No open material request quantities match the period and type filters.

What is the difference from Material Request document?
This report aggregates pending request qty by item; fulfil requests via PO, transfer, or consumable issue from selected rows.

Which request types appear?
Filter by Purchase Order, Issue For Production, Sale Order, and other Request For types configured in Inventory Settings.