ytd wage data . . .

(0) Share

Report

Posted on by dgg

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

All responses (5)

Answers (1)

dgg 80 on at

Like (0)

Report

RE: ytd wage data . . .

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
Verified answer

Jeff Rowles 500 on at

Like (0)

Report
RE: ytd wage data . . .

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
dgg 80 on at

Like (0)

Report

RE: ytd wage data . . .

Sorry - yes, US payroll. But Rush is one of my favorite bands - does that get me anything?

kind regards,

dgg
Suggested answer

Bill Campbell 22,647 on at

Like (0)

Report

RE: ytd wage data . . .

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.
Bill Campbell 22,647 on at

Like (0)

Report

RE: ytd wage data . . .

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.