Dynamics Community Forum Thread Details

Mass assigning of new pay codes using the employee rates

With employers paying employees who are not working due to the COVID-19 issue - we need to setup new payroll codes for hourly, and salary people so they can track how much payroll is going out. I have been setting up the codes as a Holiday type based on HOUR/REG/SAL - whichever applies, but the only way to get the employee updated that I have found is to go into each one and assign it. If I leave the setup blank because of differences in rates, then adding to the employee class is useless because I still have to go into each employee and change their rates.

Is there a way to do this that's easier? I have over 40 companies coming at me with the same request and they need this now!

Categories:

Microsoft Dynamics GP

Hi Deborah, I think this is a great question and issue that many may run into for their business.

A few suggestion that come to mind around this might be the following:

Of course if we assign it to the employees, then change the main pay code rate, it would roll it down to all based on pay codes, but in this example, I do not think we are going to change the main pay code rate at this point for the based on pay code.

If the customer has Integration Manger or SmartConnect, you could use it to update pay rate information.
I have also seen customers use the good old MACRO driven tool to whip through their employees and change the pay rate based on an excel sheet they have created of the changes.
I hate to go this route, but for time sake it may be easier, if you roll it down with classes, then you can update the rate with scripts.

Here is a sample script, everyone's system is different and this is only changing the main pay code table so 3rd parties are not coming into play but some guides you can use

This script will update the HOL code based on the HOUR rate as it is today.

update a set a.PAYRTAMT=b.PAYRTAMT from UPR00400 a inner join UPR00400 b on
a.EMPLOYID = b.EMPLOYID
where
a.PAYRCORD = 'HOL'
and b.PAYRCORD = 'HOUR'
and a.EMPLOYID = b. EMPLOYID

This is just put it there as it is common with based on rates for OT and DT if you need to update the based on rate field for anything

Update a
Set a.bsdonrte = b.payrtamt from upr00400 a inner join upr00400 b on
a.employid=b.employid and a.BSPAYRCD=b.PAYRCORD

Thanks

Terry Heley
Microsoft

Quick Links

Leaderboard