Daily use
Explain any earning
Answer why a rep earned a given amount: trace each commission earning to its source document, credit, rate or tier, modifiers, true-up and rounding.
updated: applies-to: 1.2.0.0
Bitta Commission records every calculation step when it writes an earning, so you can answer "why this amount" from inside Business Central. This page shows you how to read the Commission Earning card, its Tier Calculation Details, and the Commission Calculation Trace, and where to look for credit, return and run questions.
Before you start
- The trace exists for every earning written by a calculation run or a period close. Trial runs write no earnings and no trace; they show an Explanation per result line instead. See Calculate commission.
- Sales reps use their own pages: My Earnings, the My Earning card and My Calculation Trace, opened with Explain. They show only the rep's own earnings, and another participant's earning is refused with BAA-RPT-MY-SCOPE. See Sales rep view.
Answer "why this amount" in five steps
- Open Commission Earnings, filter on the participant, date or document, and open the line. The Commission Earning card opens.
- Read the General group. Final Earning Amount is what was written. Prior Recognized Entitlement, Current Cumulative Entitlement and Delta Amount show how a cumulative model adds only the difference since the last earning. Correction Sequence No. is zero for an original earning.
- Read the Calculation Details group: the base before and after this document (Prior Base Value, Current Base Value), the Resolved Rate and Multiplier, the quota Target Value and Attainment Percent, and the rounding (Pre-Round Entitlement, Rounding Adjustment, Amount Precision, Rounding Direction Code). For a Line Rate earning, Rate Source, Pool Key and Pool Margin % show where the line rate came from, as described under Rates and margin pools below.
- Read the Tier Calculation Details part. Each band row shows the bounds, the Value In Band, the Resolved Rate and the Calculated Amount. For a MODIFIER or BASIS row, Unit / Modifier names the modifier (HURDLE, ACCELERATOR, WEIGHT, PRORATION, CAP, FLOOR, GATE, END-DATED, PAIR-WINNER, PAIR-LOSER, FORMULA or PCT-OF-QUOTA), and the lower and upper bounds hold the entitlement before and after that step.
- Choose Trace Nodes to open Commission Calculation Trace, the step-by-step record of this earning.
TIP
When Unmodified Entitlement is filled in, a modifier changed the result. Modifier Codes lists the modifiers evaluated, and each one has a MODIFIER row in Tier Calculation Details.
What each trace node shows
Nodes are listed in Node Sequence. Each node shows a Trace Node Type, a Decision Code, a readable Description, and the Input Value, Parameter Value and Output Value of the step. For a per-document earning the trace contains:
| Decision Code | Trace Node Type | What it explains |
|---|---|---|
| EARNING | Earning | The root node: the model, current base, resolved rate and final amount. |
| SOURCE | Source | The source fact type, document number and business date. |
| CREDIT | Credit | The percent of the source credited to the participant and the credit amount. |
| MEASURE | Measure | The measure code and basis that turned the credit into a measured value. |
| ATTAINMENT | Attainment | How the accumulated base moved and the attainment percent of target. |
| Evidence kind (REVERSAL, REPLACEMENT, STEP) or modifier code | Tier or Formula | One node per rate band, and one per modifier or basis step showing the value before and after. |
| RATE-OR-MODEL | Formula | The model with the rate or amount and the multiplier. |
| TRUE-UP | Correction | Cumulative entitlement less prior recognized entitlement gives the delta. |
| ROUNDING | Earning | The pre-round amount, precision, rounding adjustment and currency. |
Earnings written by a period close have, after the EARNING root, PERIOD-ANCHOR and PERIOD-BASE nodes, then SECONDARY-INPUT and ALLOCATION (rank or share) where they apply, a node named after the model, MULTIPLIER and REFERENCE where they apply, and the same TRUE-UP and ROUNDING nodes. Hidden columns Reference Table No. and Reference ID point to the evidence record each step used. Choose Earning to return to the earning.
Other places that explain a result
| Question | Where to look on the earning card |
|---|---|
| Which document is this? | Source Evidence opens the accepted invoice or credit memo evidence. |
| What else happened to this sale? | Original and Return Earnings lists earnings for the same participant, component and correction root. |
| Why did the amount change after a return or correction? | Correction Links shows the original-to-delta links; from there, Difference Explanation shows the cause, old amount, delta and new amount. |
| Which run produced it? | Calculation Run opens the run and its stage control totals. |
| Which rule decided the rate? | Why This Rate? explains the rate this posted earning was paid: the Set Rate rule, the margin band of its document pool or the flat rate. |
| Has the customer paid the invoice? | The Invoice Payment group and FactBox show Collected %, Last Payment Date and whether the invoice is still open. |
Rates and margin pools
For a Line Rate component, each earning stores where its rate came from, in the Calculation Details group of the Commission Earning card:
| Field | What it shows |
|---|---|
| Rate Source | The code of the Set Rate credit rule that won, BAND and the margin band number, FLAT for the flat rate, or NO-RATE-MATCH or MISSING-COST when the line was paid a zero rate. |
| Pool Key | The document margin pool the line was priced in, for example the product line. Blank when the whole document is one pool or the component does not pool. |
| Pool Margin % | The margin percent of the document pool that selected the margin band. |
The rate source is also printed on the participant statement. The Commission Earnings list has the same three fields as hidden columns; add them with Personalize.
To see which rules decided the rate, choose Why This Rate? on the earning card or on the Commission Earnings list for the selected earning. The same action is in the Commission FactBox on posted sales invoices and credit memos. You can only open it for earnings of participants you are allowed to view. See Why this rate? and Line rates and margin pools.
Explain This Earning
The Commission Earning card has an Explain This Earning FactBox. Its Status tells you whether you can use it:
| Status | Meaning |
|---|---|
| The AI plan drafting module is switched off in Commission Feature Management. | The Explain this earning action is hidden. A call is refused with BAA-FEATURE-OFF. |
| Explanations are not enabled in Commission AI Setup. | Turn on Earning Explanations Enabled in Commission AI Setup. |
| There is no active AI consent for earning explanations. Ask your administrator to accept one on the Commission AI Consents page. | An active consent for earning explanations is missing. |
| Ready. Output is a draft for human review. | Choose Explain this earning. |
The draft is labeled "DRAFT, AI-generated. Review before use. This text cannot change, approve, post or pay anything." You must have scope to the earning's participant, and every call writes a row to Commission AI Call Audit. The provider is a Deterministic Template (no external service) that runs inside Business Central. See AI plan assistant and Optional modules.
Why you can rely on the trace
- Trace nodes are append-only. An attempt to change or delete one fails with "Calculation trace nodes are append-only and cannot be changed."
- Each node stores its own Entry Hash, and the earning keeps its Calculation Input Hash, Calculation Definition Hash and Entry Hash in the Audit Evidence group.
- A correction never rewrites the original. It adds a delta earning with its own trace. See Commission returns.
If the numbers still look wrong, check the plan version and period on the Calculation Run first, then the credit decision. If the source data was wrong, correct it at the source or through a governed correction. For the reports that summarize earnings, see Commission reports.
What's next
See how earnings and balances are recorded: Commission ledger.