Previously, I wrote about Deltek Vision’s process Adjust Salaried Job Costing or ASJC which reconciles the cash paid out to employees with the amount of labor cost assigned to projects. This process when running correctly should “zero out” your Labor Cost Variance account.
You can find that piece here:
However, in order for the standard, built in ASJC process to work in Vision there are some annoying and weird conditions, and I might add; a couple flaws.
1. It has to be run at a certain time during the period, after all timesheets are posted.
2. It has to be synchronized with your pay periods
3. Setting up the job cost rates in Vision in the employees infocenter can be confusing
4. It doesn’t support running the process for previous time periods… like for instance if you’re in July and want to run it for May, unless your employee pay rates have NOT changed at all. In fact, it just doesn’t have any support for handling changing pay rates over time.
5. Besides the weird conditions above, one fundamental flaw is that it actually changes the pay rates assigned to labor in the original transaction tables.
6. Lastly, and most importantly, the most egregious part about Vision’s built in ASJC process, is that you can’t reverse it, undo it, or otherwise correct a bad run and start over!!
So I re-wrote it.
I have a client who does not synchronize their processing with payroll periods and things come in a little more organically during the fiscal period. Kind of like in real life. They still needed some sort of ASJC process for Vision because they have a lot of salaried employees working overtime.
Here are some features of the re-write:
1. It requires a custom grid in the employee infocenter which stores salary history. Most companies already have this, but if yours doesn’t then it’s time to create it, and yes this can be done during installation of my custom ASJC process.
2. Since it uses salary history for rates, you can run my custom ASJC process for any period you want, at any time you want. If you feel like running it for some period back in 2013, no problem.
3. It doesn’t care about when you pay your employees, just how much they are paid per week.
4. It does NOT alter the original data in the LD table, because it uses labor adjustments instead.
5. You can review the changes BEFORE they are applied.
6. Best of all. YOU CAN UNDO IT, REVERSE IT, AND TRY AGAIN !
If you’re interested in implementing the SCG Custom ASJC process on your Vision implementation, let me know.
Excellent response and rewrite