Quarterly accrual based on employee hire date
SummaryQuarterly accrual based on employee hire date
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 Date||Accrual period Start||Accrual Period end||Accrual Rate|
We have written fast formula which is fetching and calculating the accruals correctly, for the employee who have been hired on '01-Jan' .