New Partnership for Deltek Vision and Deltek Professional Services consulting

I am excited to announce the official launch of Version X Solutions!

Version X Solutions is a new partnership that brings together a combined 30 years of Deltek Vision knowledge and experience under one umbrella.

We offer a wide and practical range of products and services including custom modules, custom reports, and even a cloud hosting service.

We’ve put together the beginnings of an inventory, and will continue to add to it as we come up with new ideas and do more interesting work for clients. If you have an extension we need, we’d love to hear about it!

Of course we still offer hourly consulting for nebulous or “figure it out as we go” projects.

You can read more about us and our current offering here.

What does this mean for existing customers?

Our new partnership will not adversely affect the existing relationships I have built with you over the years.

You will continue to get the same great friendly, responsive and most importantly, knowledgeable consulting services you have come to rely on from me.

Thank you for your continued business and I look forward to working with you in the near future.

From now on, please refer to the Version X Solutions site for information about products and services offered.

 

 

 

Deltek Vision: Understanding Backlog

Recently I’ve been involved with stabilizing a Deltek Vision implementation for a client in NYC. By “stabilization” I mean getting to the point where we can print out an income statement and balance sheet and they make sense, seem to represent a picture of what’s really going on in the firm. For a while there things were out of adjustment to put it mildly, and now things are back in alignment.

However, there was this one annoying thing that came up… it’s called backlog. It’s a number that appears on the Firm Metrics report under reporting/executive/Firm Metrics. The backlog number in our case was something like 967 Million Dollars… for a firm that does about 30M in revenue… seemed kinda high right?

So I went about understanding exactly what is “backlog” according to Deltek Vision, how is it calculated, and what to do if it just doesn’t seem like it’s right?

Here’s what I found out in two parts:

1. Backlog is defined as Compensation – JTD Revenue
a. This number ignores project status… so making projects dormant does not remove them from the backlog calculation.
b. This only applies to regular projects (not overhead or promo projects).
c. The number can be negative as well as positive.

2. To clean it up you need to align the JTD Revenue number with the Compensation number, but take into consideration what you’ve got going on in your billing terms.

In order to both clean up this number AND keep it in synch with something like reality, I wrote a stored procedure which adjusts a project’s compensation when either of two things happen:
1. billing terms get changed
2. status is changed from Active to Inactive or Dormant

For this particular client, most of their projects are fixed fee. This means the stored procedure needs to take into account the different types of fee billing possibilities, as well as take into account unit billing or cost plus (time and materials) projects. Since there are hundreds and hundreds of projects in this particular Vision database, it didn’t make sense for the client’s staff to go through every project and check the Fee amount, then enter that into compensation. It also doesn’t make sense for them to maintain that field manually on an ongoing basis.  Things happen fast in NYC. Automation is key.

What’s more, many of their projects have phases with their own fee amounts, as well as a fee table (at the top level) with the checkbox “enable posting by billing phase” checked. So here is what this nifty little stored procedure does:

1. For fee projects (or phases or tasks), it sets the compensation value at each phase (or task) to what is set in billing terms.
2. For any other kind of project, it sets compensation to JTD Revenue (unless the user wants to enter a different value, then the adjuster ignores it)
3. Unless the project has been made inactive or dormant, in which case it sets the compensation value equal to JTD Revenue… because it really shouldn’t be counted in backlog.

Sorry I don’t have any good pictures of the Deltek Vision interface for this one… there wasn’t really a good reason for it.  Instead, here’s a picture of my daughter and I on a recent trip to REI.

20150607_125602

SCG – Custom Tools for Deltek Vision – in beta

What is the “Reversal Tool” built by Saunders Consulting Group for Deltek Vision?  (versions 7.x)

Good morning!

I just wanted to let you know about another little gem that has come out of a pretty extensive Vision stabilization project I’ve been working on. This particular firm had a couple years’ worth of accounting transactions they needed to correct because of incorrect entries, use of general ledger accounts or other issues.  Since the idea of un-posting and re-posting all these entries (in order to re-class items) or even generating re-classing entries for each file is rather daunting… I developed a very useful tool to help us through the process. It’s called at the moment the “reversal tool”.

What does it do? It allows you to:
1. See a list of posted files for any period. (currently only journal entries or cash disbursements)
2. Choose from the list which ones you want to “reverse”
3. Click a workflow button and autogenerate reversing files (journal entries or cash disbursements) for those posted files.

Why is this useful?

Rather than just unposting files (which has its own merit) sometimes it’s better to leave a transaction trail of “what happened” and add additional entries to correct errors that were made.  This is the whole idea behind journal entries in the first place. Thus, the reversal tool allows you to “reverse” any Deltek Vision standard journal entry or cash disbursement you’ve posted, by generating a matching file which reverses the debits and credits to the same accounts. This allows you to leave the original file there in case you need to refer back to it.

Some of the cool features:
1. You don’t have to remember any file name, period or posting sequence… it provides you with a list of what’s been posted

2. It re-creates the file if the file was not archived… (What?  It re-creates the file?  Yes… it does.) This means it works for recurring transactions where Vision doesn’t actually store each file. (annoying)

3. It’s easy peazy, and of course, has a good log to show you what you’ve already done.

Interested in providing this power tool to your accounting department using Deltek Vision?

Get in touch.  I’d love to hear from you.  See screen shot below to see an example in action… as always names have been blocked out to protect the guilty.

Looking forward to hearing from you soon!

SCG_reversal_tool

Some pictures from Hong Kong

Over a year ago (from June through December of 2010) I spent a few months in Hong Kong on a project.  While there I upgraded a firm from Vision 5.1 to 6.1, restructured their entire WBS (including legacy data) and trained their accounting department on the new methods of using Vision with a proper work breakdown structure. I also built a custom app in MS Access to make setting up projects and project budgets easier.

However, while there it was not all work.  I did have some time to take some great pictures… since I have now moved my site over to wordpress’ CMS and was going through all my posts, I figured I should put up some pictures of Hong Kong since it’s such a visually impactful city.  So here are some photos for you to browse.