Mission MB3-700 Accomplished (Microsoft Dynamics GP 2013 – Installation & Configuration)


It’s been more than 4 years since I had taken any competitive examination, be it Microsoft Dynamics GP or anything else. I felt like being outrageously stagnant for my stature and decided to accomplish Mission MB3-700; Microsoft Dynamics GP 2013 Installation & Configuration.

I had to solely rely on my implementation experience and some user manuals, especially for Web Client. Having done a test drive of Web Client couple of weeks back did help me to bigger extent. But that was not enough surely.

After a week of extensive preparation outside my work hours, I can proudly declare that I have accomplished my mission. MB3-700 is conquered.

I am now a proud Microsoft Dynamics GP 2013 Installation & Configuration Specialist.

It’s only a beginning and there is certainly more to conquer. I sincerely believe I will.



Book Review: Microsoft Dynamics GP 2013 Implementation – Victoria Yudin

Over the past year, I got the privilege of being a reviewer of books written by Dynamics GP Experts/MVPs. I wished writing about these books once they got published, but it never happened till now. Here we go.

To begin with, this post is my views of an all important book:

Microsoft Dynamics GP 2013 Implementation


This book is written by Victoria Yudin, founder of Flexible Solutions, a GP expert and an MVP (an award that she holds on to for past 9 consecutive years). She’s been an ultimate inspiration to entire GP community and it simply makes sense to buy this book the moment you realise that it’s been written by her.

In addition to that, what makes this book so valuable is the content without doubt and the way implementation concepts are structured and explained. Following is the way the entire book is structured:

  • Chapter 1: Application Structure & Licensing
  • Chapter 2: Planning – Business Requirements
  • Chapter 3: Planning – Dynamics GP System
  • Chapter 4: Planning – Infrastructure
  • Chapter 5: Installation of SQL Server, Dynamics GP and Integration Manager
  • Chapter 6: System and Company Setup
  • Chapter 7: Module Setup – General Ledger, Bank Reconciliation, Payables and Receivables
  • Chapter 8: Module Setup – Inventory, SOP and POP
  • Chapter 9: Populating Initial Data
  • Chapter 10: Training, Tools and Next Steps
  • Appendix: General Ledger Account Categories

Chapter 1 discusses in detail about application structure and licensing of GP. A lot has been changed with GP 2013 in terms of licensing. Microsoft has moved some of the important modules to respective original developers. You may not know that from this book, but you would completely understand how new Perpetual Licensing now work and how to plan your requirements (with regards to modules) in advance. 

Chapters 2 – 4 discusses in detail about how to PLAN your implementation; from visualising your requirements to the infrastructure that you would require.

Chapter 5 discuss in detail about how to install all applications required for your ERP environment, from the database that is SQL Server till the tool to integrate your initial data, that is Integration Manager.

By the time we finish reading first 5 chapters, purpose of this entire book is almost realised. 3 chapters are dedicated only to discuss Planning your implementation and that, in my opinion, is what matters in any implementation. You know your requirements very well and you have a finalised plan, you are 75% done with your implementation already.

Chapters 6 – 8 discusses in detail about how to setup and configure your GP with all core modules’ (System, Company, GL, BR, RM, PM, IV, SOP, POP) setup covered. Though, each ERP implementation is different depending on specific business requirements, concept of how and where to setup what remains same throughout.

Chapter 9 discuss about how to populate initial data onto your new GP environment. What amount of data and for what modules, depend on your own business requirements. But what is covered in this book is more than enough to give you the confident start to your new ERP. Integration of core masters (GL, Customers, Vendors & Items) and transactions (GL, RM, PM & IV) is explained.

Chapter 10 explains and emphasise the importance of otherwise mute topic; Training. I am not sure how many implementation team out there give importance to training the users. My mentors used to tell me; you win an implementation only when you win the customer and you win your customer only when they get comfortable and confident about their new ERP. Now catch here is, you may not necessarily agree to what is discussed in this chapter, simply because there is no hard and fast rule on how to train users. But having been in this industry for more than 20 years, met lot of customers and done many implementations, Victoria’s thoughts will surely add value to what you already know.

This book is an excellent reference material for those who are going to be part of a GP 2013 implementation. Go for it. Click on the book logo (or the link given just above that logo) to buy this book from Packt Publications.

As a totally pleasant coincidence, Ian Grieve has written his review about this book on his blog, AzureCurve. And I am in total agreement with his views.

To the author, Victoria Yudin: You have been an inspiration and a mentor to so many of us. A book from you is always going to be wealth of information. I feel privileged and proud to be one of the reviewers of this book. Thanks for constantly inspiring me to continue with what I do.


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.


Upgrade Paths to Microsoft Dynamics GP 2013

Microsoft Dynamics GP Support & Services blog has given the two direct upgrade paths, in case you are looking for: Upgrade Paths to Microsoft Dynamics GP 2013!

Quite crucial information that we must remember.


13 Common ERP Mistakes You Should Avoid

Over at ERP Software Blog, MIBAR.net has shared an article from ITWorld.com about 13 Common ERP Mistakes that we should avoid.

It’s indeed a comprehensive list.

Below are the points, which are elaborated in that article:

  1. Poor Planning
  2. Improper ERP Vendors Vetting
  3. Not understanding / using Key Features
  4. Underestimating Time & Resources Required
  5. Not having right people on team from the start
  6. Not setting priorities
  7. Not investing in training & change management
  8. Underestimating the importance of accurate data
  9. Taking the kitchen sink approach
  10. Not decommissioning legacy applications
  11. Not having an active load testing environment
  12. Ignoring Third-Party support alternatives
  13. Not having a maintenance strategy

And I would like to add one further mistake:

  • Keep on changing requirements in the middle of actual implementation
  • Implementation without a concrete Sign-Off document

I believe the above list pretty much completes the most common mistakes that we might make in an ERP implementation.


Victoria Yudin’s Book – Microsoft Dynamics GP2010 Implementation

So we have a book on GP overall functionality Microsoft Dynamics GP 2010 Cookbook, by Mark Polino. Now we have another one, Microsoft Dynamics GP 2010 Implementation, by Victoria Yudin.

Read more on Victoria’s post: Dynamics GP 2010 implementation book coming soon.

For those who want to preorder this book, you can reach Packt Publications’ exact page here: Microsoft Dynamics GP 2010 Implementation.


Microsoft Dynamics GP10 Service Pack 5 – Available Now

Details of this release is available on David’s, Mariano’s & Jivtesh’s articles, respectively:

1. Microsoft Dynamics GP 10.0 Service Pack 5 – David
2. Microsoft Dynamics GP 10.0 Service Pack 5 now Available – Mariano
3. GP 10.0 SP5 is Out (with lots of AA Fixes) – Jivtesh

David & Jivtesh details us about the core fixes or changes in SP5.

One important point that I have to highlight is: The Incompatibility of SP5 to get upgraded to GP2010 RTM. We have to wait till GP2010 SP1.

People who are planning for a GP2010 Upgrade must tread caution before applying this patch. Go thru’ the SP release notes and FAQs to make sure you really need it for your GP10 environment till you move on to GP2010.