Forum Stats

  • 3,815,486 Users
  • 2,259,038 Discussions
  • 7,893,134 Comments

Discussions

Quarterly accrual based on employee hire date

User_AR29J
User_AR29J Member Posts: 4 Red Ribbon
edited Oct 31, 2019 12:29AM in Social Groups

Hi Team,

We are trying to achieve one of our client's requirement where in client wants leave accrual to be done quarterly based on employee hire date.

Ex: If any employee hired on 10-Jan-2018, his/ her accrual should run and add 50 hrs to their balance as on 09-Apr-2018 and on the 4th quarter end 150 hours must be added to employee balance. i.e.,

Employee Hire DateAccrual period StartAccrual Period endAccrual Rate
10-Jan-201810-Jan-201809-Apr-201850
10-Apr-201809-Jul-201850
10-Jul-201809-Oct-201850
10-Oct-201809-Jan-2018150

We have written fast formula which is fetching and calculating the accruals correctly, for the employee who have been hired on '01-Jan' .

We are using the repeating time period with sample start date as '01-Jan'. So the further periods are being calculated based on this sample start date.

So the employees who have been hired on different date than 01-Jan, the accrual process is running but not calculating the accruals.

So, we would request your thoughts on this to achieve this requirement.

Thank you very much for your kind suggestions / solutions.

Thanks,

Kavitha

Answers