# Order Wise Variance

<p class="doc-lead">Compares planned vs actual finished-good quantity and value per Production Order. Highlights orders where output variance exceeds the configured limit percentage.</p>

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

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

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

Go to <b>Production → Reports → Order Wise Variance</b>.

<p><b>What it shows.</b> Per Production Order, planned vs actual quantity and value with variance amount, variance percentage, and the output variance limit from the BOM. Rows exceeding the limit show a warning icon and are highlighted.</p>

<p><b>When to use it.</b> Use to monitor production yield and output efficiency across orders in a period.</p>

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

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

<ul>
<li><b>Production manager</b> — Identify orders with significant under- or over-production vs plan.</li>
<li><b>Quality team</b> — Sort by Var. % to prioritize orders needing investigation.</li>
</ul>

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

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

<b>Date range</b> — filters by Production Order date.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Order# | Production Order reference. |
| Item Code | Item code. |
| Item Name | Item name. |
| Unit | Unit of measure. |
| Planned *(Qty)* | Planned output quantity. |
| Actual *(Qty)* | Actual produced quantity. |
| Variance *(Qty)* | Difference. |
| Var. % | Variance percentage. Sortable. |
| Limit % | Output variance limit from BOM. |
| Planned *(Value)* | Planned value. |
| Actual *(Value)* | Actual value. |
| Variance *(Value)* | Value difference. |

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

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

<ul>
<li><b>Generate</b> — run the report</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li>Click <b>Var. %</b> column header to sort by variance percentage</li>
</ul>

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

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

<p><b>Where is the limit % set?</b><br>On the Bill of Materials — <b>Output Variance Limit (%)</b>. Production Settings also defines a default limit for new BOMs.</p>

<p><b>Why is a row highlighted in red?</b><br>Actual output variance exceeds the configured limit percentage for that order's BOM.</p>
<p><b>Variance types?</b><br>Output quantity and raw material deviation vs BOM.</p>
<p><b>Approval audit?</b><br>Orders with variance approval show in workflow history.</p>
<p><b>Can I export this report?</b><br>Yes — use Export from report actions for Excel analysis.</p>
<p><b>Which production setting affects this?</b><br>Review <a href="#/production/production-settings-config">Production Settings</a> for variance, quantity, and BOM rules.</p>