# Quotation Aging

<p class="doc-lead">Approved sale quotations that are still open, grouped by how long they have been waiting. Use it to chase quotes that never became an order or invoice.</p>

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

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

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

Go to <b>Sales → Reports → Quotation Aging</b>.

Report title in ERP: <b>Quotation Aging Report</b>

Permission: <b>Quotation Aging</b> (<b>s.r.sqag</b>).

<p><b>What it shows.</b> One row per approved sale quotation, under aging bands. The amount is the quotation total. Oldest quotations are first in each band. Each band has a total, and the report has a grand total.</p>

<p><b>When to use it.</b> Use when you want the quotes that are still sitting with the customer — not yet an order, invoice, or pro forma.</p>

<p><b>Which quotations are included.</b> Status <b>Approved</b>, and the quotation date is on or before the as-of date. Draft, cancelled, lost, revised, and closed quotations are excluded. Creating a sale order, sale invoice, or pro forma from the quotation closes it, so it drops off this report. Marking it closed or lost does the same.</p>

<p><b>How age is calculated.</b> Days from the as-of date back to the quotation date, or to <b>Valid Until</b> when that basis is selected. If Valid Until is empty, the quotation date is used. A negative day count means the quote is not yet due; those rows sit in <b>Current</b>. That band only fills when the basis is Valid Until.</p>

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

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

<ul>
<li><b>Sales manager</b> — Which approved quotes are older than 30 days and still not ordered? Run before the weekly pipeline meeting.</li>
<li><b>Salesperson</b> — Which of my quotes should I follow up today? Filter by employee and sort by age.</li>
<li><b>Credit control</b> — Which quotes are past Valid Until? Switch the basis to <b>On Valid Until</b>. Rows still inside the validity sit in Current.</li>
</ul>

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

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

<ul>
<li><b>Date</b> — Age quotations as of this date. It cannot be after today.</li>
<li><b>On Quotation Date</b> / <b>On Valid Until</b> — Which date the age is counted from. Default is the quotation date, because Valid Until is often left blank.</li>
<li><b>Age type</b> — <b>0–30</b> (Current, 0–30, 31–60, 61–90, 91–120, &gt;120) or <b>0–7</b> (Current, 0–7, 8–15, 16–30, then 31–60 onward).</li>
<li><b>Employee</b> — Limit to quotations for one salesman.</li>
<li><b>Sort by</b> — Age (oldest first) or customer name, within each band.</li>
<li><b>Advanced Filter</b> — Customer Group, Form Type, Branch, Customer. Branch is hidden when the company has a single branch.</li>
</ul>

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

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

Quotations are grouped under band headers. The band total is on the right of the header. <b>Current</b> is shown when the basis is Valid Until, or when that band has rows.

| **Column** | **Description** |
|------------|-----------------|
| Customer | Customer name and code. A quotation without a customer shows the party name or the lead. |
| Salesman | Sales employee on the quotation. Blank when none is set. |
| Quotation No | Sale quotation number. Click to open the quotation. |
| Date | Quotation date. |
| Valid Until | Validity date. Blank when it was not entered. |
| Total | Quotation total. |
| Days | Age in days as of the report date. Negative means not yet due. |

<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 All</b> — download every quotation in the report as Excel. The file is a numbered list with Customer, Salesman, Quotation No, Date, Valid Until, Total, Days, and Age, plus a total row. Dates are DD/MM/YYYY. It is the same export style as <a href="#/sales/reports/sale-report">Sale Report</a>.</li>
<li><b>Print</b> — print the on-screen report.</li>
<li><b>Advanced Filter</b> — extra filters. <b>Clear</b> removes them.</li>
</ul>

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

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

<p><b>How is this different from Invoice Aging?</b><br><a href="#/sales/reports/invoice-aging">Invoice Aging</a> lists unpaid invoices and their outstanding balance. Quotation Aging lists open approved quotations and their quotation total. Nothing has been billed yet.</p>

<p><b>How is this different from Quotation Wise Sale?</b><br><a href="#/sales/reports/quotation-wise-sale">Quotation Wise Sale</a> lists quotations in a date range, including ones already closed by a sale. Quotation Aging keeps only the ones that are still approved and open, and groups them by age.</p>

<p><b>Why is a quotation missing after we created the order?</b><br>Creating the order, invoice, or pro forma closes the quotation. Closed quotations are not aged.</p>

<p><b>Why is Salesman blank?</b><br>The quotation has no sales employee. The report does not show a placeholder.</p>

<p><b>Why is Current empty?</b><br>On Quotation Date, every included quotation is already dated on or before the as-of date, so none are “not yet due”. Switch to <b>On Valid Until</b> to see quotes that are still inside their validity.</p>

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

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

<ul>
<li><a href="#/sales/reports/invoice-aging">Invoice Aging</a></li>
<li><a href="#/sales/reports/quotation-wise-sale">Quotation Wise Sale</a></li>
<li><a href="#/sales/sale-quotation">Sale Quotation</a></li>
</ul>
