BeyondERP.Newsletter
Menu

Setup step on the Customer groups page · Accounts receivable

Set up Customer groups

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.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor 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
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 for groups of customers that share key parameters.
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.
ExampleFor example, a company can use customer groups to set up automatic posting to General Ledger accounts for the revenue its customers generate.
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

How to use it

  1. Go to Accounts receivable > Setup > Customer groups.
  2. Select New to add a customer group, or select a group and select Edit.
  3. Fill in the Customer group, Description and Terms of payment.
  4. Fill in other columns you need, such as Default tax group or Default write-off reason.
  5. Select Setup, Forecast or Product filters for the selected group if you need them.
  6. Select Delete to remove the selected group.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Customer groupThe code that identifies the customer group.Microsoft Learn WHOLESALECustGroup
DescriptionA short text that describes the customer group.Microsoft Learn CustomersName
Terms of paymentNET30PaymTermId

Test checklist

  1. Create a group with terms of payment.
  2. Add a Group row for it on Customer posting profiles.
  3. Create a customer in the group and post an invoice.
  4. Run Customer to ledger reconciliation and check no differences.

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.
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 group can be changed, but reconciliation reports use the current group, so history doesn't follow the move.
If you change it laterA number sequence set on a customer group is used first for new customer IDs; the one on Accounts receivable parameters is used only when the group has none. 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 itAccounts receivable manager CustInvoiceAccountsReceivableManagerCollections manager CollectionLetterCollectionsManagerSales manager TradeSalesManagerTo 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