Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

What SQL table pulls into year end wage table UPR10105./ Error with W-2 state wages not populating correctly

(0) ShareShare
ReportReport
Posted on by

Long story short we had an error in the middle of posting a payroll check for an individual.  The check partially posted to some of the SQL tables but doesn't show up in the employee's check history. The check was removed from UPR30100 so that it could be reentered.  Now they realized that while it didn't show on the employee's check history it did show on the employee summary and subsequently on the payroll tax form 941 report.  I have gone through and cleared out of modified every reference to this check I can find.  It has been removed from UPR30200, UPR30300 and UPR30100.  I have also updated the summary totals in UPR30301 and UPR00900.  His employee summary, form 941 report, and federal wages on the W-2 all now show correctly.  However the state wages still aren't showing correctly on the W-2.  I found out that amount comes from UPR10105 when the year-end wage file is created, but I can't seem to figure out where the system is pulling the information to fill UPR10105 or why it is pulling incorrectly.  If anyone knows what table is used to populate UPR10105, or if anyone has insights into why that amount might be pulling incorrectly I would greatly appreciate it.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    on at
    RE: What SQL table pulls into year end wage table UPR10105./ Error with W-2 state wages not populating correctly

    I figured it out late Friday and forgot to update this.  UPR10105 is filled from the summary data of UPR30301.  Specifically the STBLWGS columns by month for the PAYROLCD of your state taxes.

  • Verified answer
    L Vail Profile Picture
    65,271 on at
    RE: What SQL table pulls into year end wage table UPR10105./ Error with W-2 state wages not populating correctly

    Hi,

    The detail of the state wages is in table UPR30300. Look for your state in the PAYROLCD column. The column UPRTRXAM is the state tax amount, column TXBLWAGS is state taxable wages. This detail is summarized and pulled into the UPR10105.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at
    RE: What SQL table pulls into year end wage table UPR10105./ Error with W-2 state wages not populating correctly

    Still trying to figure what table is used to create UPR10105 when creating a year-end wage file if anyone has any insights or suggestions.  Thanks.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans