web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / ytd wage data . . .
Microsoft Dynamics GP (Archived)

ytd wage data . . .

(0) ShareShare
ReportReport
Posted on by dgg 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

I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    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.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    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.

  • dgg Profile Picture
    dgg 80 on at

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

    kind regards,

    dgg

  • Verified answer
    Jeff Rowles Profile Picture
    Jeff Rowles 500 on at

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

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

#2
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans