BeyondERP.Newsletter
Menu

Report page · Expense management

Statistics on cost groups

A report that shows expense amounts grouped by cost group.

Business process
Manage time and attendance
Menu item
output:TrvCostTypeStat
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 report that shows expense amounts grouped by cost group.
What you do hereUse this report to see expense totals per statistics group, filtered by expense report number and statistics group.
ExampleFor example, travel, accommodation and meals categories are linked to the statistics group TRAVEL; the report shows TRAVEL at 54,000.00 USD for the year, without listing each category.
Statistics on cost 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 processManage time and attendance
Menu pathExpense management › Inquiries and reports › Statistics on cost groups
Set up firstStatistics groups Microsoft Learn
Used next byExpense types per employee Microsoft Learn
Related pagesExpense categories 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.

When to run it

When to run itWhen management wants expense totals per cost group rather than per employee or category.
How oftenOn demand, for example in monthly cost reviews.
What the output showsExpense amounts totaled per statistics group. Amounts in an unexpected group usually mean the expense category is linked to the wrong statistics group.

Source: Microsoft Learn

Setup steps on this page

Total expenses by statistics group

Give management expense totals by cost group.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Statistics on cost groups.
  2. In Records to include, filter on the Expense report number if you want specific reports.
  3. Filter on the Statistics group to include only the cost groups you want to compare.
  4. Run the report and read the totals per statistics group.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Expense report numberThe expense report whose costs are grouped.Microsoft Learn
Statistics groupThe cost groups to include on the report.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report prints no linesRecords to include filters out everything, or the data isn't posted yet. Clear the filters, check the date range, and run it again. Microsoft Learn
The report runs but shows another company's data is missingReports read the current legal entity only. Change company and run the report again. Microsoft Learn

Test checklist

  1. Link two expense categories to one statistics group.
  2. Post expenses in both categories.
  3. Run the report for that statistics group.
  4. Check the group total equals the sum of both categories.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Total expenses by statistics groupDefine a few broad groups (travel, entertainment, training) and link every expense category to one.The report totals cost per statistics group, so a category with no group is left out of the totals.Which cost groups should management see?Adding a new expense category without a statistics group, so its cost is missing from the report.Test: Group totals add up

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 runs this report; no Feature management feature is needed.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report runs in the legal entity you are signed in to and reads that company's expense data. Microsoft Learn
Can it be undoneNothing to undo: The report only reads expense data; it changes nothing. Microsoft Learn
If you change it laterThe grouping comes from the statistics group on each expense category; changing it changes how existing expenses are grouped. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TrvCostTypeStat Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:TrvCostTypeStat
Data migrationLoad order: The report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted or entered expense data and prints it; nothing on it is loaded or migrated. Run it in each environment after the data is there.Microsoft Learn
Everyone

8Sources