BeyondERP.Newsletter
Menu

Setup step on the Commission calculation page · Sales and marketing

Set up Commission calculation

Use this page to set the commission calculation basis, whether discounts are included, and the period when each commission rate is active.

Used by
Accounts payable clerk, Accounts payable manager, Collections manager and 14 more roles
Business process
Establish sales commission and incentive structures
Menu item
CommissionCalc
Main table
CommissionCalc
Data entity
CommissionCalculationEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define the commission rate a sales representative earns when a sale has a given combination of customer and product.
What you do hereUse this page to set the commission calculation basis, whether discounts are included, and the period when each commission rate is active.
ExampleFor example, the commission can be calculated as a percentage of the sales revenue, which is the net amount of the order line.
Commission calculation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Commission calculation1 screen

Use this page to set the commission calculation basis, whether discounts are included, and the period when each commission rate is active.

  1. Screen 1

    Set a commission rate for a group

    Go to Sales and marketing > Commissions > Commission calculation

    1. Make sure the commission item group, customer group and sales group exist
    2. Select New
    3. Set Item code to Group and select the item group
    4. Set Customer code to Group and select the customer group
    5. Set Sales rep. code to Group and select the sales group
    6. Select the basis and enter the commission percentage
    7. Select Save
    1Item relationBEAT-CIG
    2Customer relationBEAT-CCG
    3Sales rep. relationBEAT-CSG
    4BasicRevenue
    5Commission percentage2.00
    Item codeGroup
    Customer codeGroup
    Sales rep. codeGroup
    DiscountBefore line discount
    Set a commission rate for a group (zoomed on the outlined fields)
    Show the full screenSet a commission rate for a group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Commissions > Commission calculation.
  2. Select New.
  3. In the Item code field, select Group, and then select the item commission group in the Item relation field.
  4. In the Customer code field, select Group, and then select the customer commission group in the Customer relation field.
  5. In the Sales rep. relation field, select the commission sales group.
  6. Keep or change the discount option and the calculation basis, such as Revenue.
  7. In the Commission percentage field, enter the rate.
  8. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item codeSets how the rate is matched to items; select Group to use an item commission group.Microsoft Learn GroupItemCode
Item relationThe item commission group that the rate applies to.Microsoft Learn PREMIUMItemRelation
Customer codeSets how the rate is matched to customers; select Group to use a customer commission group.Microsoft Learn GroupCustomerCode
Customer relationThe customer commission group that the rate applies to.Microsoft Learn KEYACCTCustomerRelation
Sales rep. relationThe sales representatives that earn this commission rate.Microsoft Learn FIELDSalesRepRelation
Commission percentageThe commission rate, as a percentage.Microsoft Learn 2.00CommissionBase
Sales rep. codeThe sales representative or group of sales representatives that earns the commission rate.Microsoft Learn GroupSalesRepCode
DiscountWhether the commission is worked out before or after line discounts are taken off.Microsoft Learn Before line discountDiscLevel
BasicThe amount the commission is calculated on, such as revenue.Microsoft Learn RevenueCommissionBasis

Common errors and fixes

MessageWhat to do
No commission transactions are created when a sales order is invoiced.Check that the customer has a Commission group and Sales group in Sales order defaults, the released product has a Commission group on the Sell FastTab, and a Commission calculation row matches that combination and date. Microsoft Learn

Test checklist

  1. Assign a commission customer group and sales group to a customer (Sales order defaults) and a commission item group to a released product (Sell FastTab).
  2. Create a Commission calculation row for that item group, customer group and sales group with a Commission percentage.
  3. Create and invoice a sales order for that customer and item.
  4. Check that the commission is posted for the sales representatives in the sales group, split by their Commission share.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Commission calculationGroup for Item code and Customer code, a Sales rep. relation, Discount Before line discount and Basic Revenue, with a validity period on each rate.Learn's setup keeps Before line discount and Revenue as the basis and uses customer and item commission groups, so one rate covers a whole group of customers and items instead of one row per customer and item.The rate only applies when the sales order matches the combination. If the customer has no Commission group and Sales group in Sales order defaults, or the released product has no Commission group on the Sell FastTab, no commission is calculated.Test: Commission rate applies to a matching sales order

Feature management and licence

Licence or add-inOn the live system, Sales manager and Accounting supervisor (maintain), and the accounts receivable roles and Collections manager (use) use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Rates are applied to sales transactions as they are invoiced. A change affects later invoices only; use the validity period for rate changes.
If you change it laterCommissions are calculated when invoices are posted; invoices that are already posted aren't recalculated. Microsoft Learn
Technical architect

6Technical

Menu itemCommissionCalc Checked in Dynamics 365
FormCommissionCalc Checked in Dynamics 365
TableCommissionCalcShown as “Commission rates” in Record infoChecked in Dynamics 365
Data entitiesCommissionCalculationEntityCommission calculation Microsoft data model
Who can open itPrivilegesMaintain setup of commission elements CommissionCalcMaintainView setup of commission elements CommissionCalcViewDutiesInquire into sales commissions master CustInvoiceSalesCommissionsInquireMaintain sales commissions master CustInvoiceSalesCommissionsMaintainInquire into compensation process HcmCompensationInquire
17 security rolesCollections manager CollectionLetterCollectionsManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerCompensation and benefits manager HcmCompensationAndBenefitsManagerHuman resource manager HcmHumanResourceManagerPayroll administrator HcmPayrollAdministratorPayroll manager HcmPayrollManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkSales manager TradeSalesManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkCollections manager CollectionLetterCollectionsManagerGive people one of these roles. On this system, 17 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CommissionCalc
Integrate withCommissionCalculationEntity data entity Microsoft data model
Data migrationCommissionCalculationEntity (Commission calculation): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Commission calculation at execution unit 1, level 30, sequence 20. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionCommissionCalc columns and relations Microsoft data model
Everyone

8Sources