130
Hello All,
I am trying to work on an export to streamline some of our tax reporting. I am having a little trouble locating some of the information in the database. I cannot find where the employee's state tax QTD or YTD information is stored. Does anyone know where I can find these?
Thanks
David
*This post is locked for comments
Hi,
This one is a little trickier in that the actual number is computed at runtime. What you can find is the whether the wages are 'subject to' SUTA, but since you can change the maximum settings at any time, the wages actually included in that minimum aren't stored in the database. Look in the UPR30300 where the PAYROLCD is the state in question. You won't have set up this PAYROLCD, the system uses that code itself.
Kind regards,
Leslie
Leslie,
The UPR30301 work great for all the state reporting I needed. I just have one last field I am looking for and could use some guidance on it. I am looking for what the tax service we use describes as:
"Unemployment Subject Wages"
Their description:
"Total of subject (to unemployment) wages earned by the employee during the quater as defined by the reporting state (also referred to as "total" or "gross" wages.)
Thank you so much for your help!!!
Hi,
For your state taxable wages, you need to look at the UPR30301 table. It's listed there by month. There isn't anywhere in the system where it's QTD, etc. I think that's just calculated at runtime, but I don't have the code so I don't know for sure.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
