syExcelReports Table & SQL Server Native Client 10.0 – Thanks Aaron Berquist


While upgrading our GP from GP2010 SP3 to GP2013 SP1, DYNAMICS database upgrade stopped unexpectedly with GP crashing without any information for me to debug.

But it stopped exactly at table syExcelReports and crashed. Without spending anymore time, I just went and checked my ODBC DSN setup, as explained by Aaron Berquist on his blog High Dynamics Range. Expectedly, the ODBC DSN driver was not pointing to SQL Server Native Client 10.0.

For some reason, GP fails to process upgrade further if your DSN driver is NOT native client 10.0 or above.

Those who upgrade your GP to latest version, please check DSN before you start database upgrade using GP Utilities.

VAIDY

Microsoft Dynamics GP 10.0 Mainstream Support Ends on 9th October 2012


Those who are on Microsoft Dynamics GP 10, would want to seriously think about upgrading their product.

Microsoft Dynamics GP Support Blog has posted this morning that Microsoft Dynamics GP 10 Mainstream Support ends on October 9th, 2012.

So be aware of this fact and plan for your upgrade at the earliest.

VAIDY

Dynamics GP 2010 Upgrade Paths


Njevity Blog has got an important piece of information, posted by Melissa Sandrovich, on available Upgrade Paths for Dynamics GP 2010.

The paths are detailed from versions 9.0 till lower versions of GP2010 to it’s current version.

Those who are looking for this information anywhere else, this post would be of immense time saver.

VAIDY

Upgrading 150+ Companies – Now that’s A REAL UPGRADE


Mariano quotes us from Randal Mayer on How to Upgrade 150+ GP Companies.

I have never even imagined more than 15-20 companies, and this advise IS needed for all of us.

And this post also answers a major question: Is Dynamics GP really capable of handling loads and transactions? Now a customer having 150+ companies in Dynamics GP 9.0. And we have already got Dynamics GP 2010 with SQL Server 2008 R2.

That’s a lesson to all who doubt GP’s capability.

VAIDY