BeyondERP.Newsletter
Menu

Setup step on the Sales groups page · Sales and marketing

Set up Sales groups

Use this page to assign several sales representatives to one group and set each person's share of the commission as a percentage.

Used by
Accounts payable clerk, Accounts payable manager, Collections manager and 14 more roles
Business process
Establish sales commission and incentive structures
Menu item
CommissionSalesGroup
Main table
CommissionSalesGroup
Data entity
CommissionSalesRepresentativeGroupEntity
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 create commission sales groups, which list the sales representatives who can earn a commission.
What you do hereUse this page to assign several sales representatives to one group and set each person's share of the commission as a percentage.
ExampleFor example, BEAT's sales group NORTH holds two sales reps with a 50 percent Commission share each, so a 120.00 commission on an invoice is split 60.00 and 60.00.
Sales groups 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 Sales groups1 screen

Use this page to assign several sales representatives to one group and set each person's share of the commission as a percentage.

  1. Screen 1

    Create a sales group for commission

    Go to Sales and marketing > Commissions > Sales groups

    1. Select New
    2. Enter the group code and name
    3. Select Save
    4. Add sales representatives and their commission shares when the group is used
    1GroupBEAT-CSG
    NameSales group
    Create a sales group for commission (zoomed on the outlined fields)
    Show the full screenCreate a sales group for commission
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Commissions > Sales groups.
  2. Select the sales group.
  3. On the Action Pane, select General > Sales rep.
  4. Select New to add a sales representative, and select the person in the Name field.
  5. Set the Commission share for each sales representative.
  6. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Commission shareEach sales representative's percentage of the commission; the total for the group can't be more than 100.Microsoft Learn
GroupThe unique ID of the commission sales group.Microsoft Learn FIELDGroupId
NameThe name of the commission sales group.Checked in Dynamics 365Sales groupName

Common errors and fixes

MessageWhat to do
Commission isn't split as expected between the sales reps.Check the Commission share of each sales rep in the group (the total must not exceed 100) and the Sales group on the order lines. Microsoft Learn

Test checklist

  1. Create a sales group, open Sales rep. and add two sales reps with a Commission share of 50 each.
  2. Select the group in Sales group on a customer's Sales order defaults and in a Commission calculation row.
  3. Invoice a matching sales order and check that the commission is split 50/50 between the two reps.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Sales groupsOne sales group per team that shares commission, with the Commission share of its sales reps adding up to no more than 100.A sales group lists the sales representatives who can earn a commission, each with a share of the total commission as a percentage; Learn states the total share must not exceed 100.Creating the group but not selecting it in Sales group on the customer's Sales order defaults, or in Sales rep. relation on Commission calculation, means nobody earns commission.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: Shares are read when commission is calculated for an invoice; changes affect later invoices.
If you change it laterThe sales group is copied from the customer to the sales order header and lines, where it can be changed; the people in it receive commission when the order is invoiced, by their Commission share. Microsoft Learn
Technical architect

6Technical

Menu itemCommissionSalesGroup Checked in Dynamics 365
FormCommissionSalesGroup Checked in Dynamics 365
TableCommissionSalesGroupShown as “Commission sales group” in Record infoChecked in Dynamics 365
Data entitiesCommissionSalesRepresentativeGroupEntityCommission sales 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=CommissionSalesGroup
Integrate withCommissionSalesRepresentativeGroupEntity data entity Microsoft data model
Data migrationCommissionSalesRepresentativeGroupEntity (Commission sales group): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Commission sales 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 definitionCommissionSalesGroup columns and relations Microsoft data model
Everyone

8Sources