web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / AX2012 R3 - CU8 - Mile...
Finance | Project Operations, Human Resources, ...
Suggested Answer

AX2012 R3 - CU8 - Mileage rates calculation for tax year in GB

(0) ShareShare
ReportReport
Posted on by Christophe BOURNAC 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.

I have the same question (0)
  • Suggested answer
    Michal Krejza Profile Picture
    Michal Krejza on at

    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. 

    KB4056927.docx

    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. 

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at

    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

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at

    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

    www.gov.uk/.../travel-mileage-and-fuel-rates-and-allowances

  • Michal Krejza Profile Picture
    Michal Krejza on at

    Hi Christophe,

    Could you provide an example how the mileage expense has been calculated in your system ?

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at

    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

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at

    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...

  • Michal Krejza Profile Picture
    Michal Krejza on at

    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.

  • Christophe BOURNAC Profile Picture
    Christophe BOURNAC 115 on at

    Hello

    No problem. I add an excel file to this topic

    mileages.xlsx

  • Suggested answer
    Michal Krejza Profile Picture
    Michal Krejza on at

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans