# Material Request Item Wise
Line-level list of material request items for a selected period. Shows every request line with requested, ordered, pending and received quantities.
Overview
Go to Inventory → Inventory Reports → Material Request Item Wise.
What it shows. One row per material request item line in the selected period, with the request date, system ID, type, center, employee, item details and four quantity columns — Qty requested, Ordered Qty, Pending Order Qty and Received Qty. Select one or more rows to raise a Purchase Order, Purchase Invoice or Purchase Quotation for the pending balance. Click an ID to open the material request.
When to use it. Use to track each request line against what has been ordered and received, to find pending balances to act on, and to open the source requests.
Use Cases
- Purchaser — Which request lines still have a pending order quantity? Review Pending Order Qty and raise a purchase document.
- Store keeper — How much of a request has been received so far? Compare Qty with Received Qty.
- Branch in-charge — What was requested at my center? Filter by Center.
- Auditor — Which voucher raised a particular request line? Click the ID to open it.
Filters
Date range, Employee 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: Center, Item Group, Brand, Item.
Columns
| **Column** | **Description** |
|------------|-----------------|
| (select) | Checkbox to select the line for a follow-up action. |
| Date | Material request date. |
| ID | System reference of the material request. Click to open it. |
| Type | Purpose of the material request. |
| Center | Inventory center for the request. |
| Employee | Employee who raised the request. |
| Item Name | Item requested. |
| Item Code | Item code. |
| HSN Code | Item HSN code. |
| Unit | Inventory keeping unit. |
| Qty | Quantity requested on this line. |
| Ordered Qty | Quantity already ordered against the request. |
| Pending Order Qty | Quantity still to be ordered. |
| Received Qty | Quantity received against the request. |
A Total row sums the quantity, ordered, pending and received columns.
Actions
- Generate — run the report for the selected filters
- Create Purchase Order — select rows, then raise a purchase order for the pending balance
- Create Purchase Invoice — select rows, then raise a purchase invoice
- Create Purchase Quotation — select rows, then raise a purchase quotation
- 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 Item Wise Material Request Report?
This report is line-level: one row per request line with ordered, pending and received quantities. Item Wise Material Request Report is an item summary with one total quantity per item.
What is Pending Order Qty?
It is the requested quantity that has not yet been ordered (requested minus ordered).
How do I raise a purchase document for the balance?
Select the request lines and use Create Purchase Order, Create Purchase Invoice or Create Purchase Quotation. The pending balance is carried into the new document.
How do I open the material request?
Click the ID on any row to open the material request.
Which material request statuses are included?
Approved and in-progress requests with open pending quantities, per report filters.
Why is my report empty?
All request lines are fully ordered and received, or status and date filters exclude all rows.
Why does the date range fail validation?
About 12 months maximum on material request reports.