How to do the accrual recalculation based on the work schedule change in employee time information?

[Hafeez]

Hello Experts,

We have difference in number of hours accrual posting based on the work schedule of the employee. We have two work schedules called SLYD and SLYH. If the employee is assigned to SLYD work schedule then system should post 160 hours as the accrual per year on the starting of the year (1st Jan). If the employee is assigned to SLYH work scheduled then system should post 190 hours as the accrual per year on the starting of the year (1st Jan). This is working as expected on the starting of the year based on the work schedule assigned to the employee.

We also have a scenario that, we can expect the shuffling of the work schedules to the employees. 

Ex:- on 1st Jan if an employee is assigned to SLYD work schedule then there is chance of changing the work schedule to SLYH on 1st March. Now as per the configuration system is posting 160 hours on 1st Jan and the movement we add an effective dated record on 1st March and if we assign the work schedule as SLYH, then system is triggering the recalculation and updating the accruals as 190 hours and posting on 1st Jan. 

Our expectation is, system should do the proration calculation and post the accruals based on the effective date of the work schedule change. This proration should happen for accrual and also should happen during the termination of the employee.

Sample calculation for Accrual Proration

160/12 = 13.33 hours, 13.33 hours X 2 months = 26.66 hours ----> this is for first two months

190/12 = 15.83 hours, 15.83 hours X 10 months = 158.33 hours  ------> this is for ten months

Total = 26.66 + 158.33 = 184.99 hours.

Sample calculation for Termination Proration

If the Termination date of the employee is 31st March

160/12 = 13.33 hours, 13.33 hours X 2 months = 26.66 hours ----> this is for first two months

190/12 = 15.83 hours, 15.83 hours X 1 months= 15.83 hours  ------> this is for March month

Total = 26.66 + 15.83 = 42.49 hours.

But, in termination scenario system is only looking at the work schedule assigned to the employee on 1st Jan of the year which is SLYD and posting 13.33 hours X 3 months = 39.99 hours.

Please let me know how to achieve these requirements.

Regards,

Abdul

[Volker_Ruof]

Hello Abdul,

usually I don´t give concrete implementation guide links, cause honestly, this is what I expect first before asking in this forum: a thorough reading of the implementation guide, especially the rule functions guide. But this one is indeed a bit hidden. So, you are lucky 😉

Here we go, this is what you need:
Calculate Average Value For Numeric Job Info Field() | SAP Help Portal

And the termination issue should not be one. The rule function has got a calculation period. Choose "accruable period" then only the time till termination is considered.

Best regards

Volker