# Item Group Wise State Wise Order

<p class="doc-lead">Cross-tab of purchase order quantities and amounts by item group and delivery or billing state. Use it to analyze regional demand patterns and category-wise procurement across locations.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=overview">Overview</a>
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=use-cases">Use Cases</a>
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=filters">Filters</a>
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=columns">Columns</a>
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=actions">Actions</a>
<a href="#/purchase/reports/item-group-wise-state-wise-order?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Purchase → Order Reports → Item Group Wise State Wise Order</b>.

<p><b>What it shows.</b> One row per item group, with a Quantity and Amount column for each state, plus a <b>Total</b> Quantity and Amount for the group. A totals row sums each state and the grand total.</p>

<p><b>When to use it.</b> Compare regional ordering patterns, plan state-level inventory, and identify which item groups drive spend in specific geographies.</p>

<img src="purchase/images/item-group-wise-state-wise-order.webp" alt="Item Group Wise State Wise Order report with quantity and amount by item group and state" loading="lazy">

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Regional demand planning</b> — See which states order the most of each item group to align warehouse and distribution.</li>
<li><b>Category spend by geography</b> — Compare total amounts across states for a single item group.</li>
<li><b>Sourcing strategy</b> — Identify high-volume item-group/state combinations to negotiate regional supplier contracts.</li>
<li><b>Management reporting</b> — Export the matrix for presentations on regional procurement trends.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<ul>
<li><b>Date Range</b> — Limit orders to a specific period.</li>
<li><b>Advanced Filter</b> — Supplier, Center, Form Type (purchase type), and Branch.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| **Item Group** | Category or group of ordered items (one row each). |
| **[State] Quantity** | Order quantity for the item group in that state. One column per state. |
| **[State] Amount** | Order amount for the item group in that state. One column per state. |
| **Total Quantity** | Total quantity for the item group across all states. |
| **Total Amount** | Total order amount for the item group across all states. |

<p><em>Note:</em> State columns are generated dynamically from the states present in the filtered data. A totals row at the bottom sums each state column and the grand total.</p>

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected filters</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Advanced Filter</b> — open additional filter fields; <b>clear</b> resets active filters</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<b>What determines the state on an order?</b><br>
State is taken from the billing or shipping address on the purchase order, depending on system configuration.

<b>Are quantity and amount shown separately per state?</b><br>
Yes. Each state has its own Quantity and Amount column for the item group.

<b>Can I compare two item groups side by side?</b><br>
Each row is one item group. Export to Excel to build custom comparisons across groups or periods.

<b>Which purchase order statuses are included?</b><br>
Approved and active purchase orders in the period. Cancelled orders are excluded.

<b>How is this different from the branch-state version?</b><br>
This report summarises by state. <a href="#/purchase/reports/item-group-wise-branch-state-wise-order">Item Group Wise Branch State Wise Order</a> adds the branch dimension.

<b>Why is my report empty?</b><br>
No purchase orders match the date range or advanced filters.
