# FRN Report

<p class="doc-lead">Finished Roll Number (FRN) tracking with barcode, linked MRN, roll status lifecycle, and customer/Sale Order mapping. Supports bulk loading requests and manual status updates.</p>

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

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

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

Go to <b>Production → Reports → FRN Report</b>.

<p><b>What it shows.</b> Each Finished Roll Number with dimensions, barcode, linked MRN and MRN dimensions, item, Production Order, roll status, requested vs actual customer and Sale Order. Rows are color-coded by roll status.</p>

<p><b>When to use it.</b> Use to track finished rolls from production through loading, packing, shipping, and returns.</p>

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

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

<ul>
<li><b>Dispatch team</b> — Filter by status In hand or Packed and create Loading Requests for selected rolls.</li>
<li><b>Customer service</b> — Trace a roll's requested vs actual customer and Sale Order assignment.</li>
<li><b>Warehouse</b> — Update roll status manually when physical movement is not captured by a transaction.</li>
</ul>

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

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

<b>Quick filters:</b> Date range, Sale Order, Production Order, Status (Status-All, In hand, Loaded, Packed, Shipped, Returned, Rejected, Amendment).

<b>Advanced Filter:</b> Item, Batch, Item Group, Variant, Brand, MRN, Customer.

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

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

| **Column** | **Description** |
|------------|-----------------|
| *(checkbox)* | Select row for bulk actions. |
| Date | FRN date. |
| FRN | Finished Roll Number. |
| Barcode | Roll barcode. |
| Length | FRN length. |
| Width | FRN width. |
| SQM | Square metres. |
| MRN | Source Material Roll Number. |
| Length *(MRN)* | MRN length. |
| Width *(MRN)* | MRN width. |
| SQM *(MRN)* | MRN square metres. |
| Item | Finished item. |
| PRO ID | Production Order. Click to open. |
| Status | Roll lifecycle status. |
| Req Customer | Customer requested on the order. |
| Req SO | Requested Sale Order. |
| Actual Customer | Customer the roll is assigned to. |
| Actual SO | Actual Sale Order assignment. |

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

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

<ul>
<li><b>Generate</b> — run the report</li>
<li><b>Create Loading Request</b> — create a loading request for selected rolls *(requires Loading Request create access)*</li>
<li><b>Update status manually</b> — change roll status on selected rows *(requires roll status update access)*</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>

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

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

<p><b>What do the row colors mean?</b><br>Each roll status (In hand, Loaded, Packed, Shipped, etc.) has a distinct color for quick visual scanning.</p>

<p><b>When should I use Update status manually?</b><br>When a roll's physical status changed outside the normal loading or dispatch workflow and you need to align the system record.</p>

<p><b>How are FRNs created?</b><br>Through Roll Split Up on a Production Order — splitting material rolls into finished rolls with FRN numbers.</p>
<p><b>What is FRN?</b><br>Finished roll number tracking for textile/roll production.</p>
<p><b>Loading request?</b><br>FRN report may create loading request for dispatch.</p>