Need to calculate DAB amount based on accumulated hours every month
Hi
We have a scenario where employee will accrue hours/days during each payroll based on Original Hire Date, now we would want to use that accrued hours to calculate some amount. This accrual should happen every month no matter of year end.
Example:
Employee works for 176 hrs in a month and he gets 14 hours accrued. And this accrued 14 hours is been used to accrue amount 14 (hours) * 12.5 (hourly rate) = 175.
Next month payroll runs and employee works for 176 hrs and he gets 14 hours accrued. now the amount should be accrued based on previous month accrual hrs and current month accrual hours i.e 14 + 14 = 28. and amount should be accrued as 28 * 12.5 = 350.