# Shipping Address Based Sale Report

<p class="doc-lead">Period sales and returns for one customer, split by shipping address — counts, values, net, and sale balance for each delivery location.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/sales/reports/shipping-report?id=overview">Overview</a>
<a href="#/sales/reports/shipping-report?id=use-cases">Use Cases</a>
<a href="#/sales/reports/shipping-report?id=filters">Filters</a>
<a href="#/sales/reports/shipping-report?id=layout">Layout &amp; columns</a>
<a href="#/sales/reports/shipping-report?id=actions">Actions</a>
<a href="#/sales/reports/shipping-report?id=faq">FAQ</a>
</div>
</div>

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

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

Go to <b>Sales → Customer Reports → Shipping Addr. Based Report</b>.

Report title in ERP: <b>Shipping Address Based Sale Report</b>

<p><b>What it shows.</b> A <b>Summary</b> row per shipping address on the customer, with sale count/value, return count/value, <b>Net Value</b>, and <b>Sale Balance</b>. Below the summary, each address lists its sale invoices and credit notes with item lines.</p>

<p><b>When to use it.</b> Compare outlets when the customer uses multiple ship-to addresses on one account (not separate sub-customer records).</p>

<p><b>How amounts are calculated.</b> A customer and date range are required. Sale figures use approved and closed sale invoices in the period, grouped by shipping address on the invoice. Returns use approved and closed credit notes in the same period, grouped by shipping address on the credit note. <b>Net Value</b> is approved/closed sales minus returns. <b>Sale Balance</b> is the sum of remaining balances on those sale invoices.</p>

<img src="sales/images/shipping-report.webp" alt="Shipping Address Based Sale Report with ship-to address, amount, and tax" loading="lazy">

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

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

<ul>
<li><b>Multi-site review</b> — Compare Net Value across a customer’s delivery addresses.</li>
<li><b>Unpaid by location</b> — Use <b>Sale Balance</b> to see which ship-to still has unpaid invoices from the period.</li>
<li><b>Return analysis</b> — Compare Return Count and Return Value by address.</li>
</ul>

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

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

<p><b>Header (quick filters)</b></p>

<ul>
<li><b>Customer</b> — required. The report does not run without a customer.</li>
<li><b>Date</b> — date range for invoices and credit notes. Defaults to the current month.</li>
</ul>

<p>There is no Advanced Filter and no separate shipping-address picker — every address on the customer is listed.</p>

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

<h2 id="layout">Layout &amp; columns</h2>

<p>The header block shows <b>Name</b>, <b>Customer Code</b>, <b>Address</b>, <b>Period</b>, <b>Phone</b>, and <b>Email</b>.</p>

<h3 id="summary">Summary</h3>

| **Column** | **Description** |
|------------|-----------------|
| Address | Shipping address label and lines. |
| Sale Count | Number of sale invoices. |
| Sale Value | Sum of invoice totals. |
| Return Count | Number of credit notes. |
| Return Value | Sum of credit note totals. |
| Net Value | Sale Value minus Return Value (approved/closed sales minus returns). |
| Sale Balance | Sum of remaining balances on the period’s sale invoices. |
| Footer Total | Column totals. |

<h3 id="sale-invoices">Sale Invoices (per address)</h3>

| **Column** | **Description** |
|------------|-----------------|
| Date / Inv No. / ID / LPO# | Invoice date, number, id, and customer PO. |
| Item / Rate* / Qty / Tax % / Tax Amount / Total | First item on the invoice; further items on following rows. |
| Shipping / Roundoff | Shown when those amounts exist. |
| Bill Total | Invoice total. |
| Bill Balance | Remaining invoice balance. |

<h3 id="credit-notes">Credit Notes (per address)</h3>

| **Column** | **Description** |
|------------|-----------------|
| Date / Inv No. / Id | Credit note date, number, and id. |
| SaleInv | Linked sale invoice. |
| Damaged | <b>Damaged</b> when the return is inventory-less, otherwise -. |
| Item lines | Same item columns as invoices. |
| Bill Total | Credit note total. |

<p>Tap a summary address to open <a href="#/sales/reports/customer-outstanding">Customer Outstanding Bills</a> filtered to that shipping address.</p>

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

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

<ul>
<li><b>Generate</b> — run the report for the selected customer and date range</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report (company header included)</li>
</ul>

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

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

<p><b>Why do I see only one summary row?</b><br>Customers with a single shipping address appear as one row. The report is most useful when the customer has several ship-to addresses.</p>

<p><b>How is Net Value calculated?</b><br>Approved and closed sale totals minus approved and closed credit note totals for that shipping address in the period.</p>

<p><b>How is Sale Balance different from Net Value?</b><br>Net Value is sales minus returns. Sale Balance is unpaid invoice amount still open on those sales.</p>

<p><b>Which address is used?</b><br>Shipping address on the sale invoice or credit note — not the billing address on the customer master.</p>

<p><b>How is this different from Sub Branch Sale Report?</b><br>This report splits one customer by shipping address. <a href="#/sales/reports/sub-customer-sale-report">Customer Sub Branch Based Sale Report</a> splits a parent into sub-customer accounts.</p>

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

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

<ul>
<li><a href="#/sales/reports/sub-customer-sale-report">Customer Sub Branch Based Sale Report</a></li>
<li><a href="#/sales/reports/customer-outstanding">Customer Outstanding Bills</a></li>
</ul>
