List View Action Pane Error During Upgrade

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWe have been doing a number of upgrades for clients recently, the majority of which went fine. However, we did have one, being done by one of my team, where there was an error produced on the table List View Action Pane when upgrading to Microsoft Dynamics GP 2015 R2:

Company Detail

Continue reading → List View Action Pane Error During Upgrade

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPIn the last couple of posts in this series, we have deployed the system database and Fabrikam sample database. In this post, I’m going to create a new company using GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Create Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Ian Grieve ●  ● 11 Comments   ● 

Microsoft Dynamics GPNow that we have the first client installed, we can deploy the system database. By default the system database is called DYNAMCIS, but i have chosen to use one called D16R1. To deploy the system database, hit the Windows start button, search for and launch GP Utilities.

While I do try to minimise the use of the sa account as it is the SQL Server system administrator account, the initial implementation of Dynamics GP does require its use. So, on the Welcome to Microsoft Dynamics GP Utilities window enter sa in the User ID field and enter the relevant password.

Once done, click OK:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Upgrade Conversion Process Error

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWe’ve recently started work with a client to upgrade their Microsoft Dynamics GP 2010 R2 system to Microsoft Dynamics GP 2015. When running GP Utilities the following error, which caused the upgrade to fail, was produced:

Table Error Detail
The conversion process encountered an error and the temporary table did not get removed.

As a first step, we restored the system database and restarted GP Utilities and got the same error again. I did a little exploring of the Company Master table and found that there were entries for companies which did not exist.

After restoring the DYNAMICS database again and running the Clear Companies.sql script from Microsoft, we were able to run GP Utilities without further errors and complete the upgrade.

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 R2: Create A New Company

● Ian Grieve ●  ● 3 Comments   ● 

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.

In this fourth post, I’m going to cover the creation of a new company; in this case I am going to create a company for Perfect Image Ltd. To create a new company, launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Create A New Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 R2: Deploy The Sample Company

● Ian Grieve ●  ● 2 Comments   ● 

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.

The third post, covers the deployment of the Fabrikam, Inc. sample company. Launch GP Utilities from the Home screen by right clicking and doing Run as Administrator. Log in using the sa or DYNSA account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Deploy The Sample Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 R2: Install System Database

● Ian Grieve ●  ● 1 Comment   ● 

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.

The second post in this series, covers the installation of the System database. This is the database which holds the deployed companies and security configuration amongst oither items. To install the System database, run GP Utilities from the Start screen.

Despite what seems to be a regular argument I seem to have with Infrastructure people, you must log into GP Utilities using the sa account in order to be able to install the System database (no “ifs”, no “buts”; it must be sa):

Welcome to Microsoft Dynamics GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 R2: Install System Database

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP 2015 R2 Launch Problem

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPDespite my assumptions about hotel Wi-Fi I have been able to download the Microsoft Dynamics GP 2015 R2 installation media. However, I have encountered an issue when trying to launch the client following the install.

I wondered if someone else would be able to verify my findings?

I installed in on my laptop which already has the following installed;

  1. Microsoft Dynamics GP 2010 SP3
  2. Microsoft Dynamics GP 2013 SP2
  3. Microsoft Dynamics GP 2013 R2
  4. Microsoft Dynamics GP 2015

GP Utilities appears to run OK, but when I try to launch the desktop client, it tells me I need to launch GP Utilities and ends up in a perpetual loop of me running GP Utilities then the desktop client and so on.

When I installed the software it did ask if I wanted to update the 2015 instance which I declined and installed a named instance of 2015 R2. I am wondering if this is because I have other versions of the client installed?

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2015 RTM: Create A New Company

● Ian Grieve ●  ● 3 Comments   ● 

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.

In this post, I’m going to cover how to create a company in Dynamics GP 2015. To create a company, launch GP Utilities and log in with a user account which has permissions to create a database (for ease I typically use the sa account, but any account with the relevant permissions can be used):

Welcome to Microsoft Dynamcis GP Utilities

Continue reading → Hands On With Microsoft Dynamics GP 2015 RTM: Create A New Company

● Categories: Dynamics, GP, GP Utilities, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●