# Order Wise Item Wise Delivery

<p class="doc-lead">Order-line delivery progress — ordered, delivered, and balance quantity per sale order item. Select lines to create a Purchase Order, Purchase Invoice, or Material Request.</p>

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

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

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

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

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

<p><b>What it shows.</b> One row per sale order item with <b>Sale Order</b>, <b>Order Date</b>, <b>Due Date</b>, customer, item, <b>Item Code</b>, unit, <b>Ordered</b>, <b>Delivered</b>, and <b>Balance</b>.</p>

<p><b>When to use it.</b> Warehouse and planning review of what remains to deliver. Select open lines to raise a purchase or material request for the balance.</p>

<p><b>How amounts are calculated.</b> <b>Ordered</b> is net quantity on the sale order line. <b>Delivered</b> is quantity on approved delivery notes, minus quantity on linked receipt notes (returns). <b>Balance</b> = Ordered − Delivered. Negative balance rows are highlighted; hide them with <b>More → Hide negative balance</b>. Default <b>Open Orders</b> limits the list to Approved and Partially Delivered orders. There is no Advanced Filter on this report.</p>

<img src="sales/images/order-wise-item-wise-delivery.webp" alt="Order Wise Item Wise Delivery report with delivered quantities per order line" loading="lazy">

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

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

<ul>
<li><b>Warehouse dispatch</b> — Run <b>Open Orders</b> and pick lines with a remaining <b>Balance</b>.</li>
<li><b>Buy for outstanding orders</b> — Select lines and <b>Create Purchase Order</b> or <b>Create Purchase Invoice</b> for the balance quantity.</li>
<li><b>Internal transfer</b> — <b>Create Material Request</b> when another center holds the stock.</li>
<li><b>Billing cross-check</b> — Pair with <a href="#/sales/reports/delivered-not-invoiced">Delivered And Not Invoice Orders</a> after delivery.</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>Open Orders</b> / <b>All Orders</b> — Open Orders (default) is Approved and Partially Delivered. All Orders includes delivered, closed, returned, and cancelled orders in the range.</li>
<li><b>Employee</b> — limits results to orders for the selected employee. Respects your employee access in the Sale module.</li>
<li><b>Select Orders</b> — opens a list of sale orders in the current result so you can tick rows for the selection action bar.</li>
</ul>

<p>This report does not have Advanced Filter.</p>

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

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

| **Column** | **Description** |
|------------|-----------------|
| (checkbox) | Select the row for Create Purchase Order / Purchase Invoice / Material Request. |
| Sale Order | Sale order number. Click to open the order. |
| Order Date | Sale order date. |
| Due Date | Order due date. |
| Customer | Customer on the order. |
| Item Name | Ordered item. |
| Item Code | Item code. |
| UOM | Item unit short form. |
| Ordered | Net quantity on the sale order line. |
| Delivered | Approved delivery-note quantity minus linked returns. |
| Balance | Ordered minus Delivered. Negative rows are highlighted. |

<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>Select Orders</b> — pick sale orders from the current result to select their lines</li>
<li><b>More</b> — <b>Show negative balance</b> or <b>Hide negative balance</b></li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (company header and date range are included)</li>
<li><b>Sale Order</b> — open the sale order</li>
</ul>

<p>Select one or more rows (or use <b>Select Orders</b>) to show the selection action bar:</p>

<ul>
<li><b>Create Purchase Order</b> — opens a new Purchase Order with the selected items and balance quantities *(when you have Purchase Order create access)*</li>
<li><b>Create Purchase Invoice</b> — opens a new Purchase Invoice with the selected items and quantities *(when you have Purchase Invoice create access)*</li>
<li><b>Create Material Request</b> — opens a new Material Request with the selected items and quantities *(when you have Material Request create access)*</li>
</ul>

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

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

<p><b>How is Balance calculated?</b><br>Ordered minus Delivered. Delivered is approved delivery-note quantity minus linked receipt-note (return) quantity.</p>

<p><b>Why is there no Advanced Filter?</b><br>Customer, item, and similar filters are not on this screen. Use Date, Open Orders / All Orders, Employee, and Select Orders.</p>

<p><b>What does Open Orders include?</b><br>Approved and Partially Delivered sale orders. Switch to <b>All Orders</b> to include delivered, closed, returned, and cancelled orders.</p>

<p><b>Why is a balance negative?</b><br>Delivered (after returns) exceeded ordered. Use <b>More → Hide negative balance</b> to hide those rows, then investigate over-delivery.</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> is line-level order detail with rates and status. This report is delivery quantity vs ordered, with create-document actions for the balance.</p>

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

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

<ul>
<li><a href="#/sales/reports/delivered-not-invoiced">Delivered And Not Invoice Orders</a></li>
<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>
</ul>
