x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 43 subscribers
  • Views 547 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
631
topics
887
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
Eddie Hernandez

Sick and Vacation Accrual only if the employee works a certain amount of hours a month

SUGGESTED
Posted By

Hello, I have a costumer with a very particular workers comp decree established by the local DoA which stated that the hourly employee accrues 6hrs/mo Vacation (144hrs max) and Sick (120hrs  max) only if total hours for the pay period is equal 115 or more.  They might accrue or not depending on how may hours they worked during the month.

I was trying to fiddle with the formula for hourly employees on https://support.na.sage.com/selfservice/viewContent.do?externalId=10246&sliceId=1 but still unable to figure out how to add and compare the worked hours for the period.

Any help would be awesome!

Parents
  • 0
    SUGGESTED

    You can get the hours in the current pay period, but you can't get Month To Date hours unless your pay period happens to be monthly.

    You can access the hours worked in a payroll formula by using the name of the hourly pay level, for example if your hourly pay fields are name Regular and Overtime, then "Regular+Overtime" would give you the total hours for this check.

    So part of your formula could be something like:

    IF(Regular+Overtime>115,6,0)

    That would give 6 hours if Regular+Overtime is greater than 115, if not they would get 0 hours.

    If you're going to be writing payroll formulas, i recommend going into the Help and searching the index for "functions, tax table formulas"

    By the way, you cannot access the hours for salaried employees in a formula.

Reply
  • 0
    SUGGESTED

    You can get the hours in the current pay period, but you can't get Month To Date hours unless your pay period happens to be monthly.

    You can access the hours worked in a payroll formula by using the name of the hourly pay level, for example if your hourly pay fields are name Regular and Overtime, then "Regular+Overtime" would give you the total hours for this check.

    So part of your formula could be something like:

    IF(Regular+Overtime>115,6,0)

    That would give 6 hours if Regular+Overtime is greater than 115, if not they would get 0 hours.

    If you're going to be writing payroll formulas, i recommend going into the Help and searching the index for "functions, tax table formulas"

    By the way, you cannot access the hours for salaried employees in a formula.

Children
No Data

*Community Hub is the new name for Sage City