Hands On With MDGP 2018 RTM: Get Available GP PowerShell Commands

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 GP PowerShell now installed, it is available for us to use.

There are a number of commands available which can be retrieved using the Get-Command -module GP2018 command:

GP PowerShell

Back when Microsoft Dynamics GP 2016 RTM was released, I posted about using GP PowerShell to deploy a company; this is probably the main use I make of GP PowerShell as, especially when implementing a system with a number of companies, it is easier to deploy the commands via a PowerShell script than clicking through the application manually for each one.

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

Hands On With MDGP 2018 RTM: Install GP PowerShell

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 PowerShell; this allows you to use PowerShell cmdlets to, for example, deploy companies additional tenants if using a multi-tentnqat implementation.

There is a problem with the GP PowerShell on the installation media. Instead of using this, you need to download a new installer for it, which is available from CustomerSource (login required).

Once you have downloaded the file, and unzipped it, launch the Microsoft_DynamicsGP18_PowerShell.exe:

Windows Explorer

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

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 R1: Use Microsoft Dynamics GP PowerShell To Create A Company

Microsoft Dynamics GPMicrosoft Dynamics GP PowerShell has a number of cmdlets which can be used to administer Microsoft Dynamics GP. Before you can use them GP PowerShell needs to be installed.

The following command can be used to return all available cmdlets for Dynamics GP PowerShell:

Get-Command -module GP2016

The following example shows how GP PowerShell can be used to create a new company:

Administrator: Microsoft Dynamics GP 2016 PowerShell
Add-CompanyDatabase -GPClientDirectory "C:\Program Files (x86)\Microsoft Dynamics\GP2016" -SqlAdmin "sa" -SqlAdminPassword "password" -SqlServerName "2016R1-SQL\GP" -CompanyName "azurecurve Publishing" -CompanyDbName "A16R1"-SqlMdfFilePath "C:\SQL Server\Data\" -SqlMdfFileName "GPSA16R1Dat.mdf" -SqlLdfFilePath "C:\SQL Server\Data\" -SqlLdfFileName "GPSA16R1Dat.ldf"

The supplied parameters and their values are:

  • -GPClientDirectory “C:\Program Files (x86)\Microsoft Dynamics\GP2016”
  • -SqlAdmin “sa”
  • -SqlAdminPassword “password”
  • -SqlServerName “2016R1-SQL\GP”
  • -CompanyName “azurecurve Publishing”
  • -CompanyDbName “A16R1”
  • -SqlMdfFilePath “C:\SQLServer\Data\”
  • -SqlMdfFileName “GPSA16R1Dat.mdf”
  • -SqlLdfFilePath “C:\SQLServer\Data\”
  • -SqlLdfFileName “GPSA16R1Dat.ldf”/li>

You would replace the text between the quotation marks with 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 2016 R1 Series Index

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

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 RTM introduced PowerShell which can be used for a number of administrative purposes. To use the supplied cmdlets, Microsoft Dynamics GP PowerShell needs to be installed from the downloaded media.

Once you have the media downloaded, run the setup utility and, under Additional Tools, select GP PowerShell:

Microsoft Dynamics GP 2016 setup utility

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

Hands On With Microsoft Dynamics GP 2015 R2: Create Company Using GP PowerShell

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

Microsoft Dynamics GP 2015 R2 saw the introduction of some additional PowerShell cmdlets. I thought it might be useful to select one of the new cmdlets and give a run through of using it.

One of the tasks I often do a lot of is creating new companies so I have selected the Add-CompanyDatabase cmdlet.

To run any of the cmdlets, launch GP PowerShell from the Start screen.

The easiest way of finding out the parameters to use is to enter the following command:

Get-Help Add-CompanyDatabase

Get-Help Add-CompanyDatabase

This will display the details of the cmdlet including the Synopsis, Syntax, Description, Related Links and Remarks.

Continue reading “Hands On With Microsoft Dynamics GP 2015 R2: Create Company Using GP PowerShell”

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

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 was released at the end of May. As I mentioned at the time, I was away from home for work and rather busy otherwise so this series of posts has been somewhat delayed.

However, I am now getting my hands on GP 2015 R2 and thought I would do my usual set of posts on the installation of the various components and also the usage of the new functionality. This is going to be quite a long series of posts, so keep checking back regularly.

Microsoft Dynamics GP 2015 RTM saw the introduction of GP PowerShell which allows PowerShell to be used to automate certain tasks. Microsoft Dynamics GP 2015 R2 saw the introduction of additional GP PowerShell cmdlets.

To install GP PowerShell, open the setup utility and, under Additional Products, click GP PowerShell:

Microsoft Dynamics GP 2015 setup utility

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