# Item Group Wise Branch State Wise Order
Purchase 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 Order.
Report title in ERP: Item Group Wise Branch State Wise Order
What it shows. A matrix-style report with one row per item group. Dynamic columns show quantity and amount for each branch and state combination, plus Others and Total columns for uncategorized or overall figures.
When to use it. Use to compare procurement across branches and regions at the item group level — for regional demand analysis, branch-wise budgeting, and supply chain planning.
How amounts are calculated. Aggregates approved purchase order item lines by item group, branch, and the state on the order's billing or shipping address. Orders without a state assignment appear under Others.
Use Cases
- Regional demand analysis — Identify which states drive the highest order volume for each item group.
- Branch comparison — Compare procurement spend across branches for the same item category.
- Procurement planning — Use state-level totals to plan supplier contracts or warehouse allocation by region.
- Management reporting — Export the matrix for quarterly reviews of category-wise spending by branch and geography.
Filters
Date range, Item Group, Branch, State / Province, Supplier, Center, Employee In charge. Advanced: Form Type, Brand
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item Group | Category or group of ordered items. |
| [Branch – State] Qty | Quantity ordered for the item group in that branch and state. One column pair per combination. |
| [Branch – State] Amount | Purchase amount for the item group in that branch and state. |
| Others Qty | Quantity for orders not assigned to a specific branch-state combination. |
| Others Amount | Amount for uncategorized branch-state orders. |
| Total Qty | Total quantity for the item group across all branches and states. |
| Total Amount | Total purchase 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 Item Group Wise State Wise Order?
The State Wise Order report groups by state only. This report adds a branch dimension, splitting each state by branch.
Why do some orders appear under Others?
Orders without a branch or state on the billing/shipping address, or outside the configured state list, are grouped under Others.
Are cancelled orders included?
No. Only approved and active purchase orders are included unless the status filter specifies otherwise.
Does this include received or invoiced quantities?
No. This report reflects ordered quantities and amounts on purchase orders, not receipt or invoice status.
Why is my report empty?
No purchase orders match the date range, or branch/state filters exclude all rows.
Which purchase order statuses are included?
Approved and active orders. Use export to analyse closed or received orders if your filter allows them.