# Secondary Status Order Report

<p class="doc-lead">Tracks Production Orders through configured secondary-status phases. Shows phase-wise quantities, delivery against Sale Orders, and stock-after-delivery metrics for workflow visibility beyond the primary order status.</p>

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

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

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

Go to <b>Production → Reports → Secondary Status Order Report</b>.

<p><b>What it shows.</b> One row per Production Order with order date, order number, Sale Order, customer, item, unit, order quantity, dynamic columns for each configured secondary-status phase, produced quantity, pending balance, Sale Order delivered quantity, and stock after delivery.</p>

<p><b>When to use it.</b> Use when your organization tracks production progress through custom secondary statuses (e.g. cutting, stitching, finishing, packing) in addition to the standard order status.</p>

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

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

<ul>
<li><b>Production coordinator</b> — Group by Sale Order to see phase progress for all orders on a customer job.</li>
<li><b>Merchandising</b> — Use Detailed mode to see the latest date each phase was updated.</li>
<li><b>Management</b> — Review pending balance and stock-after-delivery to align production with dispatch schedules.</li>
</ul>

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

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

<b>Quick filters:</b> Date range, Group By (Group By-None, Sale Order), Detailed toggle.

<b>Advanced Filter:</b> Item, Center, Branch, Sale Order, Secondary Status.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Sl No | Row serial number. |
| Order Date | Production Order date. |
| Order # | Production Order reference. Click to open. |
| Sale Order | Linked Sale Order. Click to open. |
| Customer | Customer name. |
| Item | Item being produced. |
| Unit | Unit of measure. |
| Order Qty | Order quantity. |
| *(Phase columns)* | Dynamic columns per configured secondary-status phase — quantity or date in Detailed mode. |
| Produced Qty | Total produced quantity. |
| Pending Balance | Remaining quantity. |
| SO Delivered Qty | Quantity delivered on the Sale Order. |
| Stock After Del. | Stock remaining after delivery. |

Footer row shows <b>Total</b>.

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

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

<ul>
<li><b>Generate</b> — run the report</li>
<li><b>Detailed</b> — show latest update date per phase instead of quantity only</li>
<li><b>Export</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 advanced filters</li>
</ul>

<p>Click a phase cell to open the secondary status entries modal for that order and phase.</p>

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

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

<p><b>Why don't I see phase columns?</b><br>Secondary statuses must be configured in Settings and quantity tracking enabled in Production Settings (<b>Enable quantity tracking in secondary status</b>).</p>

<p><b>How do I update a phase quantity?</b><br>From the Production Order view, use <b>Update Secondary Status</b>. Phase cells on this report are read-only except for opening the entries modal.</p>

<p><b>What does Detailed mode show?</b><br>The most recent date each phase was updated rather than cumulative phase quantity.</p>
<p><b>What is secondary status?</b><br>Custom production pipeline labels beyond standard status.</p>
<p><b>Permission?</b><br>Secondary status edit may need separate permission.</p>