# Item Wise Work Orders
Summarizes work order activity by item, showing total issued quantity, cost, and average unit amount. Use it to track material usage in production and analyze item-level work order costs.
Overview
Go to Purchase → Order Reports → Item Wise Work Orders.
What it shows. One row per item with total quantity issued through work orders, unit, total cost, and average unit amount.
When to use it. Monitor raw material and component consumption in production, identify high-usage items, and support cost control and inventory planning for manufacturing or service operations.
Use Cases
- Production cost review — Identify items with the highest work order consumption and cost impact.
- Batch analysis — Filter by work order or batch to compare material usage across production runs.
- Branch comparison — Use branch or center filters to compare item usage across locations.
- Inventory replenishment — Plan stock for items with consistently high work order draw-down.
Filters
- Date Range — Limit work orders to a specific period.
- Item / Item Code — Focus on one or more items.
- Work Order / Batch — Filter by specific work orders or production batches.
- Branch / Center — Restrict to a branch or production unit.
Columns
| **Column** | **Description** |
|------------|-----------------|
| **Item** | Name or description of the item used in work orders. |
| **Item Code** | Unique code or SKU of the item. |
| **Quantity** | Total quantity issued in work orders. |
| **Unit** | Measurement unit (NOS, KG, PCS, etc.). |
| **Amount** | Total cost associated with the issued quantity. |
| **Avg Unit Amt** | Average cost per unit (Amount ÷ Quantity). |
Actions
- View Details — Drill down to individual work orders for the item.
- Export — Download to Excel or PDF for production or cost analysis.
- Filter & Sort — Refine by item, batch, work order, or date.
FAQ
How is this different from Item Wise Purchase Orders?
Purchase orders track items ordered from suppliers. Work orders track items consumed or issued in production or service jobs.
Does amount include tax?
Amount reflects the cost recorded on work order lines based on system pricing rules for the selected period.
Can I trace a specific batch?
Yes. Use the Work Order / Batch filter to limit results to a specific production batch or work order.
Why is average unit amount zero for some items?
This can occur when quantity is recorded but cost is zero, or when rounding produces a negligible average. Verify underlying work order lines.
Which work order statuses are included?
Approved and active work orders in the period. Cancelled work orders are typically excluded.
Why is my report empty?
No work order lines match the date range or item, supplier, and branch filters.
Are purchase orders included?
No. Use Item Wise Purchase Order for goods orders.