# Order Wise Item Order

<p class="doc-lead">Line-level detail of every item on sale orders — ordered, delivered, and balance quantities, rates, taxes, and fulfillment status per order.</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-order?id=overview">Overview</a>
<a href="#/sales/reports/order-wise-item-order?id=use-cases">Use Cases</a>
<a href="#/sales/reports/order-wise-item-order?id=filters">Filters</a>
<a href="#/sales/reports/order-wise-item-order?id=layout">Layout &amp; columns</a>
<a href="#/sales/reports/order-wise-item-order?id=actions">Actions</a>
<a href="#/sales/reports/order-wise-item-order?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 Orders</b>.

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

<p><b>What it shows.</b> Each row is one item line on a sale order, with order date, customer, order number, item attributes, ordered quantity, delivered quantity, balance quantity, and line status. Turn on <b>Show Description</b> to add the line description. Turn on <b>Show Value</b> for rate, sale amount before tax, tax, and total.</p>

<p><b>When to use it.</b> Audit item-level order commitments, check pending or partially delivered lines, and analyse orders by item group or brand.</p>

<p><b>How quantities are calculated.</b> <b>Order Qty</b> is the quantity on the sale order line. <b>Delivered Qty</b> is net quantity delivered against that order item (approved delivery notes minus linked receipt notes), plus service completion notes for service items. <b>Balance Qty</b> is Order Qty minus Delivered Qty.</p>

<p><b>How amounts are calculated.</b> When <b>Show Value</b> is on (default), <b>Rate</b> is the line price, <b>Taxable Value</b> is the line sale amount before tax, <b>Tax Amount</b> is tax on the line, and <b>Total</b> is the line total including tax. Footer totals exclude cancelled lines.</p>

<img src="sales/images/order-wise-item-order.webp" alt="Order Wise Item Order report with ordered, delivered, and balance quantities" loading="lazy">

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

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

<ul>
<li><b>Line-level fulfillment</b> — Compare Order Qty, Delivered Qty, and Balance Qty to find lines still pending or partially delivered.</li>
<li><b>HSN and tax review</b> — Verify HSN codes and tax amounts on ordered items.</li>
<li><b>Brand or category analysis</b> — Filter by <b>Item Group</b> or <b>Item</b> in Advanced Filter.</li>
<li><b>Rate verification</b> — Compare ordered rates against customer pricing before invoicing.</li>
<li><b>Not purchased</b> — Use Status <b>Not Purchased</b> to see lines not yet on a purchase order, with stock columns when inventory access is enabled.</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). Status filters apply at <b>item line</b> level using delivered and balance quantities, not only the order header:
  <ul>
  <li><b>Delivered</b> — lines with Delivered Qty greater than zero</li>
  <li><b>Returned</b> — lines with returned quantity</li>
  <li><b>Approved</b> — lines not yet delivered</li>
  <li><b>Partial Delivered</b> — some delivered, balance remaining</li>
  <li><b>Not Cancelled</b> / <b>Cancelled</b> / <b>Status-All</b> — include or exclude cancelled orders as selected</li>
  <li><b>Not Purchased</b> — lines not yet linked to a purchase order (shows stock columns when inventory access is enabled)</li>
  </ul>
</li>
<li><b>Employee</b> — limits results to orders for the selected employee. Respects your employee access in the Sale module.</li>
<li><b>Sort by</b> — <b>Date</b> or <b>Due Date</b>.</li>
<li><b>Show Value</b> / <b>Hide Value</b> — show or hide Rate, Taxable Value, Tax Amount, and Total. Value is on by default.</li>
<li><b>Show Description</b> / <b>Hide Description</b> — show or hide the line description column.</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>Route</b> *(when route access is enabled)*</li>
<li><b>Form Type</b> — sale type on the invoice</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>Item</b></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** |
|------------|-----------------|
| Order Date | Date of the sale order. |
| Party | Customer on the order. |
| Order No. | Sale order number. Click to open the order. |
| Due Date | Expected delivery date. |
| Item | Ordered item name. |
| Description | Line description from the sale order item (shown when <b>Show Description</b> is on). |
| HSN | HSN code. |
| Item Group | Item category. |
| Order Qty | Quantity ordered. |
| Delivered Qty | Net quantity delivered against the order item (delivery notes minus returns, plus service completion notes). |
| Balance Qty | Order Qty minus Delivered Qty. |
| Unit | Unit of measure. |
| Stock Qty | Current stock quantity (shown when status is <b>Not Purchased</b> and inventory access is enabled). |
| Stock Unit | Stock unit of measure (shown when status is <b>Not Purchased</b> and inventory access is enabled). |
| Rate | Price per unit (shown when <b>Show Value</b> is on). |
| Taxable Value | Sale amount before tax for the line (shown when <b>Show Value</b> is on). |
| Tax Amount | Tax on the line (shown when <b>Show Value</b> is on). |
| Total | Line total including tax (shown when <b>Show Value</b> is on). |
| Status | Fulfillment status (Approved, Delivered, Partial Delivered, Returned, Partial Returned, Cancelled, Closed). |

<p>Rows use the same status colors as lists elsewhere in FreeSpace: cancelled and related void statuses in red, draft in grey, and pending / multi-level approval in orange.</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>Show Value</b> / <b>Hide Value</b> — toggle rate, sale amount before tax, tax amount, and total columns</li>
<li><b>Show Description</b> / <b>Hide Description</b> — toggle the line description column</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 the current report view to Excel</li>
<li><b>Print</b> — print the report</li>
<li><b>Order No.</b> — open the sale order</li>
</ul>

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

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

<p><b>How is this different from Order Wise Sale?</b><br><a href="#/sales/reports/order-wise-sale">Order Wise Sale</a> is one row per sale order header. This report shows every item line on each order.</p>

<p><b>How are Delivered Qty and Balance Qty calculated?</b><br>Delivered Qty is net delivery quantity for the order item (from approved delivery notes, reduced by receipt notes, plus service completion notes for service items). Balance Qty is Order Qty minus Delivered Qty.</p>

<p><b>How are amounts calculated?</b><br>Rate, Taxable Value, Tax Amount, and Total are taken from the sale order line. They appear only when <b>Show Value</b> is on. Footer totals skip cancelled lines.</p>

<p><b>Why does a Partially Delivered order not show every item when I filter Delivered?</b><br>Status filters apply per item line. Under <b>Delivered</b>, only lines with Delivered Qty greater than zero appear. Undelivered sibling lines on the same order are excluded.</p>

<p><b>What does Partial Delivered mean?</b><br>The line has some delivered quantity and a remaining balance (Delivered Qty &gt; 0 and Balance Qty &gt; 0).</p>

<p><b>Can I filter to one item?</b><br>Use <b>Item</b> in Advanced Filter, or click an item from <a href="#/sales/reports/item-wise-sale-order">Item Wise Sale Order Report</a>.</p>

<p><b>Are cancelled order lines included?</b><br>Only lines matching your active filters and order status appear. Use the <b>Cancelled</b> status filter to include them. Cancelled rows are shown in red.</p>

<p><b>How do I see the item description entered on the order line?</b><br>Turn on <b>Show Description</b>.</p>

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

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

<ul>
<li><a href="#/sales/reports/order-wise-sale">Order Wise Sale</a></li>
<li><a href="#/sales/reports/item-wise-sale-order">Item Wise Sale Order Report</a></li>
<li><a href="#/sales/reports/order-wise-item-wise-delivery">Order Wise Item Wise Delivery</a></li>
</ul>
