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