Category: Microsoft

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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.

GP PowerShell can be used to create companies and other actions. The following example shows how GP PowerShell can be used to create a new company:

The supplied parameters and their values are:

• -GPClientDirectory “C:\Program Files (x86)\Microsoft Dynamics\GP2018”
• -SqlAdmin “sa”
• -SqlAdminPassword “password”
• -SqlServerName “SERVER\GP”
• -CompanyName “azurecurve Publishing”
• -CompanyDbName “A18R2”
• -SqlMdfFilePath “C:\SQLServer\Data\”
• -SqlMdfFileName “GPSA18R2Dat.mdf”
• -SqlLdfFilePath “C:\SQLServer\Data\”
• -SqlLdfFileName “GPSA18R2Dat.ldf”

the text between the quotation marks needs to be changed to the values you want to use to create the company.

Enter the cmdlet and parameters into GP PowerShell and hit return and the cmdlet will launch GP Utilities and create the new company; if you have any missing parameters or errors the launch will fail (usually with a less than helpful message).

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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.

After install GP PowerShell, to make sure it has installed correctly, we can use the Get-Command statement to get the available GP PowerShell commands.

Launch the relevant version of GP PowerShell from the Windows Start menu and type the following command:

Get-Command -module GP2018

In the next post, I’ll show how to create a company using PowerShell.

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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.

GP PowerShell was introduced a few versions ago and gives commands which be used to, for example, create companies or deploy additional tenants.

To install GP PowerShell, launch the setup utility and, under Additional Products, select GP PowerShell:

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

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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:

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

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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:

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

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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:

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:

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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:

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

Microsoft Dynamics GP 2018 R2 was released on the 2^nd 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.