# FOC Report

<p class="doc-lead">Lists free-of-charge (FOC) items on sale transactions. Tracks promotional or complimentary goods given to customers with employee, item, customer, and quantity detail.</p>

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

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

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

Go to <b>Sales → Reports → FOC Report</b>.

Report title in ERP: <b>FOC Report</b>

<p><b>What it shows.</b> Each FOC line from sale bills: customer, employee in charge, item, reference price, quantity, and unit. Amounts are for reference only — FOC lines are not billed.</p>

<p><b>When to use it.</b> Use to audit promotional giveaways, verify which employees or customers receive the most free goods, and document non-billed stock movements.</p>

<b>Report view</b>
<img src="sales/images/foc-report.webp" alt="Foc Report" loading="lazy">

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

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

<ul>
<li><b>Sales manager</b> — Which employees or customers received the most FOC items this quarter? Run monthly to monitor promotional spend and policy compliance.</li>
<li><b>Inventory controller</b> — How much FOC stock left the warehouse in a period? Run after goods dispatch to validate non-billed quantities.</li>
<li><b>Internal audit</b> — Are FOC items documented and traceable to a bill, employee, and customer? Run during stock or sales audits.</li>
<li><b>Marketing team</b> — Which items are most frequently given free during promotions? Run by item filter to evaluate scheme effectiveness.</li>
</ul>

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

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

<b>Date</b>, <b>Employee</b>, <b>Customer</b>, <b>Item</b>. <b>Advanced Filter</b>: Branch, Center, Item Group.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Date | Date of the FOC transaction. |
| Bill No | Sale bill or invoice reference. |
| Customer | Customer who received the FOC items. |
| Employee | Employee in charge of the sale. |
| Item | FOC item name. |
| Item Code | Item code or SKU. |
| Price | Reference unit price (not billed). |
| Quantity | FOC quantity given. |
| Unit | Unit of measure. |

<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</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>Why does Price show a value if the item is free?</b><br><b>Price</b> is a reference rate for valuation and reporting. The line is not included in the bill total.</p>

<p><b>Does FOC stock affect inventory?</b><br>Yes. FOC quantities are dispatched from stock even though they are not charged on the invoice.</p>

<p><b>Can I filter FOC by customer or promotion period?</b><br>Use the <b>Date</b> filter for the promotion window and <b>Customer</b> or <b>Item</b> to narrow results.</p>

<p><b>Where are FOC lines entered?</b><br>FOC quantities are recorded on sale invoice item lines marked as free of cost when creating or editing a <a href="#/sales/sale-invoice">Sale Invoice</a>.</p>
<p><b>Does FOC affect revenue totals?</b><br>FOC lines show reference price but zero bill value. Exclude from revenue KPIs when analysing <a href="#/sales/reports/sale-report">Sale Report</a>.</p>

<p><b>Is FOC allowed on all items?</b><br>Only when <b>Allow FOC sale</b> is enabled in <a href="#/sales/sale-settings-config">Sale Settings</a>.</p>
