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”

Hands On With Microsoft Dynamics GP 2015 RTM: Installing GP PowerShell

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

Microsoft Dynamics GP 2015 has seen the introduction of some PowerShell cmdlets. This is something new in the Dynamics GP arena which I am going to need to investigate. The first step in this, is to install GP PowerShell. This is done by starting the setup.exe on the GP 2015 installation media and, under Additional Products, select GP PowerShell:

Microsoft Dynamics GP 2015

Continue reading “Hands On With Microsoft Dynamics GP 2015 RTM: Installing GP PowerShell”