# Order Wise Item Wise Delivery

<p class="doc-lead">Delivery detail for sale order item lines — ordered vs delivered quantity, delivery dates, and pending quantities per order line.</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=columns">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> Each sale order item line with ordered quantity, delivered quantity, pending quantity, delivery note references, and delivery dates.</p>

<p><b>When to use it.</b> Use to track order fulfillment progress, identify undelivered lines, and reconcile deliveries against orders before invoicing.</p>

<p><b>How amounts are calculated.</b> Compares ordered quantities on sale orders against quantities on linked delivery notes within the selected filters.</p>

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

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

<ul>
<li><b>Warehouse dispatch</b> — Identify order lines awaiting delivery before invoicing.</li>
<li><b>Partial delivery review</b> — Track which lines are partially delivered and what remains pending.</li>
<li><b>Customer follow-up</b> — Confirm delivery status before billing or customer inquiries.</li>
<li><b>Delivered not invoiced</b> — Cross-check with <a href="#/sales/reports/delivered-not-invoiced">Delivered Not Invoiced</a> for billing gaps.</li>
</ul>

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

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

<b>Date Range</b>, <b>Customer</b>, <b>Order No.</b>, <b>Item</b>. <b>Advanced Filter</b>: Delivery Status, Employee, Route, Branch, Center.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Order Date | Sale order date. |
| Order No. | Sale order number. |
| Customer | Customer name. |
| Item Name | Ordered item. |
| Order Qty | Quantity ordered. |
| Delivered Qty | Quantity delivered via delivery notes. |
| Pending Qty | Order Qty minus Delivered Qty. |
| Unit | Unit of measure. |
| Delivery Note No. | Reference to the delivery note. |
| Delivery Date | Date goods were delivered. |
| Status | Pending / Partial / Delivered. |

<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> / <b>Export All</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Advanced Filter</b> — open additional filter fields</li>
<li><b>clear</b> — reset active filters</li>
<li><b>Delivery Note No.</b> link — open the delivery note</li>
</ul>

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

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

<p><b>How is pending quantity calculated?</b><br>Ordered quantity minus total delivered quantity on linked delivery notes.</p>
<p><b>Does this include direct invoicing without delivery notes?</b><br>Lines invoiced without a delivery note may show as pending delivery depending on workflow.</p>
<p><b>Can I filter undelivered lines only?</b><br>Yes. Use <b>Delivery Status</b> set to Pending or Partial.</p>
<p><b>How does this relate to Delivered Not Invoiced?</b><br>This report tracks delivery progress. Delivered Not Invoiced shows delivered orders without invoices.</p>
<p><b>What if delivered exceeds ordered?</b><br>Should not happen when <b>Prevent over delivery</b> is on. Investigate data entry or bypass approvals.</p>

<p><b>When should warehouse use this?</b><br>Daily pick-pack review before creating delivery notes for remaining quantities.</p>
<hr class="doc-section-divider">

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

<ul>
<li><a href="#/sales/reports/delivered-not-invoiced">Delivered Not Invoiced</a></li>
<li><a href="#/sales/reports/order-wise-item-order">Order Wise Item Orders</a></li>
</ul>