Microsoft Dynamics GP Documentation Now on Microsoft Docs

Microsoft Dynamics GPThe documentation for Microsoft Dynamics GP is being added to the Microsoft Docs libary. Some of the documentation is already there and Microsoft have announced that more will be added through time. Hopefully, this will be accompanied by the documentation being brought up-to-date as much of it has not been updated since Dynamics GP 2013.

Microsoft have also opened the documentation for contribution by the community. The documentation is available for contribution via a public GitHub repo.

Implementing Jet Professional: Deploying Jet Views

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Professional sub-series. I’m a little late in posting this one, as I forgot to include it with the original series when I posted it.

Jet Professional provides a number of database views which can be used to simplify reporting, rather than using the Microsoft Dynamics GP tables (the structure of which can be confusing to many users of Dynamics GP.

However, the views are not deployed automatically, but need to be deployed after the first client has been installed. To deploy the views, log into Microsoft Dynamics GP and then start the Jet GP Updater which is in the Jet Reports installation folder:

Windows Explorer

Continue reading “Implementing Jet Professional: Deploying Jet Views”

Hands On with Microsoft Dynamics GP 2018 R2: Install Microsoft Dynamics GP Add-in for Microsoft Word

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 Microsoft Dynamics GP Add-in for Microsoft Word was introduced with Microsoft Dynamics GP 2010 to allow the Word templates to be amended by adding additional fields (changes to relocate or remove fields do not require the add-in).

It is a nice simple install which is only needed on computers used by the people who maintain the Word templates. To install it, launch the setup utility and, under the Additional Products heading, select Microsoft Dynamics GP Add-in for Microsoft Word:

Setup Utility

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

Hands On with Microsoft Dynamics GP 2018 R2: Create Installation Package

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.

In an early post of this series, I installed the Microsoft Dynamics GP client; while installing the client isn;t complicated, it is easy to get the wrong features selected during the installation. There is a way of building an installation package which automates the selection of langauges, features and paths.

Creating an installation package is done via the setup utility; select Create Installation Package from under the Install heading:

Setup Utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Create Installation Package”

Hands On with Microsoft Dynamics GP 2018 R2: Integration Manager First Run

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 Integration Manager installed, we can run it.

Running Integration Manager as administrator is required to ensure that relevant permissions are correctly set; the license key also needs to be installed.

Launch Integration Manager from the Windows Start menu by right-clicking and selecting Run as Administrator. Once it has started, a Register Now/Later dialog will be displayed. Click Register Now:

Integration Manager - Run Now

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Integration Manager First Run”

Hands On with Microsoft Dynamics GP 2018 R2: Install Integration Manager

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.

In the last post, I installed eConnect on the client to make the eConnect adaptors available to Integration Manager; in this post, I am going to install Integration Manager.

To do this, launch the setup utility and select Integration Manager from under the Additional Products heading:

Integration Manager

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

Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on 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.

I already stepped through the installation of eConnect on the server, but eConnect is also needed on the client in order to use the eConnect adaptors in Integration Manager.

To install eConnect on a client PC, launch the setup utility and select eConnect under the Additional Products header:

setup utility

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install eConnect on Client”

Hands On with Microsoft Dynamics GP 2018 R2: Create Company Using PowerShell

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.

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:

Administrator: Microsoft Dynamics GP 2018 PowerShell

Add-CompanyDatabase -GPClientDirectory "C:\Program Files (x86)\Microsoft Dynamics\GP2018" -SqlAdmin "sa" -SqlAdminPassword "password" -SqlServerName "SERVER\GP" -CompanyName "azurecurve Publishing" -CompanyDbName "A18R2"-SqlMdfFilePath "C:\SQL Server\Data\" -SqlMdfFileName "GPSA18R2Dat.mdf" -SqlLdfFilePath "C:\SQL Server\Data\" -SqlLdfFileName "GPSA18R2Dat.ldf"

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).

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

Hands On with Microsoft Dynamics GP 2018 R2: Test GP PowerShell By Getting Available Commands

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.

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
Administrator: Microsoft Dynamics GP 2016 PowerShell

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

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 PowerShell

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.

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:

Setup Utility

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