Friday, October 20, 2006

My Newest Project - An Automated Timecard

Lookie This People - This is the cool sorta stuff you can do with Dynamics SL/Spitfire.

I'm going to create an automated time card using Excel and VBA.

We use HCSS Dispatcher to dispatch Equipment and Employees, and we use MS Project to create a project schedule. So the first thing this time card is going to do is to query the SQL Tables for both applications and create a time card for the day.

Then we're going to route this time card by e-mail using Spitfire to the job foremen.

After the foreman fills in the time card, then he'll send it back to Spitfire. Because of the power of routings in Spitfire, Spitfire will then send the time card to both the Operations Manager and the Project Manager for approval.

After the time card is approved, then we'll use some VBA code to automatically input the timecard information into Solomon for Payroll Processing.

The final bit of VBA Code will then create a daily cost report that details how the crew performed for that day, and whether or not they made money or lost money.

Finally Spitfire will send the Daily Cost Report to the Foreman, Project Manager, Operations Manager, and the Owner for review.

It's amazing how you can use Dynamics, Spitfire, and Office Automation to deliver reports almost instantaneously and automate data input.

Latest Release of Spitfire

Yesterday, I went to lunch with Steve Powers of Spitfire. Besides talking about our shared passion for glass art and Dale Chihuly, we talked about the changes in the newest upgrades to Spitfire.

In the newest release of Spitfire, mail that is sent from Spitfire can now be returned to Spitfire without going through Outlook. This is a vast improvement over cutting and pasting from Outlook, and a much better way to handle e-mail than most other Project Management Software.

Way to go!!!

Corrected Contact Info for Jered Cady of Synergy

Here's a copy of an e-mail I received from Michael Camp.

John,

Hey, checked out your new blog and left a comment. Actually thought the first one didn’t take but it did, so you might want to delete one of them. Also, change Jered’s phone number to 206-859-6505. Thanks!

Michael Camp

Thursday, October 19, 2006

This Blog is Created

Hello Everyone.

My name is John Wheeler, I live in a funny little town by the name of Tacoma, Washington. I'm the Controller at Alpha Development Corporation. I've been a Controller and Consultant for the past decade and a half, and in that time I've run numerous accounting systems.


Synergy Business Solutions

We recently purchased Microsoft Dynamics SL and Spitfire Project Management from Synergy Business Solutions. Synergy http://www.synergybusiness.com/ is a "Winner of the Microsoft Dynamics SL Global Excellence Award for 2005," with offices in Portland, Oregon, and Seattle, Washington.

I chose to use Synergy as my reseller because I have worked with the people from their company on a previous Solomon implementation. I was happy with them during that rollout and Synergy has performed great on my current rollout.

For sales inquiries you can call Jered Cady, President at 206.505.7919 and tell him John Wheeler sent you. It won't get you a discount, but it will help me know who's reading this blog.


Microsoft Dynamics SL

In my opinion, Microsoft Dynamics is the best mid-market accounting system on the market. It is backed by all the brains and talent of Microsoft. Dynamics is highly configurable and runs on a SQL Server Database. Dynamics includes Crystal Reports, FRx, and a Visual Basic Programming Language. Frankly I can't believe that anybody would use anything other than Dynamics.


Spitfire Project Management

The day I walked into Alpha Development over 2 years ago, I wanted to change from the DOS created accounting system they were running to Solomon (now known as Dynamics SL). Unfortunately, changing accounting systems is a huge project and costs a lot of money, so everytime I talked about the change, I was told, "no." And then voila, there was Spitfire.

The company owner is an Engineer, and when he saw Spitfire, he was sold. Spitfire is that rare piece of software that does everything you'd like a program to do. If you've been around computers as long as I have (since the Apple Lisa days), you can remember when you'd say, "Gosh, I wish this program would do this." Well, with Spitfire, it does everything you could ask from a Project Management piece of Software.

Spitfire is absolutely the best of the Project Management Systems out there (and I've used a few). Spitfire is Browser Based Software and it runs in conjuction with Microsoft Dynamics.

For us, Spitfire takes project management information and shares it with stakeholders.


Why this Blog???

Frankly, this blog is to support the accounting community with my advice, anecdotes, and expertise on Microsoft Dynamics SL, Spitfire Project Management System, SQL Server, and Crystal Reports.

I'd love to become a Microsoft MVP. Do you hear that Microsoft??? Besides that, I'd just like to have a place to share my opinions and tips with the world.

So welcome to my little space on the web.

John Wheeler