18,265
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
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
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
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.
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
Hi Julie,
No. I was not able to do it. I don't know why PAYROLCD is blank.
Thanks Much
sandip jadhav
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
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
Any update on this will be highly appreciable.
Thanks
Sandip
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (