BeyondERP.Newsletter
Menu

Page · Sales and marketing

Customer groups for commission

A setup page where you create commission groups of customers, used to track commissions for one or more customers.

Used by
Accounts payable clerk, Accounts payable manager, Collections manager and 14 more roles
Business process
Establish sales commission and incentive structures
Menu item
CommissionCustomerGroup
Main table
CommissionCustomerGroup
Data entity
CommissionCustomerGroupEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create commission groups of customers, used to track commissions for one or more customers.
What you do hereUse this page to group customers so one commission rate can cover the whole group; rates can also be set for a single customer instead.
ExampleFor example, BEAT puts its 25 key accounts in customer commission group KEYACCT, so one Commission calculation row pays 2.00 percent on all of them instead of 25 rows.
Customer groups for commission 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 Customer groups for commission1 screen

Use this page to group customers so one commission rate can cover the whole group; rates can also be set for a single customer instead.

  1. Screen 1

    Create a customer group for commission

    Go to Sales and marketing > Commissions > Customer groups for commission

    1. Select New
    2. Enter the group code and name
    3. Select Save
    1GroupBEAT-CCG
    NameCustomer commission group
    Create a customer group for commission (zoomed on the outlined fields)
    Show the full screenCreate a customer group for commission
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Commissions > Customer groups for commission.
  2. Select New.
  3. In the Group field, enter a value.
  4. In the Name field, enter a name.
  5. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
GroupThe ID of the customer commission group.Microsoft Learn KEYACCTGroupId
NameThe name of the group.Microsoft Learn Customer commission groupName

Common errors and fixes

MessageWhat to do
No commission for a customer that should be in the group.Select the group in Commission group on the customer's Sales order defaults, or on the sales order header, before invoicing. Microsoft Learn

Test checklist

  1. Create the group and assign it in Commission group on the customer's Sales order defaults, with a sales group.
  2. Create a Commission calculation line with Customer code Group for the group.
  3. Check Commission posting is set up.
  4. Invoice a sales order for the customer and check the commission voucher posts to the expense and payable accounts.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer groups for commissionCommission customer groups only where one commission rate should cover several customers; set rates for single customers where the deal is customer-specificCommission groups are optional; commission can also be calculated for an individual customer, and the group is matched with item group and sales rep in Commission calculation.Setting up groups and rates but no Commission posting rules. Invoicing of a sales order with eligible commissions then fails.Test: The group drives the commission on an invoice

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: Groups can be added or reassigned on the customer's Sales order defaults at any time; commission already posted isn't recalculated. Microsoft Learn
If you change it laterThe group is copied from the customer to the sales order, where it can be changed. Commission calculation rows with Customer code Group use it for invoices posted afterwards; posted commission isn't recalculated. Microsoft Learn
Technical architect

6Technical

Menu itemCommissionCustomerGroup Checked in Dynamics 365
FormCommissionCustomerGroup Checked in Dynamics 365
TableCommissionCustomerGroupShown as “Commission customer group” in Record infoChecked in Dynamics 365
Data entitiesCommissionCustomerGroupEntityCommission customer group 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 pageGeneral: SetupOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CommissionCustomerGroup
Integrate withCommissionCustomerGroupEntity data entity Microsoft data model
Data migrationCommissionCustomerGroupEntity (Commission customer group): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Commission customer group at execution unit 1, level 30, sequence 10. 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 definitionCommissionCustomerGroup columns and relations Microsoft data model
Everyone

8Sources