Hands On with Microsoft Dynamics GP 2018 R2: Configure & Use OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

The last post covered the installation of the OData Service which means it is ready to be configured. OData isn’t realy my specialty area, so I am going to link to the Dynamics GP 2016 R2 Cookbook which Mark Polino and I wrote:

Microsoft Dynamics GP Cookbook

Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of this book covers the the configuration and use of OData Services:

  • 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 2018 R2 Series Index

Hands On with Microsoft Dynamics GP 2018 R2: Install GP OData Service

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

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.

Launch the setup utility and, under Additional Products, select GP OData Service:

Setup utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install GP OData Service”

Hands On with Microsoft Dynamics GP 2018 R2: Web Services on Media Broken

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

I was going to step through the installation of the Web Services for Microsoft Dynamics GP 2018 R2, but have found that the installer on the media doesn’t work. Selecting Web Services Runtime from the setup utility results in this error:

Error launching Web Services installerClr method invocation failed

I’ve tried this on four different computers and received the same error on all of them.

I’ve reported this to Microsoft for them to look into; in the meantime, I’ve been informed that there were no changes in R2, so the installer of the RTM can be used; I blogged about installing the Web Services for Dynamics GP 2018 RTM back in December 2017:

Install Dynamics GP Web Services 2018 RTM
Install Web Services Runtime
Configure Web Services
Verify Web Services

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Installing TortoiseSVN: Commit Changes

TortoiseSVNThis post is part of the series on installing TortoiseSVN which is I use in the development of Wordpress plugins.

Once you’ve finished making the required changes to the plugin, the files need to be uploaded to the plugin repository; the example I am using in this post, is some changes I made to the azurecurve Floating Featured Image plugin.

To upload the changes, right-click on the top-level plugin folder and select SVN Commit:

Right-click SVN Commit

Continue reading “Installing TortoiseSVN: Commit Changes”

Implementing Jet Reports: Management Reporter vs. Jet Reports

Jet ReportsThe vast majority of my clients are users of Management Reporter, when implementing Jet Reports, one of the key areas, which needs to be discussed, is how Management Reporter compares to Jet Reports.

Fortunately some work has already been done in this area by MVP Belina Allen, the GP CSI. She has done a series of videos on Management Reporter versus Jet Reports.

Below are links to the playlist of all videos as well as links to the individual videos:

  1. Playlist containing all of the below videos
  2. Excel Add-On: An Introduction – Management Reporter vs. Jet Reports
  3. Building Rows – Management Reporter vs. Jet Reports
  4. Building Columns – Management Reporter vs. Jet Reports
  5. Building Trees – Management Reporter vs. Jet Reports
  6. Report Definition – Management Reporter vs. Jet Reports

If you’re a Management Reporter user who is implementing Jet Reports, I’d encourage you to take the time to watch Belinda’s videos.

Hands On with Microsoft Dynamics GP 2018 R2: Install Web Client Resource Cache

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

There is one final, optional, step in installing the web client, which is to install the Web Client Resource Cache on each session host. To install it, launch the setup utility and, under Additional Products, click GP Web Resource Cache:

Setup Utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install Web Client Resource Cache”

Hands On with Microsoft Dynamics GP 2018 R2: Verify Web Management Console Functions

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

With the web client itself verified, the final step in installing the web client is to ensure that the Web Management Console is working. To do this open your browser and navigate to the FQDN of your server followed by /WebManagementConsole:

Click on Session Manager and you’ll be shown the available session servers and any logged in clients.

Click to show/hide the Hands On with Microsoft Dynamics GP 2018 R2 Series Index

Hands On with Microsoft Dynamics GP 2018 R2: Verify Web Client

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

Now that we have the web client installed, prior to allowing users access, we need to verify the web client is working. To do this open your browser of choice, I am on Server 2012 R2 and so only have Internet Explorer available.

Navigate to the FQDN (Fully Qualified Domain Name) of you server followed by /GP and log in using a Windows Login whioch is in the Web Client Users group:

IE

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Verify Web Client”

Hands On with Microsoft Dynamics GP 2018 R2: Install GP Web Resource Cache

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

The second element which needs to be completed after the configuration stage, is the installation of the web client help.

Click Install to begin the installation:

Microsoft Dynamics Web Components Help: Welcome

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install GP Web Resource Cache”

Hands On with Microsoft Dynamics GP 2018 R2: Install Web Client Help

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

With the web client installed, the next step is to finalise the configuration of the web client. The Microsoft Dynamics GP Web Components Configuration Wizard will pop up automatically. Click Next to start:

Welcome

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install Web Client Help”