Bitta Commission guide

Percent of sales, margin, and per unit

Set up percent of sales, percent of margin, amount per document and amount per unit components, with measure bases, returns, rounding and worked examples.

status: verified applies-to: 1.1.2.0rev: 1

The simplest commission plans pay one rate or one amount on every sale: a percent of sales, a percent of margin, a fixed amount per document, or an amount per unit sold. This page explains how to set up these models, what each measure basis means, and how returns and rounding work, with worked examples.

Before you start

The setup wizard creates these plans for you with the styles Percent of sales, Percent of margin and Amount per unit sold. See Guided setup wizard.

Choose a model and a measure basis

Model Pays Measure basis Rate cell
Flat Rate One percent of the base Net Amount, Gross Margin, Monthly Recurring Revenue, Annual Recurring Revenue or Net New Monthly Recurring Revenue Rate %
Flat Amount A fixed amount per counted item Document Count, New Customer Count or New Product Count Amount (Company Currency)
Per Unit A fixed amount per base unit sold Quantity Amount (Company Currency)

What each basis measures:

  • Net Amount: posted sales amount, excluding VAT, in company currency, including credit memo reversals.
  • Gross Margin: net amount less the actual cost captured for the sale.
  • Quantity: posted quantity in base units.
  • Document Count: one per posted invoice. A linked return counts back the share of the original document it reverses; an unlinked credit memo counts minus one.
  • New Customer Count and New Product Count: the first sale to a new customer, or of a new product to a customer.
  • The recurring revenue bases measure recurring contracts and subscription events. See Imports, G/L rules, and recurring contracts.

Add a flat component

  1. Open the Draft plan version and choose Components, then New Component.
  2. On Edit Commission Component, enter:
Field What it does
Code A unique component code within the version, up to 22 characters.
Description What the component pays for.
Sequence No. The order in which the component is evaluated.
Weight Percent The allocation weight. All components of the version must total 100 percent, unless a component uses the multiplier weight mode.
Effective From, Effective To The dates within the version.
Model Flat Rate, Flat Amount or, with Advanced commission models, Per Unit.
Measure Basis What the component measures. Per Unit always uses base quantity.
Measure, Company Currency Base / Quota, Payment Policy, Accounting Policy The versioned definitions the component uses. Choose them with the lookup.
  1. Choose Create Company Currency Defaults if you do not have these definitions yet. It creates a measure matching the model and basis, a company-currency base, an On Posting 100 percent payment policy with zero hold, and an earned expense and liability accounting policy. Existing setup is preserved.
  2. Choose OK. Saving creates the posted sales invoice and credit memo rules for the component, visible through Sales Rules.
  3. Choose Rates to open Commission Rates. Enter one row starting at zero with an open upper bound:
    • Rate % for Flat Rate, for example 5 for five percent.
    • Amount (Company Currency) for Flat Amount and Per Unit.
  4. Choose Save Rates.

Commission Sales Rules lists the governed rules that select posted sales invoices and credit memos for the component, with their dates and definition hash.

TIP

Each credited participant needs one effective 100 percent assignment in the plan version. Linked returns follow the original credit automatically.

Worked examples

Percent of sales

A Flat Rate component at 5 percent on Net Amount.

Event Base Commission
Invoice 1,000.00 50.00
Linked return of part of that invoice -400.00 -20.00
Net result 600.00 30.00

Percent of margin

A Flat Rate component at 10 percent on Gross Margin. An invoice of 1,000.00 with a captured cost of 600.00 has a margin of 400.00, so the commission is 40.00.

If Business Central later adjusts the item cost, the change is captured as new cost evidence and applied through a cost adjustment correction linked to the original earning. The original earning is not overwritten.

Amount per unit

A Per Unit component at 5.00 per unit. Selling 10 units pays 50.00. A linked return of 2 units reverses 10.00.

Amount per document

A Flat Amount component at 25.00 per document on Document Count. Three posted invoices pay 75.00. A linked return of 400.00 against a 1,000.00 invoice counts back 0.4 of that document and reverses 10.00.

Rounding and currency

Amounts are rounded with the Calculation Precision and Rounding Direction on Bitta Commission Setup (0.01 and nearest by default). The app rounds the cumulative entitlement for the period and records each earning as the change from the previous result, so the parts always add up to the rounded total. Amount rates are fixed in the rate table's currency once the plan is published.

Optional modifiers

The Modifiers group on the component editor is optional. You can add a Period Cap Amount, a Period Floor Amount, a hurdle and other modifiers. Leave the defaults for a plain flat plan. See Advanced models.

What to check if it goes wrong

Symptom What to do
BAACOMM-PUB-MEASURE-MARGIN-001 Gross margin needs captured cost evidence for the document. Run the native cost capture and calculate again.
Salesperson has no participant mapping effective on the date Create the dated salesperson mapping on the participant card. See Participants and payees.
Per Unit is not offered as a model Switch on Advanced commission models.
Weights do not total 100 Adjust Weight Percent across the version's components.
// next step

Ready to try Bitta Commission?