Chapter 5 of 8Page 4 of 9

Daily use

Commission returns

Adjust commission for credit memos and returns: calculate linked returns against the original sale, and process approved manual corrections and requests.

updated: applies-to: 1.2.0.0

Commission has to follow a sale when it is returned or corrected. Bitta Commission never edits an earning: a return or correction request appends a signed delta earning linked to the original; a manual correction adds a new Manual Adjustment fact. This page shows you how to calculate linked returns, resolve credit memos on Unlinked Commission Returns and the Return Matching Workbench, and run governed changes through Commission Manual Corrections and Commission Correction Requests.

Before you start

  • Credit memos must be captured as source facts. See Capture posted sales.
  • Agree a return policy with finance on Commission Return Policies. Leave the plan blank for the company default; a plan version policy overrides it. Only Active policies are used.
Field What it does
Unlinked Return Mode A credit memo without a linked original invoice is rejected (Reject), credited as a negative sale to the salesperson (Credit As Negative Sale), or held for a manual link (Manual Link Required).
Timing Policy Where a late return or correction is recognized when its original period is closed: Original Period If Open, Current Open Period or Block.
Netting Basis Item Ledger Lineage (default) calculates a linked return as its own negative earning when the credit memo is posted. Customer Ledger Application changes nothing at posting and reduces commission only when the credit memo is applied to the invoice. It needs an eligibility policy that releases on payment (On Payment or On Full Payment); plan validation reports BAA-PLAN-NETTING-TRIGGER otherwise. See Credit memo netting.
Match Tolerance Percent How far a credit memo amount may exceed a candidate invoice line before the candidate is dropped.
Require Same Salesperson Matching only considers invoices with the credit memo's salesperson code.

Two actions on Commission Return Policies belong to Customer Ledger Application: Netting Exclusions lists the reason codes, source codes and journal batches of credit memos that never reduce commission, and Credit Memo Netting Entries shows how applied credit memos reduced commission.

  • Manual corrections and correction requests need a second user to approve them. The requester cannot approve their own, unless they are an administrator (see Approval policies). An administrator cannot approve a correction that affects their own commission unless they are SUPER, and an administrator's decision is recorded in the Administrator Approval field.

Calculate a linked return

A credit memo linked to its original accepted invoice is calculated as a return run. It cannot be calculated until you review it.

NOTE

This section describes the default Netting Basis, Item Ledger Lineage. When the return policy uses Customer Ledger Application, a credit memo is not calculated as a return (BAA-COR-NETTED-ON-APPLICATION). Apply the credit memo to the invoice instead; commission is reduced then.

  1. Open Commission Calculation Runs, or the fact's Calculation Run from a batch, and select the return run.
  2. Choose Preview and Calculate Return. Review Return Before Calculation shows, per participant and component, the Recognized Entitlement, the Projected Entitlement after the return, the Projected Return Delta and the Projected Eligible Delta. No return earning is posted by the preview.
Review Return Before Calculation showing Recognized Entitlement, Projected Entitlement, Projected Return Delta and Projected Eligible Delta per participant
Step 2: the return preview, nothing posted yet.
  1. Choose OK. Source, plan, period and original evidence are checked again, and the negative delta earning is written in the original's correction chain.

The return delta is the cumulative entitlement after the return less the cumulative entitlement already recognized, so on a cumulative or tiered plan the whole position is recalculated rather than the original line alone.

A return reverses at the cost and rate its sale earned:

  • On a margin plan that uses a dated or supplied cost, a linked return or correction is costed at the cost recorded for its original line, not the cost in force on the return date. A full return brings the margin back to zero, and a partial return reverses a proportional share. See Commission costs.
  • On a Line Rate component, the return is priced from the earning of its original line: the same rate, rate source, pool key, pool margin and band. A return whose sale never earned is priced from the original document's pool. See Line rates and margin pools.

To check the result:

  • Return Evidence on Commission Source Facts shows the original earning date, correction date, recognized and correct entitlement, the delta and eligible delta, and an evidence hash.
  • Correction Links shows the immutable original-to-delta links, with Prior Period Adjustment and the resolved Posting Date when the original period was closed.
  • Difference Explanation opens Commission Difference Explanations: the cause, old amount, delta, new amount and any Affected Settlement that had already consumed the original.

Match unlinked returns

  1. Open Unlinked Commission Returns. It lists accepted credit memos that have no linked original invoice.
Unlinked Commission Returns list of credit memos without an original invoice, with Propose Links and Credit As Negative Sale actions
Step 1: credit memos waiting for a link.
  1. Select a credit memo and choose Propose Links. Candidate original invoices are scored on amount, item, salesperson and quantity, and the Return Matching Workbench opens.
Return Matching Workbench listing candidate original invoices for a credit memo with Match Score, Match Reason Code and Status
Step 2: candidate invoices scored for one credit memo.
  1. Review the Match Score and Match Reason Code of each candidate, select the best one and choose Link and Replay. On Correction Run Context, enter the Plan Code, Plan Version No., Period Code and Reason Code, and choose OK.
Correction Run Context dialog asking for Plan Code, Plan Version No., Period Code and Reason Code before Link and Replay
Step 3: the plan, period and reason for the replay.
  1. The credit memo is replayed as a linked return. Open Commission Calculation Runs and calculate it as described above.

Reject on a candidate asks for a Reason Code; the credit memo stays in suspense until another candidate is linked. When the return policy allows it, Credit As Negative Sale on Unlinked Commission Returns calculates the credit memo as a negative credit to its salesperson through the normal pipeline instead.

WARNING

An unresolved credit memo stays in suspense and never corrects commission automatically.

Make a manual correction

Use a manual correction when you must adjust commission that no source document explains.

  1. Open Commission Manual Corrections and create a correction.

  2. On Commission Manual Correction, choose the Action Type: Add, Subtract, Transfer to another participant, Reclassify to another component, or Release Pending. Fill in the positive Base Adjustment Amount (the action decides the sign and the plan model converts it to commission), an Effective Date inside the selected open period, Reason Code, Evidence Reference, and the participant, plan, version, component and period in the Scope group.

  3. A second user chooses Approve. If you requested the correction yourself, you cannot approve it unless you are an administrator.

  4. Choose Process. A Manual Adjustment source fact is created and calculated through the commission pipeline, so the result has a full trace. A transfer posts a conserved pair that nets to zero. For Release Pending, Process releases the pending earning in Pending Earning Entry No. instead.

Raise a correction request

Use a correction request when something upstream changed and many earnings are affected. The Request Type is Plan or Rule Correction, Organization Correction, Quota Correction, Backdated Source, Reverse Correction or Credit Override.

  1. Open Commission Correction Requests and create a request. Set the Request Type, the Recalculation Mode, Timing Policy, Effective Date, optionally Effective Date To, the Reason Code, and the affected plan, participant, quota, source or run.
  2. Choose Analyze Impact. The Impact Preview lists every affected earning with its As-Was Amount, whether its period is closed (Period Closed) and whether a settlement already consumed it (Settled). The request shows the Settled Earning Count and Settled Amount.
Setting What it does
Recalculation Mode Delta Only, Full Replacement (reversal plus replacement), Unsettled Only or Preview Only. Unsettled Only reverses and replaces like Full Replacement, but leaves a source document as posted when any of its earnings is already payable, paid or settled. Plan or rule, organization, quota and credit override corrections cannot use Delta Only. Backdated Source and Reverse Correction requests use Delta Only or Preview Only.
Effective Date To The last business date the correction applies to. Leave it blank to include every later date. It cannot be earlier than Effective Date (BAA-COR-REQ-DATE-RANGE).
  1. A second user chooses Approve. The requester cannot approve their own request unless they are an administrator.
  2. Choose Queue Recalculation. The items appear on Commission Recalculation Queue and are processed in chunks, earlier chunks first. A Preview Only request is never queued.
  3. Let the job queue process them, or choose Process Now. Difference Explanations shows the old and new result of every delta.

Approve and Queue Recalculation need the Bitta Commission Recalculation Approver permission set in addition to your commission role; without it they are refused with BAA-COR-REQ-RECALC-APPROVER. SUPER does not include this permission set, so assign it explicitly. Before it continues, each action asks you to confirm how many earnings the recalculation affects, their current amount, and how many of them are already payable, paid or settled. An approved credit override is queued without this confirmation, but still needs the Recalculation Approver permission set.

Choose Before/After Report on the request to print Commission Recalculation Before/After: one row per affected earning with the amount Before, the Delta, the amount After, whether it was Settled, and a status of KEPT-SETTLED, NOT-POSTED, UNCHANGED or CHANGED.

Closed periods are never reopened; the timing policy decides where deltas post. When the original period is closed, a delta the policy allows posts as a prior-period adjustment in a later open period, and a negative delta on a settled earning may become recoverable. See Commission clawbacks.

To undo a correction run, choose Reverse Correction Run on Commission Correction Links. It creates a Reverse Correction request; approving and recalculating it appends a new delta, and neither history layer is deleted. Change Events on the request shows the append-only decision log with before and after hashes.

Prepare many corrections at once

Commission Adjustment Worksheet lets you prepare many correction requests in one batch, for example after a pricing error across a month. Nothing posts from the worksheet.

  1. Open Commission Adjustment Worksheet and choose a Batch Name (DEFAULT by default).
  2. Add one line per correction: Request Type, Recalculation Mode, Timing Policy, the affected plan, version, participant, quota, source entry or run, Effective Date and Effective Date To, a Reason Code and a Description.
  3. Choose Create Correction Requests. Each line becomes an analyzed correction request, which another user approves as described above.

Correction Requests opens the correction requests, and Delete Processed Lines clears the lines that already became requests.

For the reports that list corrections and recoveries, see Commission reports.

What's next

// next step

Ready to try Bitta Commission?