You’re offline. This is a read only version of the page.
90
Can someone help me identify SUTA/FUTA and Workers Comp by Employee broken out by the different deparments if an employee has multiple(an employee may code part of their time to an expense account as well as part of their time to a project)? What I am trying to balance is the entry that currently posts to my project accounting GL account. Having a SQL statement would be awesome versus clicking different screens in GP to get to the answer. I would take the manual work to start if I can though.
We use project accounting like a work order or job cost to gather the costs (labor, AP, Inventory, etc.) for a particular capital project, then post once the job is completed.
When we post the monthly batches for SUTA/FUTA and workers comp it will post an amount to the GL, but I don't know the amount that I need to split out to the different project(s). The general allocation for overhead in project accounting is not acceptable and we need to balance back for audit purposes.
I have pulled the Timesheet information from the PA30100 file which gives me the labor hours and the dollar amount as well as the project number. So I know what the hours are by employee, I just don't know which one of these employees had SUTA/FUTA or workers comp for that period in order to spread those taxes accordingly.
I also have found SUTA data that balances back to the amount posted to the GL in the UPR30401 table.
Select *
From UPR30401
where posteddt > '2010-09-29'
and srcecode like 'SUTA'
I have spent a couple days reading the net and blogs and it seems like temp tables are used during the creation process so I don't have a table to try and pull the data from?
I have also created a smartlist to verify the amounts by employee id and posted date.
Thank you in advance for any assistance!
*This post is locked for comments
Hi,
If you are just looking for a report that lists how much FUTA/SUTA and Workers Comp by department, I would use the UPR Transaction History and Payroll Tax Liability History. You get the Department, SUTA state and whether it's subject to FUTA from that table. You can also see which Workers Comp code was assigned to that transaction. The FUTA/SUTA rates and wage limits are in the UPR40100 table. The Workers Comp info is in the UPR40700 table. If your report is going to come totally from your payroll, that's where I would go. You mentioned Job Cost. Are you using GPs Project Accounting? If you are trying to determine how much to post to each project, how can you tell what the project was? Is a project a different department? You have discovered the UPR30401 table, be advised that this table holds only the entries that were presented to the General Ledger. That table does NOT hold what the actual JE turned out to be. Getting the information is very doable, but I'm confused as to what exactly you need.
Kind regards,
Leslie
Not sure if either of you got an answer but the SUTA, FUTA and WC amounts are calculated on the fly when you generate the reports. There are no physical values stored in GP tables for you to pull from for a custom report. They use TEMP tables to populate the report and once you close the report these tables are cleared.
Hello Stephen,
Have you resolved this? We would like to build reports for payroll information by employee with FUTA/SUTA broken out as well, but I cannot find the amount per employee stored in any tables.
Thanks for any help on this!
Jean
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (