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!
