The Dynamics GP Blogster: Microsoft Dynamics GP 2010 R2 is hot off the press...

The Dynamics GP Blogster: Microsoft Dynamics GP 2010 R2 is hot off the press...: "Microsoft has made GP 2010 R2 available prior to the original launch date of May 1, 2011. The product can be downloaded from CustomerSource ..."

File not found: VBA6.DLL in Microsoft Dynamics GP 9 Visual Basic Editor

Today I started a new project that had a requirement to create a new form in Microsoft Dynamics GP 9 to track additional item attributes.

On a clean install of Windows 7 32-bit, Office 2010, and Microsoft Dynamics GP 9, I received the file not found VBA6.dll error as soon as I'd made my first VBA modification:

I tried a few fixes including downloading and registering a new copy of the VBA6.DLL, but the error persisted.

Then I found a post by Beth Gardner describing the same problem. The resolution involved both a registry edit and the deletion of several files from the Dynamics GP folder.

The solution worked perfectly for me and I expect to see this problem more in the future as it seems to be related directly to an install of Office 2010.

I could not replicate the problem on a clean install of Windows Server 2008 R2 on which I had not installed Office 2010.

Microsoft Responds with Excellent Customer Service

I discovered a problem in the way Dynamics GP Evergreen Contract Lines calculated revenue when 1) billing annually and 2) entering a quantity > 1 on the Contract Line.  Quite simply, it just didn't calculate the Total Amount on the Contact Line or the Invoice Amounts accurately.  This client is running GP 2010.

This was discovered late in the implementation finally being logged as a bug by Microsoft Support just days before data conversion was to be completed for the cutover to production.  Yikes!!  I was in quite a pinch without a good Plan B just days before go live.  After discussing the situation with the Microsoft Field Service Development team they mobilized to produce a fix for this problem in just over 24 hours.  Great response!

They really saved the day to ensure a smooth go live and successful Field Service Series implementation for my client.  A hotfix for this problem is forthcoming from Microsoft.  If you find yourself struggling with this issue when working with Evergreen Contracts in Dynamics GP Contract Administration shoot me a message and I'll help you get by in the meantime.