Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Payroll questions

Posted on by 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

  • L Vail Profile Picture
    L Vail 65,271 on at
    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 Profile Picture
    L Vail 65,271 on at
    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 Profile Picture
    Leng Papio 855 on at
    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 Profile Picture
    L Vail 65,271 on at
    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 Profile Picture
    Alicia Berglund 1,144 on at
    RE: Payroll questions

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

  • Leng Papio Profile Picture
    Leng Papio 855 on at
    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 Profile Picture
    Alicia Berglund 1,144 on at
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,232 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans