BeyondERP.Newsletter
Menu

Setup page · Expense management

Statistics groups

A setup page where you group expense categories for expense reporting.

Used by
Business Performance Planning app role, Data management administrator, Data management migration user and 3 more roles
Business process
Develop people strategy
Menu item
TrvCostTypeStatistics
Main table
TrvCostTypeStatistics
Data entity
TrvStatisticsGroupEntity
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 group expense categories for expense reporting.
What you do hereUse this page to build the groups that the Statistics on cost groups report totals expenses by; each expense category is linked to one group.
ExampleFor example, the Airfare, Hotel and Car rental categories are linked to the group TRAVEL, so the Statistics on cost groups report shows one travel total for management.
Statistics 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

Business processDevelop people strategy
Menu pathExpense management › Setup › Calculations and codes › Statistics groups
Set up firstExpense categories Microsoft Learn
Used next byStatistics on cost groups Microsoft Learn Expense categories Microsoft Learn
Related pagesStatistics on cost groups Microsoft Learn
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 groups1 screen

Group expense categories for management reporting.

  1. Screen 1

    Create a statistics group

    Go to Expense management > Setup > Calculations and codes > Statistics groups

    1. Select New
    2. Enter the statistics group and a description
    3. Select Save
    1Statistics groupBEAT-SG
    DescriptionStatistics group
    Create a statistics group (zoomed on the outlined fields)
    Show the full screenCreate a statistics group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Expense management > Setup > Calculations and codes > Statistics groups.
  2. Select New and enter the group code and description.
  3. Link expense categories to the group on Expense categories.
  4. Run Statistics on cost groups to check the totals.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Statistics groupThe unique code for the statistics group.Microsoft Learn TRAVELTrvCostTypeStatisticsId
DescriptionA short description of the statistics group.Microsoft Learn Statistics groupDescription

Common errors and fixes

MessageWhat to do
A category's cost is missing from the reportLink the category to a statistics group. Microsoft Learn

Test checklist

  1. Create the group TRAVEL.
  2. Link two expense categories to it.
  3. Post expenses in both.
  4. Run Statistics on cost groups and check the group total.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Statistics groupsCreate a handful of broad groups and link every expense category to one.The report totals cost by statistics group, so every category needs a group to be counted.How many statistics groups?Forgetting to link a new expense category, so its cost drops out of the totals.Test: Group totals are complete

Feature management and licence

Licence or add-inIn this system Employee and Contractor enter their own expenses, and Expense administrator sets up the module and processes documents. The expense mobile app needs the Employee role, a company on the user account and a link to an employee with active employment. The expense administrator maintains the groups. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Groups and links can be changed; the report regroups expenses accordingly. Microsoft Learn
If you change it laterThe Statistics on cost groups report totals cost by these groups; a category without a group isn't counted in a group. Microsoft Learn
Technical architect

6Technical

Menu itemTrvCostTypeStatistics Checked in Dynamics 365
FormTrvCostTypeStatistics Checked in Dynamics 365
TableTrvCostTypeStatisticsShown as “Statistics groups” in Record infoChecked in Dynamics 365
Data entitiesTrvStatisticsGroupEntityStatistics groups Microsoft data model
Who can open itPrivilegesMaintain expense statistics groups TrvCostTypeStatisticsMaintainView expense statistics groups TrvCostTypeStatisticsViewDutiesMaintain Master entity data for data management DataManagementApplicationMasterEntitiesMaintainView Master entity data for data management DataManagementApplicationMasterEntitiesViewEnable expense management process TrvTravelAndExpenseProcessEnableInquire into expense management reference data TrvTravelAndExpenseReferenceDataInquire
6 security rolesBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management administrator DataManagementAdministratorData management migration user DataManagementMigrationUserExpense administrator ExpenseAdministratorDemand planning app role ScpDemandPlanningAppRoleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itExpense administrator ExpenseAdministratorInformation technology manager SysServerITManagerBusiness Performance Planning app role BPPBudgetPlanningAppRoleData management migration user DataManagementMigrationUserDemand planning app role ScpDemandPlanningAppRoleGive people one of these roles. On this system, 6 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=TrvCostTypeStatistics
Integrate withTrvStatisticsGroupEntity data entity Microsoft data model
Data migrationTrvStatisticsGroupEntity (Statistics groups): loaded for each company, in Microsoft's default template 600 - Expense.Load order: Microsoft's default template 600 - Expense loads Statistics groups 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 definitionTrvCostTypeStatistics columns and relations Microsoft data model
Everyone

8Sources