You’re offline. This is a read only version of the page.
80
Hello -
I am by no means an expert in Dynamics / GP. I'm just a lowly (Java) developer who happens to be the only person in our organization who is familiar with SQL. At present, I've been tasked with finding YTD payroll data for employees. I could calculate it in a query but we want to ensure that it matches exactly what employees receive on their pay stubs. For this and other reasons, I thought it would be cleaner to access it directly from the database as much as possible. If I understand what's stated in this thread correctly, most of that data should be in UPR30200. However, when I view a record in that table, none of the data matches my sample check stub except for the CHEKDATE and AUCTRLCD. I have looked at many of the other UPR tables and searched the 'net (most notably, Victoria Yudin's site) but to no avail thus far.
Questions:
Is UPR30200 the correct table for this data? If not, kindly give me a shove in the right direction. If so, please explain why none of the values match up with the check stub? Might this be due to a misconfiguration?
thanks in advance,
dgg
*This post is locked for comments
Hi Jeff -
Thanks for your response. The five tables you mentioned were among those I had identified as potential sources for the data. It sounds like I'll need to sum the data up myself in order to arrive at YTD numbers. I was hoping to avoid that but there doesn't seem to be another option. Since UPR30100 and UPR30300 have everything I need, it seems those would be the best candidates to use in the summation.
Thanks for the help Jeff - and you too Bill. I do appreciate it.
dgg
Hi dgg,
The Summary payroll tables only store information by month so that may not provide enough of a breakdown as you wish. Therefore, you may need to utilize the payroll historical tables.
Here are tables to review:
--Summary Tables By Month select * from upr00900 --Payroll Federal History select * from UPR00901 --Payroll Tip History Summary by month select * from UPR30301 --Payroll Pay codes,ded codes,ben codes,state tax & local tax --Detail Tables By Transaction select * from UPR30100 --Payroll Federal details select * from UPR30300 --Payroll Pay codes,ded codes,ben codes,state tax & local tax
The other part of that comment should have been that regardless of which Payroll,
You can look into the SmartList and click on Payroll (Canadian Payroll) and there you will find searches of the data that should help you find what you are looking for.
In Smartlist, you can filter, sort by and export to EXCEL almost unlimited variations on the data.
Let us know if this helps.
Just to be really obvious - you are running US Payroll correct - reason is that the data for Canadian payroll is different tables all together.
If US - then I am out for now - if Canadian, come on back and lets see what we can figure out.
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (