# Item Group Wise Branch State Wise Work Order
Work orders summarized by item group, branch, and state — quantity and amount columns for each branch-state combination plus totals.
Overview
Go to Purchase → Order Reports → Item Group Wise Branch State Wise Work Order.
Report title in ERP: Item Group Wise Branch State Wise Work Order
What it shows. A matrix-style report with one row per item group, summarizing work order activity. Dynamic columns show quantity and amount for each branch and state combination, plus Others and Total columns.
When to use it. Use to analyze service procurement by item category across branches and regions — for maintenance spend tracking, regional service demand, and branch-level cost allocation.
How amounts are calculated. Aggregates approved work order item lines by item group, branch, and state on the work order address. Work orders without branch or state assignment appear under Others.
Use Cases
- Regional service spend — Compare service order volumes by item group across different states and branches.
- Maintenance budgeting — Track which item groups (e.g., repairs, AMC) consume the most budget per branch.
- Vendor allocation — Identify regions with high service demand to assign local suppliers or service partners.
- Executive summary — Export the matrix for management review of branch-wise service procurement patterns.
Filters
Date range, Item Group, Branch, State / Province, Supplier / Party, Center, Employee In charge. Advanced: Form Type, Project
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item Group | Category or group of service items on work orders. |
| [Branch – State] Qty | Quantity ordered for the item group in that branch and state. One column pair per combination. |
| [Branch – State] Amount | Work order amount for the item group in that branch and state. |
| Others Qty | Quantity for work orders not assigned to a specific branch-state combination. |
| Others Amount | Amount for uncategorized branch-state work orders. |
| Total Qty | Total quantity for the item group across all branches and states. |
| Total Amount | Total work order amount for the item group. |
> Column headers are generated dynamically based on branches and states present in the filtered data.
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
FAQ
How is this different from the Order version?
The Order report covers purchase orders for goods. This report covers work orders for services.
Are purchase orders included?
No. Only work order item lines are included in this report.
Why do some work orders appear under Others?
Work orders without a branch or state on the address, or outside the configured state list, are grouped under Others.
Does this show invoiced amounts?
No. Amounts reflect work order line totals, not purchase invoice values.
Why is my report empty?
No work orders match the date range, or branch/state and item group filters exclude all data.
Which work order statuses are included?
Approved and active work orders in the period.