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 Adjust Salaried Job Cost – advanced module (upgraded)

I recently upgraded the ASJC Log, a report developed to go alongside the custom module built to replace the standard ASJC module in Deltek Vision.  If you’re not sure you completely understand ASJC, go ahead and read this article first: Old ASJC Article

Here is what often baffled me about the standard ASJC:
questions about ASJC

To learn more about my custom ASJC Module, which is basically a more advanced and robust version that does the same and more, and even better, read this article: Deltek Vision ASJC Module (custom)

Yesterday I upgraded the log report so you can see exactly which projects had their costs adjusted. In this example the employee names have been changed to protect sensitive data.  Here is a screenshot:
asjc log

Contact me to add this module to your implementation.

 

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

A basic rule of thumb to consider when looking at business automation

I’ve just kicked off a rather large project with a well established engineering firm based out of Ohio.

In reviewing their business processes and the day to day operations of some of their accounting and project management functions, I have come up with a good rule of thumb for looking for inefficiencies in any business using Deltek Vision.

Here it is:

Anything you’re using excel for right now, should probably be looked at as a process that needs to be properly automated.

I’ve seen lots of companies taking data out of Vision, putting it in excel so they can sort and manipulate it, perform calculations and generate reports.

The problem with doing this is… just off the top of my head:

1. how do you know you did it right? Who is vetting your work?

2. how do you know you just did it exactly the same way you did it last time?

3. did it take you longer than 1 minute? If it did, that was too long.

4. are you trying to do calculations that your ERP platform is supposed to be able to do? examples: overhead allocation, revenue generation, WIP, AR aging, Payroll or other journal entry “adjustments”, “truing up the accounts” etc. etc. If so, then you’ve wasted money and time on a platform that is not living up to expectations, and time being wasted on work arounds.

5. Version control

etc.

Can you think of more reasons to not use excel? Go ahead and leave comments… or drop me a line.

 

imgres

CREDIT CARD TRANSACTION IMPORT AUTOMATION – PART 3

Ok I’ve made a lot of progress over the past two weeks. This is quite a complex project actually… but it’s about finished.

The final results look basically like this:

1. use SSIS (Sql Server Integration Services) to grab the csv files from designated directory and import them into a raw data table.

2. move any transactions from raw import data to the processing table… exclude any transactions that have already been imported.

3. using some data transformations in the form of user defined functions (UDF), make the data look like expense detail transactions

4. insert the expense detail transactions into the expense reports for the corresponding employees

5. allow employees to edit their expense transaction details in their pre-populated expense report

6. show the entirety of credit card expense transactions in a report… that shows the imported data, next to the matching expense detail records in Vision, allowing employees to accurately fill out details on their expenses, and make sure that everything has been accounted for.

7. for the payment to the credit card company, assign the cash disbursement to the different project, phase and tasks reflected in the expense detail transactions so that projects show the cash out for those expenses.

So I’ve completed everything except step 7, which I will complete over the next day or two.

Some really cool things this does:
– puts the CSV files in an archive folder and assigns a unique, logical name to them so you don’t have to worry about losing raw data history

– allows you to compare imported data from the CSV file to the actual data in expense reports by employee and expense report

– allows you to trace any imported transaction back to the actual CSV file it came from… it shows you the file name on the report

– reconciles the amounts imported vs. the amounts in the employee’s expense report so you can make sure you didn’t miss anything

– shows data that was imported into the processing section, but didn’t actually make it into an employee expense report

In a couple weeks I will provide more details on how it actually works with some screen shots of the results.

In the mean time, here is a snapshot of the entire process looked up wrapped up in an elegant diagram in SSIS. Of course, this doesn’t show any details or code… just the big picture logic of it. It’s interesting all the same.

Have an excellent day!

I’ll be at Deltek Insight in a couple weeks, and will be teaching a break out session:
PS-80 Putting Data in the Right Place

If you happen to be at Insight feel free to come say “hello” and give me some feedback on my blog!

Cheers!

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.