Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Not all payroll codes are posting to proper GL accounts

Posted on by 335

Some of my payroll codes are not posting to the proper GL accounts while others are going to the correct accounts. I would assume that I must have something setup incorrectly, but I copied the same format as the accounts that work when setting them up, so I don't understand what the problem might be. Any help would be appreciated.

*This post is locked for comments

  • Melanie Wagner Profile Picture
    Melanie Wagner 335 on at
    RE: Not all payroll codes are posting to proper GL accounts

    This did resolve it. Very time intensive due to the number of accounts we have, but it did solve the issue. It was in GP 2010.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all payroll codes are posting to proper GL accounts

    Melanie -

    Thanks for posting the information.

    What version of GP was this in?  Is it resolved?

    Diann

  • Suggested answer
    Pam Robertson Profile Picture
    Pam Robertson 199 on at
    RE: Not all payroll codes are posting to proper GL accounts

    We just ran into that and Terry Heley said that GP doesn't like to have ALL in the middle.  It reads from left to right, so if you have a specific department, then ALL, then specific pay codes, "we could read it wrong."  Having said that, it has worked in the past for multiple companies, but when we added new departments, those entries are going to our suspense account.  To me, this is a bug.  We're putting in a product suggestion to have this fixed.

    So in the meantime, you could specify each position instead of putting ALL in the position field, and it will work.

  • Melanie Wagner Profile Picture
    Melanie Wagner 335 on at
    RE: Not all payroll codes are posting to proper GL accounts

    That is correct. That is why I am stumped also...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all payroll codes are posting to proper GL accounts

    Melanie,

    Your posting setup looks correct to me.  I can't imagine why it would be posting to the ALL-ALL-ALL "dump" account.  Just to clarify.  The transaction that went to the "dump" account had a department of 000 and a paycode of "CL" and it was for gross wages?

    Terry Blaser

    terry@dynbuilders.com

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Not all payroll codes are posting to proper GL accounts

    Please take a look at your Tools->Setup->Posting->Payroll Accounts and go through all your account setting and make sure everything is setup properly. You can set up  'catch all' posting accounts.

     

  • Melanie Wagner Profile Picture
    Melanie Wagner 335 on at
    RE: Not all payroll codes are posting to proper GL accounts

    I tried to post a picture of my results, but it didn't work. I'll try again here.

     

  • Melanie Wagner Profile Picture
    Melanie Wagner 335 on at
    RE: Not all payroll codes are posting to proper GL accounts

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Not all payroll codes are posting to proper GL accounts

    Melanie,

    Do you have access to SQL?  I would be currious see exactly what is showing in your Payroll Posting Accounts Setup.  If you could execute the following script and send back the results it might help dianose the issue:

                select * from UPR40500

                          where Deprtmnt = '000'

                          and payrolcd in ('CL', 'ESL')

                          and upractyp = 1  --1=Gross Wages

    Thanks,

    Terry Blaser

    Terry@dynbuilders.com

  • Melanie Wagner Profile Picture
    Melanie Wagner 335 on at
    RE: Not all payroll codes are posting to proper GL accounts

    All of my general payroll acconts are working. It is when I setup some bonus accounts and most recently some vacation and sick leave posting accounts that are going to the wrong place. Usually I use dept code of 000 and then have my pay code be CL, ESL, etc. Other times I have the dept code of a different number but the pay code is still CL, ESL, etc.

    In the gross wages posting screen I have it setup as dept 000, position ALL (because no matter the position I want the pay code of CL to be posted to the account I have setup.) I then have the code of CL and the account setup that I want it to post to. When I post the payroll checks however these codes are going to my general "dump" that is setup. It appears a "dump" has to be setup for just this instance where the system cannot figure out where to put something.

    Is this the detail you are looking for?

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans