You’re offline. This is a read only version of the page.
115
Hi everyone,
Thanks for letting me join this group...
So I will ask you my first question.
We are using MicrosoftDynamics AX 2012 R3 CU8.
We have one of our companies which is located in UK.
Do you ever have a problem calculating mileages rates refering to the UK tax year. I mean our fiscal year is from January to December and as far as I understood, mileage rates calculation has to be on a special tax year defined by HRMC (April 6th to April 5th the year later).
Did I understand the problem correctly.
How did you setup the case.
I donwloaded the Hotfix KB4056927 (United Kingdom/GBR: Mileage doesn't calculate correctly when adding 2 lines in the different fiscal year within the same natural year), but I am not so sure it will fix my problem.
Hi Christophe,
Thank you for provided details. I wanted to test the scenario, but my current workload doesn't allow it. Would it be possible to open an official Service Request to MS Support team ?
Also to let you know - the KB I have mentioned was only released for AX 2012, and on D365 Finance it i snot available. I have also confirmed with product team that it is not supported.
Sorry for my delay and thanks for collaboration.
Hi Christophe,
It is hard to read provided info. Could you put all data and screenshots into a Word document and attach it to the thread ?
Thanks for understanding.
Another information : those 2 transactions are not posted
2021-04-09 12:32:40.000 2021-02-25 00:00:00.000 4 Mileage Personal 30 0,45 0,45 1847
2021-04-09 12:38:10.000 2021-03-08 00:00:00.000 4 Mileage Personal 13,5 0,45 0,45 1860,5
If my calculation is ok what I have is :
Tax Year 2020 (I mean between April 6th 2020 and April 5th 2021 :
km sum : 11056,5 - For me last 3 transactions should have had a price value of 0.25
Fiscal Year 2020 (betwen January 1st 2020 to December 30st 2021): km Sum = 817
Fiscal Year 2021 (betwen January 1st 2021 to December 31st 2021) : km Sum = 10239,50
As we can remark, only the last transaction as a price of 0,25...
Hope it helps but when I look to the code, I don't see where system looks to HRMC Tax Year period...
Hi,
Thanks, it's very kind of you. You'll find below an example for one worker :
createddatetime transdate exptype description vehicletype kmowncar kmprice exp. Km Price ***. Km Tax Year 2020
2020-09-21 12:50:43.000 2020-08-17 00:00:00.000 4 Mileage Personal 149 0,45 0,45 149
2020-09-21 12:53:20.000 2020-08-19 00:00:00.000 4 Mileage Personal 18 0,45 0,45 167
2020-09-21 13:32:48.000 2020-08-27 00:00:00.000 4 Mileage Personal 30 0,45 0,45 197
2020-09-21 14:09:59.000 2020-09-10 00:00:00.000 4 Mileage Personal 18 0,45 0,45 215
2020-09-21 14:17:10.000 2020-09-14 00:00:00.000 4 Mileage Personal 602 0,45 0,45 817
2021-04-21 09:57:27.000 2021-01-04 00:00:00.000 4 Mileage Personal 1000 0,45 0,45 1817
2021-04-09 12:32:40.000 2021-02-25 00:00:00.000 4 Mileage Personal 30 0,45 0,45 1847
2021-04-09 12:38:10.000 2021-03-08 00:00:00.000 4 Mileage Personal 13,5 0,45 0,45 1860,5
2021-04-21 09:59:41.000 2021-03-10 00:00:00.000 4 Mileage Personal 8139,5 0,45 0,25 10000
2021-04-21 14:30:49.000 2021-04-02 00:00:00.000 4 Mileage Personal 100 0,45 0,25 10100
2021-04-21 14:41:45.000 2021-04-05 00:00:00.000 4 Mileage Personal 760,5 0,45 0,25 10860,5
2021-04-21 15:24:35.000 2021-04-05 00:00:00.000 4 Mileage Personal 239,5 0,25 0,25 11100
Hi Christophe,
Could you provide an example how the mileage expense has been calculated in your system ?
Hello
My colleague and I have prepared the setup after installation of hotfix. Sorry but I dont still understand how it works.
Below a summary of what we did :
1 - Our fiscal year starts January 1st and ends Decembrer 31st (Financial Calendar STD)
2 - Milage Rate tier :
As defined by HMRC (as far as I understood) :
From April 6th 2020 to April 5th 2021
from 0 km, Rate 0.45
from 10000km, Rate 0,25
From April 6th 2021 to April 5th 2022
from 0 km, Rate 0.45
from 10000km, Rate 0,25
When we enter Expenses (category milage), then total of km is done on the year of the expense and not on the "fiscal year" as defined by HMRC
Thank you so much. We are going to test. I think I made a mistake in the setup (period for mileage rates). I'll let you know.
Take care
Hello Christophe,
Attached you find repro steps our team prepared for escalation on hotfix KB4056927. It will show you complete setup and expected results. I hope it will help you in your situation.
The fix KB4056927 introduces a new variables yearStartDate and yearEndDate in the class TrvExpTrans method calcKM. This will help you also to understand how the fix works.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (