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
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
I answered this question, but I don't see where it came up.
I'll check when I get to a real computer
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!
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.
Without the tool you would most likely employ Microsoft to perform a change using SQL.
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!
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156