Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Incorrect Paycode Setup
Microsoft Dynamics GP (Archived)

Incorrect Paycode Setup

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi!

One of our clients recently set up a paycode with Paycode Type as Hourly when they meant to set it up as Sick.

They already have history applied to this paycode so we cannot just delete it.

Does anyone know a way to change this in SQL? Or is there a way to create a new code with the correct settings and run a combiner tool?

There's also the issue that their sick time tracking is off so it will need to be adjusted to the correct amount. Any ideas?

Thanks,

RM82

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Incorrect Paycode Setup

    I wasn't quite sure what to answer when reading this question.. but there is no tools (not even in the PSTL) that will help you fix this mistake..

    As Leslie suggested, the best way is probably to create a new paycode and then proceed with manual adjustments between the codes.. I wouldn't play with the SQL values, as there are a lot of table/fields involved.

    You may want to check the import/export function of the PR/HR module.. In our case it's available for the Canadian Payroll, but it may be available to the US Payroll too..

    Microsoft Dynamics GP menu >> Tools >> Utilities >> Payroll-Canada >> Import and Export

    One is called Paycode Data and lists all the historical Paycode values for all employees.. Maybe there is an avenue of altering the data this way and then re-import the changed data.

    Make sure to test this out in a TEST company before applying to LIVE data.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Incorrect Paycode Setup

    Hi,

    I've been thinking on how to address this and I think the safest thing to start with is to set up a proper pay code for sick and base it on the main hourly wage code. You could then run manual adjustment entries to back the amount out of the improper code and put it in the correct code. I know the Utilities have a Pay Code Modifier, but I don't think they have a pay code combiner. You could also void all of the paychecks entered with the wrong code and then reinter them using the correct code. Does anyone else have any better ideas? I'm trying to stay away from SQL because there are so many tables involvec

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Incorrect Paycode Setup

    Does no one have an answer for 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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans