Is there any process that needs to be ran after changing the Labor/Burden rates in a resource group? How will existing jobs that are already released be affected?
I don’t know a definitive answer… but unscheduling and rescheduling might help pick up the new rates (assuming they don’t get picked up organically).
That is what I was wondering. If they would get picked up automagically or if everything would need to be re-scheduled. That, and if it needs to be rescheduled, is there something in the Conversion Workbench that would assist with it?
Not sure what rescheduling would do. None of the schedule tables have costing data in them.
Actual costs are retrieved at labor entry. The system looks up the labor rate of the specific employee and resource (which may be different than what was spec’ed on the job) at runtime. So if you’ve updated the resource or res group, it should pull the updated rate.
If you wanted to update Job estimates, I believe you have to re-pull details.
2 Likes
To add to what John said, any labor entered before the rate changes will use the old rates and any labor entered after the rate changes will use the new rates, so the WIP on open jobs will not be updated to reflect the new rates automatically. You would need to enter Job Adjustments to update the cost on the job if Finance needs open WIP to update.
1 Like
100% this. It would actually be a bad idea to auto-update past history since jobs can span long time periods if you’re building something complex and actual rates may truly change over that time.
1 Like
I just did this on 1/1 and after the RG change I ran a query for all not completed JobOper records in the resource groups that were changed and updated them in DMT with the template below. The OverrideRates is key.
So LaborDtl records on the job thru 12/31 are at the old rate and from 1/2 on is the new rate.
JobNum AssemblySeq OprSeq OpCode JobOpDtl#JobNum JobOpDtl#AssemblySeq JobOpDtl#OprSeq JobOpDtl#OpDtlSeq JobOpDtl#OverrideRates JobOpDtl#ProdBurRate JobOpDtl#ProdLabRate JobOpDtl#SetupBurRate JobOpDtl#SetupLabRate Plant Company
1 Like