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”

Management Reporter 2012 Rollup 4 Released

Microsoft Dynamics GPOn the 28th January, Rollup 4 for Management Reporter 2012 was released via the Dynamics Corporate Performance Management blog.

It can be downloaded from CustomerSource (CustomerSource or PartnerSource login required).

For Microsoft Dynamics GP users there is improved performance with the data mart integrations and new Quick Links in the Web Viewer which allows users to easily jump to key areas of a report.

EFT File Format Import/Export Error

Microsoft Dynamics GPI’ve recently been creating an HSBC Standard 18 BACs file format for a client in Microsoft Dynamics GP 2010 R2.

Unfortunately, once I released it to their system, they reported an error with the import where the Creditor’s Cheque Name wasn’t being output on the resulting file.

I did some testing and it turns out to be a bug in the export function of the EFT File Format (Cards » Financial » EFT File Format) window in Microsoft Dynamics GP 2010 R2; I have subsequently tested on GP 2010 SP3 and GP 2013 and the import/export works fine. I realised something odd was going on when I looked at the template in the EFT File Format window (Cards » Financial » EFT File Format) and saw that while the Series was defined as Purchasing in the header, the scrolling window for the Data Field only had Receivables Management tables and fields available to it and not the Payables Management tables and fields I would expect;

EFT File Format

Continue reading “EFT File Format Import/Export Error”

Review of Developing Microsoft Dynamics GP Business Applications – Part 1

Microsoft Dynamics GPAt the end of December, Developing Microsoft Dynamics GP Business Applications, written by Leslie Vail and published by Packt Publishing was released.

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

I got a copy of the book in order to do a review and have decided to break the review down into multiple parts. The reason for this is that the book includes some practical examples which I have decided to do and then include the results of this in the review; after all if it is a book on developing how can you accurately review the book if you don’t use what you learn to build something?

The book is aimed at developers new to working with Microsoft Dynamics GP, so bear in mind that I am not a developer when reading my reviews. Quick synopsis of my background: I started my career as a trainee developer and moved through a variety of roles such as developer and support analyst before moving to my current position as consultant and project manager.

I oversee development teams working on additions or amendments to Microsoft Dynamics GP as well as personally undertaking some modifications using Report Writer or Modifier with VBA. So despite not being a developer, I am used to working with them and did, once upon a time, be one myself.

The first chapter of the book covers the Microsoft Dynamics GP Architecture from a high level perspective.

It covers the history of the GP interface from it’s origins with Great Plains Software, an overview of Dexterity and the development environment. There is a detailed explanation of the launch file (Dynamics.set), which included a couple of points of which I wasn’t aware, and the configuration/preferences file (Dex.ini).

The explanation of the Dex.ini file included the ExportOneLineBody switch which I didn’t know about, but for which I have an immediate use.

Leslie then goes on to explain about the structure of the tables in the SQL Database which always strikes newcomers as arcane and overly complex. Leslie explains this well with plenty of detail on both the structure, including both the physical and technical names, and how transactions move between tables as their state changes.

Chapter 1 wraps up with a detailed explanation of the UI covering how forms are constructed, how the scrolling windows work and the common buttons used on forms, scrolling windows and individual buttons.

The second chapter of the book focuses on the fundamentals of integrating applications with Microsoft Dynamics GP.

Continue reading “Review of Developing Microsoft Dynamics GP Business Applications – Part 1”

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.

Integration Manager 11 Installation Errors

Microsoft Dynamics GPWell, the old ones are often the best. I needed to install Integration Manager onto a system earlier and got an access denied error message the first time I tried to start it;

Integration Manager - Could not create all default application data due to the following error: - Access to the path 'C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0' is deniedCould not create all default application data due to the following error: – Access to the path ‘C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0’ is denied

Continue reading “Integration Manager 11 Installation Errors”

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”