Solution Properties
Solution ID:
222924650021959
Last Modified Date:
Mon May 02 23:33:04 UTC 2022
Taxonomy Path:
Category//Setup and configuration
Author:
sageadmin
Where can I find additional formula examples to accrue vacation hours?
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]


Examples of formulas that accrue vacation hours

Vacation Hours Accrual Variations




Formula NameFormulaExplanation of formula
Vacation Hours Accrual 1IF (NEWDATE (Hire Date [PR Employee], 0, 30) < Period End Date [PR Check], .75)This formula compares the employee s hire date to the period end date of the check being entered. It then verifies that the employee s probationary period of 30 days has been completed. If the employee has been employed at least 30 days, the specified .75 hours accrues for the vacation hours pay ID. This formula does not take into account any limits.
Vacation Hours Accrual 2IF (Check Sequence [PR Check] = "First" AND NEWDATE (Hire Date [PR Employee], 0, 60) < Period End Date [PR Check], 1.25)This formula verifies the check sequence to ensure it is the first check of the pay period (a provision for multiple checks). It then compares the employee s hire date to the period end date of the payroll run to see if the employee s probationary period of 60 days has been completed. If the employee has been employed at least 60 days and the entered check is a first sequence check, the specified 1.25 hours accrues for the vacation hours pay ID. This formula does not take into account any limits.
Vacation Hours Accrual 3IF (Check Sequence [PR Check] = "First" AND NEWDATE (Hire Date [PR Employee], 0, 90) < Period End Date [PR Check] AND LTD Vacation Units [Public Formula] < 40, 1.5)This formula verifies the check sequence to ensure it is the first check of the pay period (a provision for multiple checks). It then compares the employee s hire date to the period end date of the payroll run to see if the employee s probationary period of 90 days has been completed. The formula then confirms that the employee s remaining vacation does not exceed 40 hours. The vacation hours earned and vacation hours taken come from the employee pay setup (Setup, Employees, Pays). The YTD Units column for each the V_ACCRU1 and V_ACCRU2 pay IDs is the number used in the calculation. If the employee has been employed at least 90 days, the entered check is a first sequence, and the employee has less than 40 vacation hours remaining, the specified 1.5 hours accrues for the vacation hours pay ID. This formula does not calculate on employees with 40 or more vacation hours remaining.
LTD Vacation UnitsLOOKUP (YTD Units [PR Employee Pay], Employee [PR Check], 5, "V_ACCRU1") - LOOKUP (YTD Units [PR Employee Pay], Employee [PR Check], 5, "V_ACCRU2")This example requires the creation of a formula to determine how many vacation hours the employee has (see the formula example below)0. You must create the remaining vacation hours formula first. In this example, the number 5 represents the Accrual pay type of the vacation hours earned pay ID and the vacation hours taken pay ID. V_ACCRU1 represents the vacation hours earned pay ID and V_ACCRU2 represents the vacation hours taken pay ID
Steps to duplicate
Related Solutions