Below explains how to configure the system to calculate overtime (OT) based on a monthly rate that is prorated annually using your own custom values. To enable OT hours calculation by month:
Go to parameter setup, control.
Tick the checkbox 'Get hours per year from monthly OT hours table'.
Go to housekeeping, setup, table maintenance, and the monthly OT table.
Enter the number of OT hours for each month (e.g., 25 hours per month).
Calculation example:
Assume the following:
Max OT = 2,250.00
Hours Worked per Year = 25 hours/month × 12 months = 300 hours
OT Rate Calculations:
1.0x OT:
(2,250×12) ÷ 300(2,250 × 12) ÷ 300(2,250×12) ÷ 300 = 901.5x OT:
90 × 1.5 = 135.002.0x OT:
90 × 2.0 = 180.00
To apply the new rate immediately:
If you need the new rate to be applied within the current month:
Go to the Working Hours Table.
Manually update the "Hours Per Year" value (e.g., replace 2340 with 300).
Recalculate Normal Pay to apply the updated OT rate.
Notes:
Changes made within the current month will not immediately reflect in the OT calculation.
You must perform a month-end process for the updated values to take effect in the Hours Per Year (OT) rate.