# Order Wise Raw Materials
Raw material requirements vs requested, received, and stock availability per Production Order. Rows are color-coded by fulfillment status. Select orders and create Material Requests in bulk.
Overview
Go to Production → Reports → Order Wise Raw Material.
What it shows. For each production order and raw material line, required quantity vs requested quantity, received quantity, and current stock. Use Select Orders to pick specific orders before generating.
When to use it. Use before issuing materials — identify shortages, raise material requests, and confirm stock availability per order.
Use Cases
- Store keeper — See which raw materials are short before creating Issue For Production.
- Planner — Select multiple orders and raise a Material Request for all shortages at once.
- Buyer — Filter by Raw Item Type to focus on specific material categories.
Filters
Quick filters: Date range, Employee, Select Orders.
Advanced Filter: Item, Center, Batch, Item Group, Variant, Branch, Brand, Machine, Production Order Id, Raw Item Type.
Columns
| **Column** | **Description** |
|------------|-----------------|
| *(checkbox)* | Select row for Material Request. |
| Order | Production Order. Click to open. |
| Date | Order date. |
| Due Date | Order due date. |
| Item | Finished item on the order. |
| Quantity | Order quantity. |
| UOM | Finished item unit. |
| Raw Item Name | Raw material required. |
| Type | Raw item type. |
| UOM | Raw material unit. |
| Required Qty | Quantity required per BOM. |
| Requested Qty | Quantity already requested. |
| Received Qty | Quantity already issued/received. |
| Stock | Current stock available. |
Actions
- Generate — run the report
- Select Orders — pick specific Production Orders to include
- Create Material Request — create a Material Request for selected rows *(requires Material Request create access)*
- Export — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
What do the row colors mean?
Rows are color-coded by fulfillment status — fully received, partially received, or not yet requested.
Can I create one Material Request for multiple orders?
Yes — select the required rows and click Create Material Request.
Need plan-level material demand?
Use Plan Wise Raw Materials for consolidated requirements from Production Plans.
Per order materials?
Raw material requirement and issue status per production order.
Shortage?
Compare to stock before issue for production.
Can I export this report?
Yes — use Export from report actions for Excel analysis.
Which production setting affects this?
Review Production Settings for variance, quantity, and BOM rules.