SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone
1What it is and why
What it is
A report that finds expenses by the expense type that employees entered.
What you do here
Use this report to list employee expenses by type, filtered by expense report number, expense category and legal entity.
Example
For example, a controller runs the report for legal entity BEAT and the Meals category for the quarter and sees one employee at 3,100.00 USD against a team average of 900.00 USD.
The page in Dynamics 365. page title tab to open what to set or check
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 it
When you analyze spending by employee and expense type, for example in a budget review or policy check.
How often
On demand, for example monthly or quarterly.
What the output shows
Employee expenses grouped by expense type, with totals per employee. An employee with a much higher total in one category is a candidate for a policy review.
Run it quarterly per category with a clear date range and follow up on employees far above the team average.The report groups each employee's expenses by category and expense type with totals, so outliers stand out.
In 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.
Per 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 undone
Reversible: The report reads data and changes nothing.
If you change it later
Totals follow the expense category on each line, so a category change on old lines changes the grouping. Microsoft Learn
Technical architect
6Technical
Menu item
output:TrvCostChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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 URL
https://<your-environment>/?mi=output:TrvCost
Data migration
Load 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