For more information, please refer to this announcement explaining best practices for getting answers to questions.
Prorate shift allowance in payroll based on absence duration.
Summary:
Need guidance on how to prorate shift allowance in payroll based on absence duration.
Content (required):
Hello EveryoneThere is a requirement to sum up the absences taken by an employee in a month and prorate the Shift allowance based on the total absence duration.As an example :
Shift allowance/month - $900
Absence start and end date:- 01-Nov-2021 - 03-Nov-2021 and 20-Nov-2021 - 21-Nov-2021
Total Absence Duration - 5 days
Shift allowance paid for Nov'21 = 900 - 150(5 days allowance) = 750I am able to achieve it using a table value set if there is a single absence record in a month , but it does not work wherever there are multiple absence records.Any guidance or FF sample will be greatly appreciated.