BeyondERP.Newsletter
Menu

Report page · Expense management

Mileage per employee

A report that shows the mileage that employees entered.

Business process
Manage time and attendance
Menu item
output:TrvMileage
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 the mileage that employees entered.
What you do hereUse this report to list mileage by worker, expense category or expense report.
ExampleFor example, an auditor runs the report for one sales rep and sees 1,500 miles in the year; with tiers of 0.45 up to 999 miles and 0.25 above, the reimbursement should be 575.00.
Mileage per employee 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 › Mileage per employee
Set up firstExpense categories (Mileage) Microsoft Learn
Used next byExpense types per employee Microsoft Learn
Related pagesExpense management parameters (Standard rate of mileage) 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 you review mileage claims, for example during an audit or before changing the mileage rate.
How oftenOn demand, for example monthly.
What the output showsMileage entered by employees, per worker, expense category and expense report. An amount that doesn't match distance times rate usually means a different rate or a manual change on the line.

Source: Microsoft Learn

Setup steps on this page

Review mileage claims

Check that mileage is claimed and paid at the right rates.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Mileage per employee.
  2. In Records to include, filter on Worker to see one employee's mileage, or leave it open for everybody.
  3. Filter on Expense category or Expense report number to narrow the trips.
  4. Run the report and compare the distances and amounts with the standard rate of mileage in the parameters.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
WorkerThe employee whose mileage you are viewing.Microsoft Learn
Expense categoryThe expense category the mileage was entered under.Microsoft Learn
Expense report numberThe expense report the mileage was entered on.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. Enter mileage lines of 999 and 501 miles for one employee.
  2. Run the report for that worker.
  3. Check the lines show the mileage and the to and from addresses.
  4. Check the amounts follow the mileage rate tiers of the category.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review mileage claimsRun it per employee for the year and check the totals against the tier limits.From 10.0.18 a tier's quantity is the upper limit; above the last tier the standard rate of mileage applies.Should mileage be paid with rate tiers?Checking amounts against the standard rate only, when rate tiers pay less above a mileage limit.Test: Tiered mileage is reported

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 mileage data; it changes nothing. Microsoft Learn
If you change it laterMileage amounts come from the rate tiers of the Mileage category, or from the standard rate of mileage when no tier applies. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TrvMileage 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:TrvMileage
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