Enhancement to Leave $ Balance Field for Payslip Formats

Description

The existing $ Balance field, which can be displayed within the Payslip Leave Balance component of payslip formats that are created in Maintenance > Document Formats, has been enhanced so that the logic behind how the value in that field is calculated, for leave types that accrue on a first-in-first-out basis, is consistent with the accrued leave cost that is shown on the Accrued Leave Balance report in the Leave module and in the Leave Transaction Details on Payee records in the Payroll module.

That is, the $ Balance field shows the sum of the average accrual rate of the leave multiplied by the number of units accrued per instance of accrual. For example, if 2 hours of leave have been accrued during a single week and the accruals were triggered by pay code X, which has a pay rate of $32.50 per hour, and pay code Y, which has a pay rate of $35.95 per hour, the resulting value would be as follows:

2 x ((32.50 + 35.95)/2) = $68.45

If the following week another 2 hours is accrued and the accrual is triggered by pay code Y and pay code Z, which has a pay rate of $33.00 per hour, the accrual cost for the second week would be:

2 x ((35.95+33.00)/2) = $68.95

Therefore, the combined monetary value of the leave accrued at the end of the second week, assuming no leave had been taken or paid out in the interim, would be as follows:

68.45 + 68.95 = $137.40

Benefits

This enhancement helps prevents confusion when attempting to reconcile payees' queries about the monetary value of their accrued leave that is shown on their payslips.

Configuration

No configuration required.