Hello Can someone let me know what tables feed the State Wage and Hour report. If there was a paycheck with no state tax withheld, would the wages be reflected on the report?
Thank you
—————————— Mary Mallazzo Fromkin Brothers Edison NJ ——————————
Tom Franz, CPP
Member
October 14, 2019 at 11:56 AM
Hi ,
I’m pretty sure it’s the UPR30300 & UPR30301 tables. And yes, if you have taxable wages with no state tax withheld, it will still show up on the report.
Hope this helps!?
—————————— Tom Franz, CPP (217) 689-4658 – tfranz@integrity-data.com Director of Client Services Integrity Data Lincoln IL —————————— ——————————————-
Hello What I found out is the report uses the UPR30300 table.Ā If there is no state tax record in the table for that check (field PAYROLCD = state code) the check data will not be reflected on the report. To correct I increased the txblwags fieldĀ on another check by the missing amount. Now the report reflects that state wages properly. I am sure I will have to follow up this change at year end.
Thanks!
—————————— Mary Mallazzo Fromkin Brothers Edison NJ —————————— ——————————————-
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for peopleĀ that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!