Annual Leave Plan Based on Hijri Year with Gregorian Dates (Front-Loaded Balance)

Hi all,

I have a requirement where the client wants the Annual Leave plan to be aligned with the Hijri year, but transactions (absence entries) should still be based on Gregorian dates.

Specifically:

• The plan should start on the Gregorian date that corresponds to the 1st day of the Hijri year.
• Each year, the new balance should be front-loaded on the Gregorian date equivalent to the new Hijri year start.

So effectively, the plan cycle is Hijri-based, but the system operates using Gregorian dates.

What we tried:

• Using Plan Term = Anniversary Year with a Fast Formula.
• Storing Hijri year start/end (as Gregorian dates) in a