BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Customer groups

A setup page for groups of customers that share key parameters. It is the Accounts receivable customer groups page, also reached from the prospect setup because a prospect gets a customer group when it is converted.

Used by
Auditor, Collections agent, Collections manager and 5 more roles
Business process
Define customer classifications in Dynamics 365 Supply Chain Management
Menu item
CustGroup
Main table
CustGroup
Data entity
CustCustomerGroupEntity
Setup steps
2 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 for groups of customers that share key parameters. It is the Accounts receivable customer groups page, also reached from the prospect setup because a prospect gets a customer group when it is converted.
What you do hereUse it to create and maintain customer groups that share settings such as terms of payment, settle periods, inventory posting ledger accounts, sales tax group and default account setup, and to pick the group that converted prospects receive.
ExampleBEAT has the customer groups WHOLESALE (NET30) and RETAIL (NET14). On the Prospects tab of Sales and marketing parameters, WHOLESALE is the default group, so prospect PRO-000180, converted after quotation QUO-000231 for 8,400.00 USD, becomes customer PRO-000180 in WHOLESALE.
Customer 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 Customer groups1 screen

Create and maintain the groups of customers that share key parameters such as terms of payment, settle periods, inventory posting accounts, sales tax group and default accounts.

  1. Screen 1

    Create the customer group

    Go to Accounts receivable > Setup > Customer groups

    1. Select New
    2. Enter the group code, description and terms of payment
    1Customer groupBEAT
    DescriptionCustomers
    Terms of paymentNET30
    Create the customer group (zoomed on the outlined fields)
    Show the full screenCreate the customer group
    page title tab to open what to set or check
Choose the customer group for converted prospects

Pick the customer group that prospects get when they are converted to customers.

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Prospects > Customer groups.
  2. Select New to add a customer group, and enter the Customer group code and a Description.
  3. Fill in columns such as Terms of payment, Default tax group and Default write-off reason.
  4. Go to Sales and marketing > Setup > Sales and marketing parameters and, on the Prospects tab, select the group that converted prospects should get.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Customer groupThe code of the customer group. Every customer must have one, so at least one group must exist before customers are created.Microsoft Learn WHOLESALECustGroup
DescriptionA description of the customer group.Checked in Dynamics 365CustomersName
Terms of paymentThe terms of payment that new customers in the group get by default.Microsoft Learn NET30PaymTermId

Common errors and fixes

MessageWhat to do
A prospect converted to a customer has no customer group, or the wrong one.Select a default customer group on the Prospects tab of Sales and marketing parameters; Learn recommends this for a seamless prospect-to-customer conversion. Microsoft Learn

Test checklist

  1. Create the customer group WHOLESALE with terms of payment NET30.
  2. Select WHOLESALE as the default customer group on the Prospects tab of Sales and marketing parameters.
  3. Convert a prospect to a customer from a quotation with Follow up > Convert to customer.
  4. Check that the new customer has customer group WHOLESALE and terms NET30.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer groupsGroups that separate customers needing different terms, posting or tax defaults (for example domestic, export, intercompany)Learn describes customer groups as customers that share key parameters such as terms of payment, settle periods, sales tax group and default account setup, and posting profiles can be set per group.Moving customers between groups after posting: the Customer to ledger reconciliation report then shows differences between customer and ledger balances.
Choose the customer group for converted prospectsA default customer group on the Prospects tab of Sales and marketing parameters, normally the group with the terms and posting most new customers need (for example WHOLESALE).When a prospect is converted, a default customer group is assigned from the Prospects tab of Sales and marketing parameters, and the group supplies defaults such as terms of payment.Which customer group do converted prospects get?Leaving the default empty, so converted customers need their group and defaults fixed by hand before the first order can be invoiced.Test: Converted prospect gets the default customer group

Feature management and licence

Licence or add-inOn the live system, Sales manager, Accounts receivable manager and Collections manager can maintain 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 undoneHard to reverse: The customer group decides which posting profile row (Group) applies and supplies defaults such as terms of payment. Moving customers between groups after sales start changes only new documents; posted invoices keep the accounts used. Microsoft Learn
If you change it laterA customer group sets defaults for new customers, such as terms of payment, and can carry its own customer number sequence, which is used before the one on Accounts receivable parameters. With prospect-to-cash, a converted prospect keeps its prospect number and gets the default group from Sales and marketing parameters. Microsoft Learn
Technical architect

6Technical

Menu itemCustGroup Checked in Dynamics 365
FormCustGroup Checked in Dynamics 365
TableCustGroupShown as “Customer groups” in Record infoKey field: CustGroupChecked in Dynamics 365
Data entitiesCustCustomerGroupEntityCustomer groups Microsoft data model DimAttributeCustGroupEntityCustomer groups Microsoft data model
Who can open itPrivilegesMaintain customer groups CustGroupMaintainView customer groups CustGroupViewDutiesEnable customer process CustCustomerProcessEnableInquire into customer reference data CustCustomerReferenceDataInquire
8 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerCollections manager CollectionLetterCollectionsManagerTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerCollections agent CollectionLetterCollectionsAgentAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: Setup, Forecast, Product filtersChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustGroup
Integrate withCustCustomerGroupEntity data entity Microsoft data model
Data migrationCustCustomerGroupEntity (Customer groups): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Customer groups at execution unit 1, level 50, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Customer write-off reason codes, the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionCustGroup columns and relations Microsoft data model
Everyone

8Sources