How To Create An ODBC For Microsoft Dynamics GP 2010

Microsoft Dynamics GPI’ve recently had the need to document the install process for Microsoft Dynamics GP 2010 for a new client so I thought I might as well finish off the task and but turning it into a small series of blog posts, the first of which will cover the manual creation of an ODBC connection.

To connect the Microsoft Dynamics GP client to the databases on SQL Server, an ODBC connection needs to be setup. In an x86 version of Windows this can be done using the ODBC Control Panel applet, but in an x64 version you need to use the x86 version of the ODBC Data Source Administrator.

The easiest way of accessing this is by using the Run window and opening %windir%\SysWOW64\odbcad32.exe;

Run

Continue reading “How To Create An ODBC For Microsoft Dynamics GP 2010”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – How To Install The Web Client

Microsoft Dynamics GPIn this post I’m ging to give a run through of the installation process of the web client itself.

To install the web client run the Microsoft Dynamics GP 2013 setup utility and select Web Client from the list;

Microsoft Dynamics GP 2013 setup utility

Continue reading “How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – How To Install The Web Client”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing a Self-Signed Certificate In IIS

Microsoft Dynamics GPNow that IIS is installed, we need to create a security certificate for use with the Microsoft Dynamics GP 2013 web client.

In a production environment I would use a proper signed certificate but for testing purposes, I’m going to go with a self signed certificate.

To create a self-signed certificate, open Internet Information Services (IIS) Manager, select the machine running the web site (in my case the machine is called GP2013TEST) and then double click on Server Certificates;

Internet Information Services (IIS) Manager - GP2013TEST Home

Continue reading “How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing a Self-Signed Certificate In IIS”

MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty fourth feature they’ve announced is Multitenant SQL Server Reporting Services Reports.

The current version of Microsoft Dynamics GP only supports a dedicated instance of SQL Server Reporting Services for each Microsoft Dynamics GP data instance. With the introduction of the Multi-tenant System Database Architecture, the SQL Server Reporting Services needed to be updated to allow for similar functionality.

With this Multi-tenant SQL Server Reporting Services Reports feature, multiple data instances can be deployed to a single SQL Server Reporting Services instance by allowing the implementer to to deploy the reports to a “tenant” folder.

Continue reading “MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Web Server Installation

Microsoft Dynamics GPTo function the Microsoft Dynamics GP 2013 web client requires a web server running IIS with a web site bound to an SSL certificate.

The operating system of the web server must be one of the following:

  • Microsoft Windows Server 2008 R2
  • Microsoft Windows Server 2012

Once you have installed one of the above, I chose Windows Server 2008 R2 for this install, the Web Server (IIS) role needs to be installed via Server Manager.

Open Server Manager and click the Add Roles link;

Server Manager

Continue reading “How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Web Server Installation”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Security Groups & Required Service Accounts

Microsoft Dynamics GPThere are two security groups needed for the Microsoft Dynamics GP 2013 web client and these should be created prior to starting the web client installation.

The first is the Web Client Users group, of which users who will log into the web client will need to be members. The second is the Web Management Console Users group which is the group for administrators of the Web Client.

I have created these groups in Active Directory as GPWebClientUsers and WebManagementConsoleUsers respectively.

To run Microsoft Dynamics GP Web Services, there are four service accounts which are required:

  1. GP Web Client site application pool – This is the service account which runs the application pool on the web site hosting the Microsoft Dynamics GP web client.
  2. Web Management Console application pool – This is the service account which runs the application pool on the web site hosting the Web Management Console.
  3. Session Central Service – This si the service account which runs the Session Central Service.
  4. Session Service – This is the service account which runs the Session Service on each session host machine.

For the single-server installation these accounts can be machine accounts but I would always recommend that even for this type of installation that they be limited privilege Domain user accounts which have a password that does not expire.

For a scale out, or multi-tenant configuration, these would need to be privilege limited Domain user accounts with passwords that do not expire. While these can all be the same accounts, I typically advise people to use a different account for each one (a legacy of dealing with Microsoft Dynamics CRM where it is recommended that each service is a different account).

In this single-server configuration I will be configuring four separate user accounts to use; one for each of the services.

In the next post, I’ll take a look at installing Internet Information Services (IIS).

MDGP 2013 Feature of the Day: Update Item Allocation Inquiry In Field Service

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty third feature they’ve announced is Update Item Allocation Inquiry In Field Service.

In the Item Allocation Inquiry window, Field Service now appears in the Module Restrictions box. You can now view item quantities allocated from Service Calls, RTVs and Depot work order documents. You can also use the Document Number field zoom to open the Field Service series inquiry window displaying the original document;

Service Call Entry/Update

Continue reading “MDGP 2013 Feature of the Day: Update Item Allocation Inquiry In Field Service”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing The Web Client Runtime

Microsoft Dynamics GPThe first post in this series was a brief introduction which outlined the components within a web client deployment and the second covered the deployment options which are available. In this post I’m going to take a look at the process for installing the web client runtime.

Microsoft recommend that Microsoft Dynamics GP be installed, configured and confirmed as operating correctly before any of the components for the Microsoft Dynamics GP web client are installed.

Even if you’re using the web client you will still need at least one accessible desktop client as even though most of the administrative tasks of Microsoft Dynamics GP can be performed with the web client, some, such as creating companies, cannot.

Each of the servers which is being used as a session host must have a Microsoft Dynamics GP desktop client installation which can be connected to the Microsoft Dynamics GP databases.

Continue reading “How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing The Web Client Runtime”

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Deployment Options

Microsoft Dynamics GPThe first post in this series was a brief introduction which outlined the components within a web client deployment which I’m going to follow up in this post with a look at the deployment options which are available.

There are three options when deploying the Microsoft Dynamics GP web client:

  1. Single machine
  2. Scale out
  3. Multi-tenant

The single machine configuration is the simplest configuration available when deploying the Microsoft Dynamics GP web client. In this configuration, the web site, Session Central Service, Session Service and the Microsoft Dynamics GP web client runtime are all installed on a single server.

A typical single configuration machine is shown in the following diagram;

Web Client Deployment Configuration - Single Machine

Continue reading “How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Deployment Options”