Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

ytd wage data . . .

Posted on by 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

  • dgg Profile Picture
    dgg 80 on at
    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 Profile Picture
    Jeff Rowles 500 on at
    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 Profile Picture
    dgg 80 on at
    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 Profile Picture
    Bill Campbell 22,647 on at
    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 Profile Picture
    Bill Campbell 22,647 on at
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans