Absence Accrual calculation with retro changes on hours worked

Summary:

Hi Everyone,

we have a requirement that Current Accruals should be calculated based on previous 2 weeks approved timecard hours and should pick retro changes on Approved hours for 28 days in the past. Its a Incremental accrual plan with Bi-weekly repeating period.

Say our effective date is 10/27, the accrual calculation formula will look back the weeks 10/14 to 10/20 and 10/21 to 10/27 time card approved hours and give the accrual balance based on those hours as of 10/27. say employee got 80 hrs of approved time card hours and given 4 hrs of balance as of 10/27.

Now the Issue is when we move on to next bi weekly period 11/10; employee changes the approved hours worked from 80 to 90 for those 10/14 to 10/27 weeks, and worked 80 hours in the current period.