Hands On With Microsoft Dynamics GP 2016 R2: Add Service Based Architecture Feature

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the first of which I will cover in this post, and the remainder in the next posts of this series.

The first step is to add the SBA feature to the instance of the desktop Dynamics GP client installed on the web server. To do this open the Program and Features Control Panel applet easiest way is to press Win+R and type appwiz.cpl.

Select Microsoft Dynamics GP 2016 and click on Change:

Programs and Features

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Add Service Based Architecture Feature”

Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

If you have a number of clients which need Microsoft Dynamics GP installed, this can become somewhat burdensome to ensure that they are all installed exactly the same way; if you do it manually at least. However, via the Microsoft Dynamics GP setup utility, you can build an installation package which much simplifies the job.

To create an installation package, launch the setup utility and select Create Installation Package from under the Install heading:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package”

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

The OData Service for Microsoft Dyamics GP allows connections to be made to the Dynamics GP databases in order to run reports. To install the service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service”

Hands On With Microsoft Dynamics GP 2016 R2: Install GP Add-in for Microsoft Word

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

As of Microsoft Dynamics 2010, Word Templates can be used for the production of reporets such as Purchase Orders, Check Remittances and Sales Invoices, and more.

The Word Templates are fully customisable, but to get the best out of customising them, you need to have the Microsoft Dynamics GP Add-in for Microsoft Word installed. This can be found on the installation media under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install GP Add-in for Microsoft Word”

Hands On With Microsoft Dynamics GP 2016 R2: Use GP PowerShell To Create a Company

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I covered the installation of GP PowerShell; in this I’m going to refer back to a Hands On With Microsoft Dynamics GP 2016 R1 post I did back in May 2016 on how to use GP PowerShell to create a company.

Everything in that post is still relevant and unchanged in Dynamics GP 2016 R2.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Microsoft Dynamics GP has a number of PowerShell cmdlets which can be used to, for example, create new companies. To use these cmdlets, GP PowerShell needs to be installed. Launch the setup utility and select GP PowerShell from under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell”

Hands On With Microsoft Dynamics GP 2016 R2: Install Companion Application Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

The Companion Application Services provides the API for third parties to write companion applications for Microsoft Dynamics GP. To install them, launch the Microsoft Dynamics GP setup utility and, under Additional Products select Companion Application Services:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install Companion Application Service”

Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Over the last couple of posts, I have installed and configured the Web Services for Microsoft Dynamics GP, it is now time to verify that they are working correctly; there are four items I’d recommend checking.

Firstly, open the Services applet from Computer Management and make sure the Microsoft Dynamics GP Service Host is set to a Startup Type of Automatic and that the service is Running:

Services

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services”

Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Services

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I installed the web services; in this post, I’ll cover the configuration.

If, when you installed the web services, you left the Run Configuration Wizard checkbox marked, the Configuration Wizard will have started automatically. if you didn’t do this, the launch the Configuration Wizard from the Start menu.

On the Welcome screen, click Next:

Web Service for Microsoft Dynamics GP Configuration Wizard: Welcome to the Web Service for Microsoft Dynamics GP Configuration Wizard

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Services”