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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Pro-rated leave calculation on leave type that includes bank holidays

(0) ShareShare
ReportReport
Posted on by 5

I have a question about the way leave is calculated for FTE 1 employees working a partial leave year with a regular mon-fri working pattern.

The leave plan for the user awards 41 days of leave with UK bank holidays deducted in the leave type. The leave year runs from 1/4/2021 to 31/3/2022 and the staff member is employed from 1/9/2021 (i.e. 274 days of the leave year with 4 bank holidays remaining). Leave is accrued at the beginning of the leave period and the amount accrued for the staff member is 26.78 days. The problem is that the only way that I can reach this amount is:

41 * 274/365 – 4 = 26.778 days

So it would seem that the leave calculation has prorated the leave allowance that includes the bank holidays instead of subtracting all bank holidays first and then calculating the proportion of bookable leave remaining. I would expect it to calculate the leave accrual as follows:

(41 - 8) *  274/365 = 24.772 days

If this is correct it's an issue as it skews the amount of leave accrued depending on how many bank holidays have passed when the employee joins.

Can anyone else confirm this?

I have the same question (0)
  • Suggested answer
    cruk-fleming Profile Picture
    5 on at

    Just as an update to this issue:

    This was submitted to Microsoft as a bug but they have refused to adjust the calculation because they believe  that everyone should be "entitled to the same amount of time off regardless of when they are hired". This is nonsense and inconsistent as staff on non inclusive leave plans don't get pro-rated bank holidays for periods where they are not employed.

    I've submitted a proposal to correct this issue so please vote for it if it affects your setup.

    experience.dynamics.com/.../

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…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans