Finance | Project Operations, Human Resources, ...

Expense Management - Calculated mileage rate tiers

(1) Share

Report

Posted on by Community Member

Hi everyone,

I work for a customer in England and there is a regulation regarding the mileage allowance.

The regulation states that the rate is 0.45p up to 10.000 kilometres

and for more than 10,000 kilometres the rate is 0.25p.

I maintan the mileage rate like this:

What I now expect is that the system will track how many kilometers the employee has done within the year and automatically change the rate once he exceed the 10,000 kilometers.

But my result is different. The report determined the correct mileage for that employee, but the system only changed the rate when I exceed the kilometres in only one expense.

Does anyone solved this issue?

Thanks in advance!

All responses (13)

Answers (0)

NF-22051023-0 4 on at

Like (0)

Report

Expense Management - Calculated mileage rate tiers

This has been raised multiple times on the ideas portal.

There is a functionality for the mileage to be tracked via the fiscal year, which doesn't help, that's the legal entity's fiscal year and not the employees tax year's dates.

If everyone can vote on the ideas perhaps Microsoft will add the ability to define the tax year for the reporting

here are all the ideas i have found so far associated with this issue:

1. Microsoft Idea (dynamics.com)

2. Microsoft Idea (dynamics.com)

3. Microsoft Idea (dynamics.com)

the work around that we use in the UK, is setting the rates up for each year and using the from and to dates, which becomes messy as there are lots of different rates.

Reporting is also not very good, because the mileage by employee gives you mileage against the expense category and not the vehicle types
lauradowns 5 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

Hiya,

Did anyone ever find a solution for this? I can see Microsoft have updated their docs but it is very generic and doesn't exactly state how.
Mia07 95 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

Hi, Reaching out to ask if you managed to fix this issue?
Mia07 95 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

Thank you for that, i am also getting the same issue. Have you raised this with Microsoft?
Natascja 35 on at

Like (1)

Report

RE: Expense Management - Calculated mileage rate tiers

If you enter 10,000 against the 0.45 and then 9,999,999 against the 0.25 it should charge the first 10,000 miles at 45p. The trouble I'm having is getting the system to change the rate based on the cumulative miles.
Natascja 35 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

I'm getting exactly the same re rate changes only within one expense :-(
Mia07 95 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

For info, i have found this docs.microsoft.com/.../set-up-mileage. Currently setting it up but I am abit confused on how to configure the tiers so that anything above 10k miles automatically switches to 25p/mile

If anyone manages to figure it out, please let me know.

:)
Mia07 95 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

I am facing the issue where i have configured the different rates for the first 10k mile @ 45p/mile and above 10k miles @ 25p/mile.

When entering an expense report, for the first 10k miles, the rate being picked up is 25p/mile, i have checked and my user has not logged any mileage expenses so technically the rate for the first 10k miles of 45p/mile should be picked up.

Current version 10.0.19.

Am i missing something here?
Natascja 35 on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

Hi, I'd be interested to know if you find an answer as we have the same scenario. Thanks Natascja
Community Member on at

Like (0)

Report

RE: Expense Management - Calculated mileage rate tiers

Hi,

Was a resolution ever found for this as we are facing a similar issue, especially after updating to 10.0.18.

Thanks

Steve