BeyondERP.Newsletter
Menu

Page · Sales and marketing

Item groups

A setup page where you create commission groups of items, which are linked to products and used in commission rates.

Used by
Accounts payable clerk, Accounts payable manager, Collections manager and 14 more roles
Business process
Establish sales commission and incentive structures
Menu item
CommissionItemGroup
Main table
CommissionItemGroup
Data entity
CommissionProductGroupEntity
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 items, which are linked to products and used in commission rates.
What you do hereUse this page to group items so one commission rate can cover the whole group; rates can also be set for a single item instead.
ExampleFor example, BEAT puts its premium products in item commission group PREMIUM and pays 3.00 percent on them, against 1.50 percent for all other items.
Item 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 Item groups1 screen

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

  1. Screen 1

    Create an item group for commission

    Go to Sales and marketing > Commissions > Item groups

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

Steps from Microsoft

  1. Go to Sales and marketing > Commissions > Item groups.
  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 item commission group.Microsoft Learn PREMIUMGroupId
NameThe name of the group.Microsoft Learn Item groupName

Common errors and fixes

MessageWhat to do
No commission on invoices for an item in the group.Set the group in Commission group on the released product's Sell FastTab. Microsoft Learn

Test checklist

  1. Create the item group and assign it on the released product (Sell FastTab > Commission group).
  2. Create a Commission calculation line with Item code Group.
  3. Invoice a sales order for that item to a commission customer.
  4. Check the commission transaction uses the rate from the group line.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item groupsCommission item groups for items that share a commission rate, assigned in Commission group on the released product's Sell FastTabThe commission rate is found by matching the item, customer and sales rep combination on Commission calculation; an item group lets one line cover many items.Creating the group but not assigning it on the released product, so no Commission calculation line matches and no commission is posted.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: Item groups and assignments can be changed at any time; commission already posted isn't changed. Microsoft Learn
If you change it laterCommission calculation rows with Item code Group use the group set on the released product; changes apply to invoices posted afterwards. Microsoft Learn
Technical architect

6Technical

Menu itemCommissionItemGroup Checked in Dynamics 365
FormCommissionItemGroup Checked in Dynamics 365
TableCommissionItemGroupShown as “Commission item group” in Record infoChecked in Dynamics 365
Data entitiesCommissionProductGroupEntityCommission item 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=CommissionItemGroup
Integrate withCommissionProductGroupEntity data entity Microsoft data model
Data migrationCommissionProductGroupEntity (Commission item group): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Commission item 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 definitionCommissionItemGroup columns and relations Microsoft data model
Everyone

8Sources