Microsoft Dynamics GP (Archived)

Payroll questions

(0) Share

Report

Posted on by Leng Papio

855

Hi,

Out client asked the following:

Is it possible to inactive or change certain pay codes in all of our 17 companies at one time or do we need to go company by company to make the changes?
I need to either change HPERS and SPERS and make them say SICK rather than personal leave.

Any ideas please?

appreciate all the help... Thanks!

*This post is locked for comments

All responses (7)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: Payroll questions

I changed a pay code from VAC to VACN. What I did was run a query to find all of the tables where the data value 'VAC' appeared. I then ran a second query to find all tables that included the Pay Code field (there are a couple of different column names - the first query tells you what they are). after that I ran an update statements on the first set of tables to change VAC to VACN. I reconciled and then printed some reports, everything was fine. I ran a test payroll using that pay code and everything was fine. BACKUP first if you choose to do this, the solution is SO not supported. I would NOT just change it for 'going forward transactions because you will orphan all the previous transactions and it will be a mess.

Bottom line - completely unsupported, but it always works for me. Be sure to change any reports you have made that filters off of the old pay code.

Kind regards,

Leslie
L Vail 65,271 on at

Like (0)

Report

RE: Payroll questions

I answered this question, but I don't see where it came up.

I'll check when I get to a real computer
Leng Papio 855 on at

Like (0)

Report

RE: Payroll questions

hi L Vail,

not sure with the client if she wants it from the start or just moving forward...

would you know how to do both?

In sql?...

thanks!
L Vail 65,271 on at

Like (0)

Report

RE: Payroll questions

Do you want to change the code as if it were 'SICK' from the beginning? Meaning there would no longer be any trace of HPERS or SPERS.
Alicia Berglund 1,144 on at

Like (0)

Report

RE: Payroll questions

Without the tool you would most likely employ Microsoft to perform a change using SQL.
Leng Papio 855 on at

Like (0)

Report

RE: Payroll questions

thanks Alicia...

they are still in 10.0 because they have a lot of 3rd parties and is finding it difficult to sched the upgrade.

any workaround you can suggest for gp 10.0?

thanks again!
Alicia Berglund 1,144 on at

Like (0)

Report

RE: Payroll questions

What version of GP are you using? If you're on GP 2013 there is a tool included that allows users to change the paycode ID's. If you need to make changes across companies you may want to look into using a SQL script to accomplish this.