Update Hours in Operations
I recently was asked to update both machine and labor hours for a selection of operations for one of our customers. I was able to accomplish this task using the attached file. Within the file, there are comments in red on the ConfigInfo tab that explain how to use the file.
By way of explanation: If you are not making major updates to operations but only want to make limited changes such as labor or machine hours or rates, you do not need to directly update the SLJobRoutes collection. You can instead directly call the PostSaveCurrOperSp method. This method updates the necessary SLJobRoutes fields while simultaneously doing the other work necessary to update operations such as converting hours to ticks and things of that nature.