We do payroll through Dynamics SL. We charge LABOR FIELD and LABOR SHOP as account categories. In the pjtran table you can see all the charges for a project including LABOR FIELD ,LABOR SHOP, BURDEN DIRECT, etc.
My question is:
How can I get my burden to total along with its corresponding labor category? Is there anything in the data in the Burden row that says whether the amount ties to a LABOR SHOP or LABOR FIELD row?
I've thought about using the trans_date column, but discovered that will only work if an employee only ever charged to FIELD or SHOP. Sometimes they charge to both in the same week.
This is a shot in the dark. I've starred at this issue for hours and I'm thinking it's not possible. But I just wanted to see if anyone has every come across this. Please post if you need clarification.
In response to " Is there anything in the data in the Burden row that says whether the amount ties to a LABOR SHOP or LABOR FIELD row?"
Yes, if you are allocating in Full Detail LABOR SHOP or LABOR FIELD will show in the data1 row in the PJTRAN table in SQL.
Blaine
Technical Support Engineer
**This posting is provided " AS - IS" with no warranties and confers no rights.