Payroll Proration

Hi,

  We have a requirement as explained in the below example :

Create a Grade rate Table: XX_GRADE_RATE_A

                                            XX_GRADE_RATE_B

In XX_GRADE_RATE_A, the Grade 16 has value 10000

In XX_GRADE_RATE_B, the Grade 17 has value 15000

Here the requirement is If an employee grade is changed (due to promotion) from 16 to 17 on 20th May, so from 01 to 19 the value should be picked from XX_GRADE_RATE_A and from 20th to 31st, the value should be picked from XX_GRADE_RATE_B.

Currently, the proration picks only from XX_GRADE_RATE_A.

How we can handle the above scenario. Any advice or guidance on this matter would be greatly appreciated.