Update Creditor Addresses From CSV To Work Around An Integration Manager Bug

Microsoft Dynamics GPI was doing some work for a client recently where we were loading lists of new creditors into Microsoft Dynamics GP from CSV files via Integration Manager. There is, however, a bug in IM 10 where it adds extra zeros to the phone and fax number fields of both creditors and debtors. These extra characters are, rather bizarrely, not always at the end but can be interspersed in the phone number.

The easiest work around was to put together a SQL script for loading the phone and fax numbers from CSV file which I did while on site which updated only a single address on the PM Creditor Master (PM00200) and PM Address Master (PM00300) tables.

Continue reading “Update Creditor Addresses From CSV To Work Around An Integration Manager Bug”

Support Debugging Tool Build 16 released

Microsoft Dynamics GPDavid Musgrave has released build 16 of his Support Debugging Tool. Full details of the changes are available on the Developing for Microsoft Dynamics GP blog.

There are two updates available;

VAT 100 Is Missing

Microsoft Dynamics GPI ran into an issue recently when installing Microsoft Dynamics GP 2010 R2 where the VAT Return was not available. I was configuring the system in preparation for training a new client and was running through the Company options (Microsoft Dynamics GP menu » Tools » Routines » Company » Company » Options button) where I was sure the Enable VAT 100 option was but in this case wasn’t;

Company Options - No Enable VAT 100 Option

Continue reading “VAT 100 Is Missing”

4th Dynamics Certification Gained: Managing Microsoft Dynamics Implementations

Microsoft Dynamics GPI’ve been a bit quiet again this week posting wise, but this was because I was preparing for a Microsoft Certification exam yesterday.

Fortunately, I passed and am now the holder of a Managing Microsoft Dynamics Implementation certification along side the three Dynamics GP certs I already had; GP 10 Installation & Configuration, GP 10 Financials and GP 2010 Inventory & Order Processing.

I’ve taken a look at the Certification Planner on Microsoft Learning to see how far I am from an MCITP in Installation & Configuration for Microsoft Dynamics GP. I think I’m one certification away but it’s slightly hard to tell as the planner hasn’t been updated with the GP 2010 exams.

Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2

Microsoft Dynamics GPI did a bit of searching and couldn’t find a specific declaration of the upgrade path from Microsoft Dynamics GP 9 SP3 to Microsoft Dynamics GP 2010 R2.

After reading around and trying to work out the correct path, I decided the likely upgrade path would be GP 9 SP3 > GP 10 SP5 > GP 2010 R2, but I would try GP 9 SP3 > GP 2010 R2 and see if it would work (although I was extremely skeptical) as this would save some time on the upgrades if it was possible. Continue reading “Microsoft Dynamics GP 9 SP3 Upgrade Path To 2010 R2”

Changing The eConnect Password In Microsoft Dynamics GP 10

Microsoft Dynamics GPWhen we install Microsoft Dynamics eConnect 10 we also do so using a specially created Windows Domain user, DynamicsGPUser, which has the password policy disabled so the password never changes.

It turns out that despite this user only being used by the eConnect service, some client’s still prefer to change the password occasionally. Changing the password is a relatively simple thing to do, so long as you’re aware that the password is stored in two places. Continue reading “Changing The eConnect Password In Microsoft Dynamics GP 10”

Earlier Version of Dynamics.dic Than Installed

Microsoft Dynamics GPI did a test upgrade for a client recently (yes, I’ve been doing a few of these) so they could make sure everything still works and allow them to check out some of the new features.

I got this error message forwarded to me by one of the clients after he tried to login to do some testing;

You are using an earlier version of Dynamics.dic than the one that

Continue reading “Earlier Version of Dynamics.dic Than Installed”

Automate Login To Microsoft Dynamics GP 10

Microsoft Dynamics GPClients who have upgraded to Microsoft Dynamics GP 2010 can use the new remember user and password functionality, but what about those who have not yet upgraded?

Well, in Microsoft Dynamics GP 10, and before, you can use a login macro to automate the login process. A macro can be created by pressing Alt + F8 on the login screen and following the normal login process before pressing Alt + F8 again to stop recording. Continue reading “Automate Login To Microsoft Dynamics GP 10”

Missing Data Source When Installing Microsoft Dynamics GP 2010

Microsoft Dynamics GPI have recently been upgrading an existing client to Microsoft Dynamics GP 2010 R2 from GP 10 SP1 on their test system. As they have lagged somewhat on versions I needed to upgrade them to GP 10 SP5 before then upgrading them to GP 2010 R2.

The databases were also being moved from a server running Microsoft SQL Server 2000 to one running SQL Server 2008; I would have preferred to move them to SQL Server 2008 R2 but due to some other business critical software to be installed on the same server, it needed to be SQL Server 2008 R1. Continue reading “Missing Data Source When Installing Microsoft Dynamics GP 2010”

Support Debugging Tool Build 15 Update Released

Microsoft Dynamics GPDavid Musgrave has released an update to build 15 of his Support Debugging Tool. Full details of the changes are available on the Developing for Microsoft Dynamics GP blog.

There are two updates available;