Not all payroll codes are posting to proper GL accounts

(0) Share

Report

Posted on by Melanie Wagner

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

I have the same question (0)

All responses (11)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

Melanie,

I'd love to help, but I need more information. Most likely you are right, and something isn't set up correctly, but that 's really impossible to troubleshoot without specifics. So, what are you using as criteria for posting? What's failing? What's working?

Kind regards,

leslie

Was this reply helpful? Yes No
Melanie Wagner 335 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Melanie Wagner 335 on at

Like (0)

Report

Was this reply helpful? Yes No
Melanie Wagner 335 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Melanie Wagner 335 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Pam Robertson 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Melanie -

Thanks for posting the information.

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

Diann

Was this reply helpful? Yes No