# Item Wise Sale Order Report

<p class="doc-lead">Sale order quantity and sale amount before tax rolled up by item. Select rows to create a Purchase Order, Purchase Invoice, Material Request, or Production Plan.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/sales/reports/item-wise-sale-order?id=overview">Overview</a>
<a href="#/sales/reports/item-wise-sale-order?id=use-cases">Use Cases</a>
<a href="#/sales/reports/item-wise-sale-order?id=filters">Filters</a>
<a href="#/sales/reports/item-wise-sale-order?id=layout">Layout &amp; columns</a>
<a href="#/sales/reports/item-wise-sale-order?id=actions">Actions</a>
<a href="#/sales/reports/item-wise-sale-order?id=faq">FAQ</a>
</div>
</div>

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

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

Go to <b>Sales → Order Reports → Item Wise Sale Orders</b>.

Report title in ERP: <b>Item Wise Sale Order Report</b>

<p><b>What it shows.</b> One row per item with total <b>Quantity</b> ordered, unit, and — when <b>Show Value</b> is on — <b>Amount</b> and <b>Avg Unit Amt</b>. Click an item to open <a href="#/sales/reports/order-wise-item-order">Order Wise Item Order</a> for that item.</p>

<p><b>When to use it.</b> Demand planning, average-price checks, and creating follow-on purchase, material request, or production documents from selected items.</p>

<p><b>How amounts are calculated.</b> Adds up sale order item lines by item for the date range. <b>Status-All</b> (default) includes approved, delivered, closed, returned, and related active orders — not cancelled. <b>Quantity</b> is the sum of net quantity. <b>Amount</b> is the sum of sale amount before tax. <b>Avg Unit Amt</b> is Amount ÷ Quantity. <b>Delivered</b> uses delivered quantities from delivery notes. <b>Not Delivered</b> is ordered minus delivered. <b>Cancelled</b> shows cancelled orders only. Respects your employee access in the Sale module.</p>

<img src="sales/images/item-wise-sale-order.webp" alt="Item Wise Sale Order Report with quantity, amount, and average unit amount" loading="lazy">

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

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

<ul>
<li><b>Demand planning</b> — See which items have the highest ordered quantity for stock preparation.</li>
<li><b>Price benchmarking</b> — Turn on <b>Show Value</b> and compare <b>Avg Unit Amt</b> across periods.</li>
<li><b>Category review</b> — Use <b>Item Group</b> or <b>Brand</b> in Advanced Filter.</li>
<li><b>Buy or make</b> — Select items and create a Purchase Order, Purchase Invoice, Material Request, or <a href="#/production/production-plan">Production Plan</a>.</li>
</ul>

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

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

<p><b>Header (quick filters)</b></p>

<ul>
<li><b>Date</b> — date range for sale order date. Defaults to today.</li>
<li><b>Status</b> — <b>Status-All</b> (default), <b>Delivered</b>, <b>Not Delivered</b>, <b>Not Cancelled</b>, or <b>Cancelled</b>.</li>
<li><b>Employee</b> — limits results to orders for the selected employee. Respects your employee access in the Sale module.</li>
<li><b>All Items</b> / <b>Service Items</b> / <b>Inventory Items</b> — item type.</li>
<li><b>Show Value</b> / <b>Hide Value</b> — show or hide Amount and Avg Unit Amt. Value is on by default.</li>
</ul>

<p><b>Advanced Filter</b> (filter icon) — additional fields:</p>

<ul>
<li><b>Customer</b></li>
<li><b>Customer Group</b></li>
<li><b>Form Type</b> — sale type on the invoice</li>
<li><b>State / Province</b></li>
<li><b>Zone</b> *(when zone access is enabled)*</li>
<li><b>Branch</b> *(when multiple branch is enabled)*</li>
<li><b>Item Group</b></li>
<li><b>Route</b> *(when route access is enabled)*</li>
<li><b>Brand</b> *(when brand access is enabled)*</li>
</ul>

<p>Tap <b>Clear</b> after applying Advanced Filter to reset advanced filters.</p>

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

<h2 id="layout">Layout &amp; columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| (checkbox) | Select the row for create-document actions. |
| Item | Item name. Click to open Order Wise Item Order for that item. |
| Item Code | Item code. Click to open the same detail. |
| Quantity | Total net quantity ordered (or delivered / not-delivered quantity when those Status options are selected). |
| Unit | Item unit short form. |
| Amount | Sale amount before tax. Shown when <b>Show Value</b> is on. |
| Avg Unit Amt | Amount ÷ Quantity. Shown when <b>Show Value</b> is on. |
| Footer Total | Quantity and Amount totals. |

<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>Show Value</b> / <b>Hide Value</b> — toggle Amount and Avg Unit Amt</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>Clear</b> — reset active advanced filters</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (company header and date range are included)</li>
</ul>

<p>Select one or more rows to show the selection action bar (buttons appear only if you have create access):</p>

<ul>
<li><b>Create Purchase Order</b> — opens a new Purchase Order with the selected items and quantities</li>
<li><b>Create Purchase Invoice</b> — opens a new Purchase Invoice with the selected items and quantities</li>
<li><b>Create Material Request</b> — opens a new Material Request with the selected items and quantities</li>
<li><b>Create Production Plan</b> — opens a new <a href="#/production/production-plan">Production Plan</a> with selected producible items, quantities, and each item's default active BOM</li>
</ul>

<p><b>Create Production Plan</b> skips items that are not producible. If none of the selected items are producible, a warning is shown.</p>

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

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

<p><b>How is average unit amount calculated?</b><br>Amount (taxable) divided by Quantity for the selected filters.</p>

<p><b>What does Status-All include?</b><br>Approved, delivered, closed, returned, and related active orders. Cancelled orders are excluded. Use <b>Cancelled</b> to see cancelled orders only, or <b>Not Cancelled</b> for the same active set as Status-All.</p>

<p><b>Does Delivered show order quantity or delivered quantity?</b><br>Delivered uses quantity from delivery notes. Not Delivered is ordered minus delivered.</p>

<p><b>Are draft orders included?</b><br>No. Draft orders are not in any Status option on this report.</p>

<p><b>How is this different from Order Wise Item Order?</b><br><a href="#/sales/reports/order-wise-item-order">Order Wise Item Order</a> shows one line per order item. This report groups quantity and amount by item across orders.</p>

<p><b>How do I create a Production Plan from this report?</b><br>Select the items → <b>Create Production Plan</b>. The plan opens with plan name, start date, item lines, quantities, and default BOMs filled. Complete center and end date, then save.</p>

<p><b>What BOM is used when creating a Production Plan?</b><br>The first active BOM for each item is applied automatically. Change it on the plan form if the item has more than one BOM.</p>

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

<h2 id="related">Related</h2>

<ul>
<li><a href="#/sales/reports/order-wise-item-order">Order Wise Item Order</a></li>
<li><a href="#/sales/sale-order">Sale Order</a></li>
<li><a href="#/production/production-plan">Production Plan</a></li>
</ul>
