web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payroll questions
Microsoft Dynamics GP (Archived)

Payroll questions

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Alicia Berglund Profile Picture
    Alicia Berglund 1,144 on at

    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.

  • Leng Papio Profile Picture
    Leng Papio 855 on at

    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 Profile Picture
    Alicia Berglund 1,144 on at

    Without the tool you would most likely employ Microsoft to perform a change using SQL.

  • L Vail Profile Picture
    L Vail 65,271 on at

    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.

  • Leng Papio Profile Picture
    Leng Papio 855 on at

    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 Profile Picture
    L Vail 65,271 on at

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

    I'll check when I get to a real computer

  • L Vail Profile Picture
    L Vail 65,271 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans