Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payroll questions

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

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans