Prerequisites For Installing Microsoft Dynamics GP 2013 Web Services

Microsoft Dynamics GPThe next few posts will cover the installation and configuration of the Web Services for Microsoft Dynamics GP 2013, but, first, I thought it might be useful to give an overview of the prerequisites.

First, the operating system; Windows Server 2008 or Windows Server 2008 R2 Standard or Enterprise editions are supported. According the the documentation, Windows Server 2012 is not yet supported although the install does work.

Second, a Microsoft SQL Server 2008 or later to host the security database. This could be the same or different SQL Server which is hosting the Microsoft Dynamics GP 2013 system and company databases.

Third, Microsoft .NET Framework 4 is required and will be installed by the Microsoft Dynamics GP setup utility.

Fourth, a service user account is needed to run as the Microsoft Dynamics GP Service Host which is the Windows service host. If you’re running web services on the SQL Server then you can use a local user account but if the web services are on a different machine to the SQL Server then a domain user account should be used.

Fifth, the is two bits of setup which needs to have been completed in Microsoft Dynamics GP 2013:

  1. A Functional Currency needs to be configured in the Multicurrency Setup window (Microsoft Dynamics GP menu » Tools » Setup » Financial » Multicurrency)
  2. All currencies need to have a unique ISO currency code (Microsoft Dynamics GP menu » Tools » Setup » System » Currency)

The next post will take a look at the installation of the Web Services Runtime

Error Starting Microsoft Dynamics GP 2013 In Dexterity Debug

Microsoft Dynamics GPI’ve recently started taking a look at Leslie Vail’s book, Developing Business Applications for Microsoft Dynamics GP which was published in December by Packt Publishing. The book was written using Microsoft Dynamics GP 2010; this is not a criticism as the book will have taken a fair time to write and was published two days after Microsoft Dynamics GP 2013 was released so there wasn’t time to do an update to the latest version.

However, Microsoft Dynamics GP 2013 was available I’ve decided to perform the practical examples using this version rather than GP 2010 because I had just finished building a customisation environment with GP 2013 installed in it and I could easily add Dexterity and the other tools used in the book to the environment.

As I was following the steps in Chapter 3 of the book, which is an introduction to Dexterity, where common errors and issues encountered in Microsoft Dynamics GP 2010 and how to resolve them are explained, I came across an error which was specific to Microsoft Dynamics GP 2013;

AZCProject.dic - Could not load file or assembly. 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage' or one of its dependencies. The system cannot find the file specifiedAZCProject.dic – Could not load file or assembly. ‘Microsoft.Dynamics.GP.BusinessIntelligence.Homepage’ or one of its dependencies. The system cannot find the file specified

Continue reading “Error Starting Microsoft Dynamics GP 2013 In Dexterity Debug”

Support Debugging Tool Build 17 hotfix released

Microsoft Dynamics GPHe somehow slipped it out without me noticing, but David Musgrave of the Developing for Dynamics GP blog released Support Debugging Tool Build 17 before Christmas; this is the build which added support for Microsoft Dynamics GP 2013.

He was back yesterday with a hotfix release to fix a couple of issues.

Partners can download SDT from PartnerSource (login required); if you’re a customer you’ll need to contact your partner to obtain it for you.

David has links to SDT for Microsoft Dynamics GP 10 and 2010 here.

How To Install Integration Manager 12

Microsoft Dynamics GPMicrosoft Dynamics GP 2013 ships with a variety of other software such as Business Analyzer (about which I have posted the installation and configuration steps) and also one called Integration Manager.

Integration Manager is a utility which can be used to load data into Microsoft Dynamics GP on a manually basis. Data can be loaded from text file, XML or directly from a database using an ODBC connection. Integration Manager is a better option that the Table Import (Microsoft Dynamics GP menu » Tools » Routines » Table Import) routine because it enforces data integrity.

Integration Manager in Microsoft Dynamics GP is available for implementation for 120 days after which it must be purchased as part of the Customization Pack (prior to Dynamics GP 2013 it could be purchased as part of the Integration Suite).

There are a two adapters available for Integration Manager; Dynamics GP and eConnect. The latter adapter requires another Microsoft product to be installed so this how-to will focus only on the former.

Integration Manager is installed from the Microsoft Dynamics GP 2013 setup utility;

Microsoft Dynamics GP 2013 setup utility

Continue reading “How To Install Integration Manager 12”

How To Configure Business Analyzer for Microsoft Dynamics GP 2013

Microsoft Dynamics GPIn the last post, I showed how to install Microsoft Dynamics GP Business Analyzer and in this one I’ll show how to configure it.

When you first log into Business Analyzer, you’ll be presented with the configuration window;

Microsoft Dynamics Business Analyzer Configuration

Continue reading “How To Configure Business Analyzer for Microsoft Dynamics GP 2013”

How To Install Business Analyzer for Microsoft Dynamics GP 2013

Microsoft Dynamics GPIn this post, I’ll take a step-by-step look at installing Business Analyzer for Microsoft Dynamics GP 2013. This is a tool that comes as standard with GP but I’ve never bothered to look at before; this has changed recently because I’ve been dealing with a few clients who are heavy users of SSRS and Business Analyzer gives way to run the GP reports without needing to log into Microsoft Dynamics GP itself.

To Install Microsoft Dynamics GP Business Analyzer start the normal Microsoft Dynamics GP setup utility and select Microsoft Dynamics GP Business Analyzer;

Microsoft Dynamics GP 2013 Setup Utility

Continue reading “How To Install Business Analyzer for Microsoft Dynamics GP 2013”

Microsoft Dynamics GP 2013 RTM Hyper-V Demonstration Image Sets Now Available For Download

Microsoft Dynamics GPPam Misialek on the Inside Microsoft Dynamics GP blog, announced that the Microsoft Dynamics GP 2013 RTM Hyper-V Demonstration Image Sets are now available for partners to download from PartnerSource (login required).

These image sets are the full RTM versions of the software and contain the following:

  • Microsoft Dynamics GP 2013 RTM with Web Client deployed
  • Management Reporter 2012 with Web Viewer deployed
  • Office 2013 with demo dashboards installed

It is a set of three Hyper-V images which needs both A and B to be up and running with a minimum of 2GB RAM assigned to each (although as with all VMs the more RAM they have the quicker they will run) and need to be able to ping each other (the 2010 R2 instructions, on the download page, detail how to do this). Image C is only required if Lync is being demonstrated.

The full post from Inside Microsoft Dynamics GP contains extended information and warnings of minor issues with the images to watch out for.

How To Install Microsoft Dynamics GP 2013 – How To Create A Company

Microsoft Dynamics GPThe Microsoft Dynamics GP sample company, which I showed how to install in the last post, is good for doing a demo or for testing, but in the real world most sites will never deploy the sample company. Instead their efforts will be focused on creating a company to host their own data, which is what we’re going to take a look at in this post.

New companies are created using GP Utilities (Windows Start menu » All Programs » Microsoft Dynamics » GP 2013 » GP Utilities) and login using the sa password;

Welcome to Microsoft Dynamics GP Utilities

Continue reading “How To Install Microsoft Dynamics GP 2013 – How To Create A Company”

How To Install Microsoft Dynamics GP 2013 – Deploying The Sample Company

Microsoft Dynamics GPMicrosoft Dynamics GP ships with a sample company which can be deployed along with it’s data to either use in demos or for testing. In this post we’ll take a look at deploying this sample company which done via GP Utilities.

Start GP Utilities (Windows Start menu » All Programs » Microsoft Dynamics » GP 2013 » GP Utilities) and login using the sa password;

Welcome to Microsoft Dynamics GP Utilities

Continue reading “How To Install Microsoft Dynamics GP 2013 – Deploying The Sample Company”

How To Install Microsoft Dynamics GP 2013 – Server Configuration

Microsoft Dynamics GPNow that the Microsoft Dynamics GP 2013 client has been installed we can move onto configuring the server. This is done using GP Utilities which is installed alongside the GP client itself by the setup utility.

Log into GP Utilities using the same System DSN as GP and make sure you log in as the sa user;

Welcome to Microsoft Dynamics GP Utilities

Continue reading “How To Install Microsoft Dynamics GP 2013 – Server Configuration”