BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Statistics group

A setup list of customer statistics groups. A customer is placed in a statistics group so that inquiries and reports can select and total customers by that group.

Used by
Collections manager, Accounts receivable clerk, Accounts receivable manager and 6 more roles
Business process
Define customer classifications in Dynamics 365 Supply Chain Management
Menu item
CustStatGroup
Main table
CustStatisticsGroup
Data entity
CustCustomerStatisticsGroupEntity
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 list of customer statistics groups. A customer is placed in a statistics group so that inquiries and reports can select and total customers by that group.
What you do hereUse this page to group customers so the groups can be used as criteria in inquiries and reports.
ExampleBEAT creates statistics groups KEY for its 15 largest accounts and STANDARD for the rest. The sales report filtered on KEY shows 2,180,000.00 of the year's 3,900,000.00 sales.
Statistics group 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 Statistics group1 screen

Use this page to group customers so the groups can be used as criteria in inquiries and reports.

  1. Screen 1

    Create a customer statistics group

    Go to Sales and marketing > Setup > Statistics > Statistics group

    1. Select New
    2. Enter the statistics group code and description
    3. Select Save
    4. Assign the group to customers, then use it as a criterion in inquiries and reports
    1Statistics groupBEAT-STG
    DescriptionStatistics group
    Create a customer statistics group (zoomed on the outlined fields)
    Show the full screenCreate a customer statistics group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Statistics > Statistics group.
  2. Select New and enter the Statistics group code, for example KEY, and a Description.
  3. Open a customer in All customers and select the statistics group on it.
  4. Filter All customers on the statistics group and check the count.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Statistics groupThe identifier of the statistics group.Microsoft Learn KEYCustStatisticsGroup
DescriptionA short description of the statistics group.Microsoft Learn Statistics groupStatGroupName

Common errors and fixes

MessageWhat to do
A customer is missing from a report filtered on a statistics groupCheck the statistics group on the customer; customers without a group are not selected by the filter. Microsoft Learn

Test checklist

  1. Create statistics groups KEY and STANDARD.
  2. Assign KEY to three customers.
  3. Filter All customers on KEY and check that exactly 3 customers are listed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Statistics groupA few groups that match how management reads customer statistics (for example KEY and STANDARD), assigned on every customer.Statistics groups exist so that inquiries and reports can select and total customers by group.What should statistics groups represent?Leaving the group empty on many customers, so filtered reports silently miss them.Test: Customers filter by statistics group

Feature management and licence

Licence or add-inOn the live system, Accounts receivable roles (clerk, manager, payments clerks), Collections manager, Accounting manager and supervisor, and the Rental roles 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 renamed and customers moved at any time. Microsoft Learn
If you change it laterStatistics groups only select customers in inquiries and reports; moving a customer to another group changes report totals from then on and posts nothing. Microsoft Learn
Technical architect

6Technical

Menu itemCustStatGroup Checked in Dynamics 365
FormCustStatGroup Checked in Dynamics 365
TableCustStatisticsGroupShown as “Statistics group” in Record infoKey field: CustStatisticsGroupChecked in Dynamics 365
Data entitiesCustCustomerStatisticsGroupEntityStatistics group Microsoft data model
Who can open itPrivilegesMaintain accounts receivable statistics groups CustStatGroupMaintainView accounts receivable statistics groups CustStatGroupViewDutiesEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableInquire into invoice and cash reference data CustInvoiceInvoiceAndCashRefDataInquireEnable invoice and cash process RentalCustInvoiceInvAndCashProcEnable
9 security rolesCollections manager CollectionLetterCollectionsManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentAccounts receivable manager CustInvoiceAccountsReceivableManagerCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustStatGroup
Integrate withCustCustomerStatisticsGroupEntity data entity Microsoft data model
Data migrationCustCustomerStatisticsGroupEntity (Statistics group): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Statistics 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 definitionCustStatisticsGroup columns and relations Microsoft data model
Everyone

8Sources