# Item Wise Purchase Orders
Aggregates purchase order activity by item, showing total ordered quantity, amount, and average unit cost. Use it for item-level procurement analysis, cost trends, and high-volume purchasing decisions.
Overview
Go to Purchase → Order Reports → Item Wise Purchase Orders.
What it shows. One row per item with total quantity ordered across purchase orders, unit of measure, total purchase amount, and average unit amount.
When to use it. Identify high-volume or high-value items, compare average costs across periods, and support inventory and budget planning at the SKU level.
Use Cases
- Inventory planning — See which items have the highest order volumes to align stock levels and reorder points.
- Cost benchmarking — Compare average unit amounts across date ranges to spot rising input costs.
- Category review — Combine with supplier or branch filters to analyze item ordering patterns by location or vendor.
- Budget allocation — Export item totals to allocate procurement spend across product lines.
Filters
- Date Range — Limit orders to a specific period.
- Item / Item Code — Focus on one or more items.
- Supplier — View items ordered from selected suppliers.
- Branch / Center — Restrict to a branch or business unit.
Columns
| **Column** | **Description** |
|------------|-----------------|
| **Item** | Name or description of the purchased item. |
| **Item Code** | Unique code or SKU of the item. |
| **Quantity** | Total quantity ordered across purchase orders. |
| **Unit** | Measurement unit (NOS, KG, PCS, etc.). |
| **Amount** | Total purchase amount for the item. |
| **Avg Unit Amt** | Average cost per unit (Amount ÷ Quantity). |
Actions
- View Details — Drill down to individual purchase orders for the item.
- Export — Download to Excel or PDF for analysis or inventory review.
- Filter & Sort — Refine by item, supplier, date, or branch.
FAQ
How is average unit amount calculated?
It is total amount divided by total quantity for the selected filters. Mixed units on the same item code may affect the average if units differ across orders.
Does this include work orders?
No. This report covers purchase orders only. Use Item Wise Work Orders for work order item analysis.
Are cancelled or closed orders included?
Only active order lines within the selected date range and filters are aggregated. Check filter settings if totals seem unexpected.
Can I see which suppliers ordered an item?
Apply the supplier filter, or drill down from a row to view underlying purchase orders with supplier details.
Which purchase order statuses are included?
Approved and active order lines in the period. Cancelled orders are typically excluded.
Why is my report empty?
The item had no purchase order activity in the date range, or filters exclude its supplier, branch, or group.
Does this include draft purchase orders?
No. Only confirmed order lines matching the report status scope are aggregated.