Payroll Paycode reconcile to GL

(0) Share

Report

Posted on by sandipdjadhav

18,306

All,

UPR30401 hold payroll GL distribution by AUCTRLCD AND EMPLOYID. It has field 'PAYROLCD' i don't know why it is blank? This would have make our life easy to reconcile GL Account with paycode.

I don't see any link between UPR30300 and UPR30401.

Can someone help on this issue?

Thanks

Sandip

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

sandipdjadhav 18,306 on at

Like (0)

Report

Any update on this will be highly appreciable.

Thanks

Sandip

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

What is your GP version? Because, I am using GP 10. Here 'PAYROLCD' field is not available from the table UPR30401.

The AUCTRLCD is the link between the tables UPR30300 and UPR30401.

Hope this helps!!!

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

GP2013. Audit Trial code won't help on this. I need to connect with Payrolcd. Even Payroll Account Setup won't help if there is any change it won't track. We have change several accounts for specific paycodes.

Thanks

Sandip

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sandip,

Did you ever figure this out? I am trying to do the same thing and the 'PAYROLCD' field is not being populated in my tables either. I'm on GP 2015 R2.

Julie

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hi Julie,

No. I was not able to do it. I don't know why PAYROLCD is blank.

Thanks Much
sandip jadhav

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Sandip,

I'm not sure I know exactly what you are trying to get out of the system. As far as I can tell the AUCTRLCD is the only link between those two tables. Please provide more details on what you are trying to reconcile to what, there may be a different set of tables involved.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sandip,

Thanks for your response. In the meantime, I've figured out why it's not populated. You have to have the payroll posting settings set to post in detail.

To turn on Post in Detail - Tools > Setup > Posting > Posting

Select Series: Payroll

Select Origin: All

Mark "Post In Detail"

Select to Save

Then for future payroll postings, that field will be populated. But for exisitng postings, you won't have that information.

We had two payroll postings that were posted to the wrong GL accounts. I'm trying to figure out how to create a journal entry to fix this. Without the PAYROLCD field populated, I'm not sure how to do it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Leslie,

I'm having a similar problem as Sandip.

We had two payroll postings that were posted to the wrong GL accounts. I'm trying to figure out how to create a journal entry to fix this. Without the PAYROLCD field populated, I'm not sure how to do it because I can't create a list with the department, position, & payroll code to figure out the correct posting account.

Any ideas?

Thanks,

Julie

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Julie,

From your posts it looks like you identified the cause of the problem. Have you changed your posting to post in detail? Mostly folks post in summary so that users cannot figure out the individual pay. If you posted in detail and then changed the entry to summarize by payroll code, would that give you what you need? The summarization would need to be done in SQL behind the scenes.

Kind regards,

Leslie

Was this reply helpful? Yes No