Missing Timesheets 2.0 for Deltek Vision v 7

I posted this one a week or two ago, with a solution for missing timesheet reporting…
Missing timesheet days for Deltek Vision

I’ll admit that it bothered me. The report wasn’t very good. It didn’t show if an entire timesheet was missing, nor if the total number of hours still met expectations when there were timesheet days missing.

So I upgraded the report. Now you can run this report in Deltek Vision 7.1 through 7.6 (and Deltek Professional Services as well) which will show you missing timesheets for all employees.  The report has the following features:

  1. Run the report for any period of time by entering a start and end date.
  2. Filter the report by any subset of employees if needed.
  3. Show missing timesheets.
  4. Show missing timesheet days.
  5. Show cases where the number of hours is less than the expected amount for any day or timesheet period even if all days have timesheet entries.
  6. The report is deployed to your existing Deltek Vision implementation, cloud or self hosted, inside of your regular standard reporting interface. This means it uses all the same security settings, favorites and saved searches. You can also export this report to PDF, Word or Excel like any other Deltek Vision report!

Price: $2,500 USD
Maintenance: $500/year

Note: This report will adapt to whatever timesheet periods you have established in Deltek Vision.

Here is a quick guide for how it works:

Missing Timesheets Report

SCG Custom ASJC Process: (Adjust Salary Job Cost) – even better

Whenever I’m trying to build on an idea, develop a product or service, or help someone identify the key points about their business that makes them stand out, I aim for finding the 3 strongest attributes.

In the case of the custom ASJC tool I developed, here are the 3 things that make it great:

1. You can run the process for any prior period you need to, and at any point in the processing cycle after timesheets are posted, and it will be correct.
This also means you can correct job cost for prior periods without having to unpost, modify, repost timesheets.  The reason it works this way is because unlike Deltek Vision’s standard ASJC process, our custom process relies on a historical salary grid to get its cost data.

2. You can UNDO it.
This is NOT at all possible with Vision’s standard ASJC process.  The SCG Custom ASJC process does not alter the actual LD (labor data) table like the Vision standard one does.  Instead, our process uses labor adjustments, which can be unposted, deleted, re-written or even modified at any point.

3. It’s easy to use and has a great informative log.
The log (pictured below) shows which employee is getting the cost adjustment, which week it’s for, the assigned cost (initially from time on projects), and the amount of adjustment for that week.  It also shows the file name this happened in; in case you want to crack it open and take a peek.  This is all shown BEFORE the labor adjustments are posted (and after) so you can check for accuracy if you need to.

One other thing… you can tell it which day of the week you consider as your start day, and it handles the rest.

It’s awesome. Contact me for details if you would like to have this installed on your Vision implementation.

Capture

SCG’s Custom Adjust Salaried Job Cost log

ASJC: Adjust Salaried Job Cost – a re-write for Deltek Vision

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:
https://saundersconsultinggroup.com/2011/03/08/deltek-vision-adjust-salaried-job-costing/

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.

Thank you!

Deltek Vision Custom Report: Missing Timesheet Days

Deltek Vision 6.X and 7.X provide you with a standard report for missing timesheets. But that only tells you if someone has filled out an entire timesheet or not. It doesn’t tell you if an employee has gaps in their timesheet.

If you want to know what days an employee has not entered time for at all inside of a timesheet that is not actually missing, then you need this report.

This report shows you days that are either entirely missing, or just haven’t met the allotted Hours Per Day amount.

Missing Timesheet Days Report
Features:

  • Set your own end date
  • Set how many days back you want the report to look
  • Use any PROJECT search to filter the report (you can filter this report as you would any Project report in Vision; using Organization or Profit Center, related Employees, Employee status, or any other attribute of the Projects or Employees infocenters or related infocenters).

Customizations: Contact me to discuss adding features to this report.

Base Price: $1,200 – No maintenance fees.

Screen shot:

scg_missing_timesheet_days