Aaron Berquist Rotating Header Image

May, 2011:

Book Review: Microsoft Dynamics GP 2010 Reporting

Full Disclosure: I was provided a no-charge eBook version for the purposes of this review by the publisher, Packt.

Microsoft Dynamics GP 2010 Reporting by David Duncan and Christopher Liley, is a very good, general purpose book on the reporting options available in Dynamics GP. It focuses on the “Big 5” reporting options for Dynamics GP – SmartList/Excel Reports, Report Writer, SSRS, Analysis Cubes, and Management Reporter. In my opinion, the book does a good job of balancing the “theory” of report creation with the “reality” of execution. That is to say, the book balances explaining “why” and “when” to pick a certain reporting tool with “how” to use the tool you’ve chosen.

If I had to suggest a target audience for the book, my feeling is the following types of people would best benefit:

1. “Power” end-users of Dynamics GP who want the ability to build some basic reports without needing the help of “the IT guy” or a consultant.

2. Beginner-to-Intermediate Dynamics GP professionals who want some guidance on how to choose the right reporting tool for the job, and how to implement some of the basic features of each reporting tool.

By way of compliments, I can say that I picked up a few tips on SmartList/Excel Reports I can likely make use of at my “day job”. Also, given the somewhat dry nature of a technical book on report creation, the authors took enough of a conversational approach to keep things feeling somewhat fresh.

If you’re an advanced Dynamics GP professional or consultant, I’m not sure there is going to by a lot on this book for you. As mentioned above, I see this as a good, general-purpose book to give a flavour for the reporting options available. It’s not a deep-dive, nuts-and-bolts technical book – and depending on who you are, that may not be a bad thing.

Overall, I give the book a 7/10 – broad coverage of subjects, written well for a technical book, and with enough detail to get someone up and running on a reporting tool.

The publisher is running a promotion for the month of May – details of which can be found at http://link.packtpub.com/J9AEn6

Post to Twitter

Troubleshooting Upgrade to Dynamics GP 2010 R2, Part 2

Another error encountered, another error resolved.

During the upgrade of the sample database, TWO, I received an error on the procedure SVC_MailProcessLOG. The error message was:

ERROR [Microsoft][SQL Server Native Client 10.0]TCP Provider: The specified network name is no longer available.

That incredibly helpful error message really means: Perform your GP Utilities run on the SQL Server itself.

I made the mistake of running GP Utilities from one of the client machines, not from the actual SQL Server. It appears that something in that procedure causes an issue when you’re trying to create it from a client machine, over the network, rather than from the local SQL Server itself.

Another good reason to RTFM, I guess :)

Post to Twitter

Troubleshooting Upgrade to GP 2010 R2

I’ve been working on installing the newly released GP 2010 R2 in a “sandbox” environment. I ran in to an issue performing the upgrade and thought I’d share it in case it helps anyone else.

I had the GP 2010 client installed on the same machine I was installing R2 on. Rather than creating a new DSN at install time, I simply renamed the existing DSN used for GP 2010 and moved on to GP Utilities.

However, the upgrade kept crashing at the “syExcelReports” step. The crash report indicated an issue with sqlncli.exe.

After trying a few other things, I finally thought about what the sqlncli.exe message might mean. Going in to the DSN setup (c:\windows\syswow64\odbcad32.exe on my 64-bit machine), I noticed that the original GP 2010 DSN I used was using an old version of the SQL Client.

I created a new DSN using the SQL Native Client 10.0 driver, re-ran the upgrade using that DSN, and voila! Upgrade completed. I hope this tip saves someone else some time and frustration as they work through their install/upgrade of GP2010 R2.

 

Post to Twitter