Hands On With MDGP 2018 RTM: Configure & Use OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

In the last post, I covered the installation of the GP OData Service. However, I am not going to cover the configuration 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

I am planning to do some work with Odata in the near future, and am likely to blog about it when I do.

Click to show/hide the Hands On With MDGP 2018 RTM Series Index

Hands On With MDGP 2018 RTM: Install GP OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

The next of the additional products I am going to install, is the GP OData Service; this allows external tools, such as PowerBI, to connect to Dynamics GP.

To install the GP OData Service, launch the Microsoft Dynamics GP 2018 setup utility from the downloaded media. Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

Continue reading “Hands On With MDGP 2018 RTM: Install GP OData Service”

Hands On With MDGP 2018 RTM: Verify Web Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

The final step with the Web Services, now that they have been configured, is to verify that they are working correctly.

There are three checks which I recommend when verifying the web services:

  1. Is the service running?
  2. Have the security objects been deployed?
  3. Are the endpoints working?

Continue reading “Hands On With MDGP 2018 RTM: Verify Web Services”

Hands On With MDGP 2018 RTM: Configure Web Services

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

After installing the Web Services for Microsoft Dynamics GP, the next step is to run the Web Services for Microsoft Dynamics GP Configuration Wizard.

This is available via the Windows start menu; once running, click Next on the Welcome step:

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

Continue reading “Hands On With MDGP 2018 RTM: Configure Web Services”

Hands On With MDGP 2018 RTM: Install Web Services Runtime

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

The next of the Microsoft Dynamics GP 2018 RTM additional products I am going to install, is the Web Services for Microsoft Dynamics GP; a few years ago I rarely bothered installing the web services as they were not used by many of my clients. However, the introduction of Workflow 2.0 in Microsoft Dynamics GP 2013 R2 changed this; now almost every client requires the installation of web services when they upgrade, as this allows them to use email actions for approving submitted documents.

To install the Web Services for Microsoft Dynamics GP, launch the Microsoft Dynamics GP 2018 setup utility from the downloaded media. Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

Under Additional Products, select Web Services Runtime and then click Install on the popup menu:

Microsoft Dynamics GP 2018 setup utility

Continue reading “Hands On With MDGP 2018 RTM: Install Web Services Runtime”

Hands On With MDGP 2018 RTM: Verify Web Management Console Functions

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the web client verified, the final verification is of the Web Management Console.

The web address for the Web Management Console is the server’s fully qualified domain name (FQDN) followed by /WebManagementConsole; I only entered the machine name, rather than the FQDN and so received a certificate error. Clicking Continue to this website took me straight into the Web Management Console:

IE Security Certificate Warning

Continue reading “Hands On With MDGP 2018 RTM: Verify Web Management Console Functions”

Hands On With MDGP 2018 RTM: Verify Web Client

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

Whenever I install the web components, or any application or component, the next thing I do is run a test to ensure that the installation, and any configuration, was successful.

To test the Microsoft Dynamics GP web client, open the browser of your choice (from Dynamics GP 2016 onwards, the GP web client has been in HTML5 and therefore cross-browser compatible) and navigate to the web client page, which will be the server name followed by /GP. I installed the web client using a self-signed certificate which was created using the fully qualified domain name of the server.

However, when I did my test, I used only the server name and so got a security certificate warning:

Internet Explorer

Continue reading “Hands On With MDGP 2018 RTM: Verify Web Client”

Hands On With MDGP 2018 RTM: Install GP Web Resource Cache

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the main installation of the web components completed, the step covered in this post is an optional, although recommended, one. The GP Web Resource Cache should be installed on each of the web client session servers.

Launch the setup utility from the downloaded installation media; depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

Once the setup utility has started, click on GP Web Resource Cache under the Additional Products heading:

Microsoft Dynamics GP 2018 setup utility

Continue reading “Hands On With MDGP 2018 RTM: Install GP Web Resource Cache”

Hands On With MDGP 2018 RTM: Install Web Components Help

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

With the Web Components now configured, the final part of the installation of the web components is to install the Web Components Help.

The install utility was automatically launched alongside the Web Components Configuration Wizard; click the Install button to start the install:

Microsoft Dynamics Web Components Help

Continue reading “Hands On With MDGP 2018 RTM: Install Web Components Help”

Hands On With MDGP 2018 RTM: Configure Web Components

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.

The series index for this series of posts is here and will automatically update as posts go live.

After adding the Web Component runtime features to the client, the next step is to install the web components themselves.

Launch the Microsoft Dynamics GP 2018 setup utility. Depending on server settings, you might receive multiple security warnings during the installation; click Run on each one as it appears:

Under the Additional Products header, select Web Components and click Install on the popup menu which appears:

Microsoft Dynamics GP 2018 setup utility

Continue reading “Hands On With MDGP 2018 RTM: Configure Web Components”