HR with Payroll Accrual Calculation for GP

[tklinnert]

What is the calculation that is used when accruing vacation time in Microsoft
Dynamics 10.00.0959 (HR with Payroll)?

Thanks!

Tara

[Cheryl Waswick]

Hi Tara,

Thank you for writing to Newsgroups today. My name is Cheryl and I will be
responding to you today. I apologize for the delay in your response.

What is the calculation that is used when accruing vacation time in
Microsoft Dynamics 10.00.0959 (HR with Payroll)?

---------------------------------------------------------------
The answer to this question will vary depending on how you have the
accruals set up, so I will list a few different scenarios below and you can
determine which one fits your situation:

Please go to Microsoft Dynamics GP/Tools/Setup/Human
Resources/Attendance/Setup and see if your Accrue type is set to HR or
payroll:

1. HR - If you are accruing through HR, then you would have set up the
accrual yourself and assigned the accrual code to the employee. The
accrual set up is found under Microsoft Dynamics GP/Tools/Setup/Human
Resources/Attendance/Accruals. The accrual will then be based on however
you set up the accrual code.

2. Payroll - If you are still accruing on the payroll side, you can go to
Cards/Payroll/Employee/ Vac/Sick Tab and here you have a choice between
Hours Worked or Set Hours. The accruals will look at the paycodes that
have the boxes mared to accrue vacation and sick time on. Then you need to
indicate an Hours Per Year amount and this calculation will be used:

Hrs Worked x (vacation or sick time hours per year/work hours per year) =
Hours to accrue.

I hope this information is helpful to you.

Thank you,
Cheryl Waswick
Microsoft Support

[tklinnert]

Hi Cheryl,

Thanks for your reply. Here is an example on what is happening and what I
have my settings set to:

Below is an example of one employee that is calculating “incorrectly”. He
should have 12 hours of vacation but it’s only calculating 10. The only
difference that was changed is the Accrual Schedule Setup Window was the
Seniority field; it used to say 0, 61, 121, 181, and 241.

So we changed it in the test company to be 0, 60,120,181,240. That seemed
to do the trick and it calculated the vacation correctly.

However, what is the calculation behind the scenes? I see you put the one
for Payroll but not HR.

The reason why I ask is because the employee should not get the next level
of vacation until there 61st month but it seems like the setup is kind of
deceiving.

Employee Maintenance
Hire Date 9/28/98
Adjusted Hire Date 9/28/98

Attendance Setup
Accrue Type: Human Resources
Seniority based on: Months
Current Year: 2008
Last Day Accrued: 5/28/08

Employee Attendance Maintenance
Time Code: Hourly Vacation
Accrual Schedule: CVAC80
Seniority Date: 7/1/98
Next Accrual Date: 6/1/08

Accrual Schedule Setup
Schedule: CVAC80
Seniority, Accrual, Description, Accrue By, Amount
0, C1VC80, Vacation Step 1, Pay Period, 8.00
60, C2VC80, Vacation Step 2, Pay Period, 10.00
120, C3VC80, Vacation Step 3, Pay Period, 12.00
180, C4VC80, Vacation Step 4, Pay Period, 14.00
240, C5VC80, Vacation Step 5, Pay Period, 16.00

What is the calculation that is used to determine which seniority level is
taken for the amount? It appears to only calculate 10 because the seniority
month is July and accruals were ran in May. I tried seeing what the
calculation was by capturing it in a dexsql log but it showed the stored
procedure that was being called.

Thanks!

[tklinnert]