Tag Archives: Configuration

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Installing SSL Certificates On Client Machines

To avoid certificate errors with the Web Client, the security certificate from the web server needs to be installed onto the client machines (i.e. all of the PCs which will be running IE to connect to the website).

Before the certificate is loaded, you’ll see the following error when navigating to the GP web client:

Certificate Error: Navigation Blocked - Windows Internet Explorer

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Running The Web Client Configuration Wizard On The Session Hosts

After installing the Session Hosts you will be prompted to run the Web CLient Configuration Wizard. We ran this after installing the Session Central server to create the databases; it needs to be run again now, to tell the Session Host which Session Central Database should be used:

Microsoft Dynamics GP Web Client Configuration Wizard - Welcome

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Running The Web Client Configuration Wizard On The Session Central

After installing the Session Central the databases used by the web client need to be created and configured. This is done using the Microsoft Dynamics GP Web Client Configuration Wizard (available on the Windows Home screen or Start menu if you’re using an older version of Windows).

Microsoft Dynamics GP Web Client Configuration Wizard - Welcome

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Deploying The Fabrikam Sample Company

The Fabrikam sample company is deployed via GP Utilities. Log into it using the sa account and progress through to the Additional Tasks. In the drop down list select Add sample company data and click :

Additional Tasks

Continue reading

Posted in Dynamics, GP, GP Utilities, Microsoft, Web Client | Tagged , , , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Creating Required Service Accounts

Depending on your selected options when installing the Microsoft Dynamics GP web client, there are between three and four service accounts required.

The three which are always required are:

  1. Web Application User
  2. Session Service
  3. Session Central Service

The one which is optional dependent on installation options is:

  1. Management Console Application User

This last is only required if the Management COnsole is installed to a different web site to the web client.

To create the service accounts, you need to be logged onto the Domain Control (in my case DC1 which is running Windows Server 2008 R2) and open Active Directory Users and Computers.

Continue reading

Posted in Active Directory, Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , , , | Leave a comment

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Creating Security Groups In AD For The Web Client

There are two security groups required for the Microsoft Dynamics GP web client:

  1. A group for users who can access the web client
  2. A group for users who can access the web client’s management console.

To create these groups we need to be logged onto the domain controller which on my test system is AZC-DC1.

On the domain controller, open Active Directory Users and Computers.

I decided to create a business unit called Microsoft Dynamics GP but you could create the required groups anywhere. To create the web console user’s group click the Create Group button on the toolbar:

Active Directory Users and Computers

Continue reading

Posted in Active Directory, Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , , , | Leave a comment

MB3-700 Microsoft Dynamics GP 2013 Installation & Configuration Certification Acquired

Microsoft Certified Technology SpecialistI updated one of my Microsoft Certifications yesterday by taking the MB3-700 Microsoft Dynamics GP 2013 Installation & Configuration exam.

The exam was fairly similar to the GP 2010 version I took a while ago, but this time round had a number of questions on the Web Client. Fairly fortunate that I’ve started writing a series of posts on it.

I’m looking to do the Financials exam later in the month and, if one is released, would like to get the Inventory & Order Processing certificate updated as well.

Posted in Certifications, Dynamics, GP, Microsoft | Tagged , , , , , , , , | Leave a comment

Fixing Base Period On Management Reporter Sample Company Reports

I did a couple of posts a while ago on fixing the sample company reports (the first post fixed the Row and Column Definitions and the second the Reporting Tree Definitions), but there has been another issue with them that has been bugging me for a while.

The reports are configured to run for periods around the current system date, which means dates in 2013. But the Fabrikam sample company is in 2017 so the reports return no data. With Management Reporter storing its reports and configuration information on a SQL Server database, it is possible to tweak the reports to run for 2017.

I checked each of the reports to see how what Base period they were using and then worked out what I needed to update to set the reports to run for similar periods in 2017.

Continue reading

Posted in Dynamics, GP, Management Reporter, Microsoft | Tagged , , , , , , , , , , | Leave a comment

Management Reporter Incorrect Figures Caused By Lower Case

A client reported a problem with Management Reporter returning incorrect figures when a link to the Financial Dimensions on the Row Definition had been entered in lower case.

The reports in question had been created in FRx which was rather more forgiving that Management Reporter is for these things. The client had quite a large number of reports which may, or may not, have had segments entered in lower case so the client didn;t want to have to check and update manually.

I again delved into the Management Reporter SQL database and updated the ControlRowCriteria table to capitalise the Low and High values of the link to financial dimensions using the script below:

UPDATE
   ControlRowCriteria
SET
   Low = UPPER(Low)
WHERE
   LEN(Low) > 0
GO

UPDATE
   ControlRowCriteria
SET
   High = UPPER(High)
WHERE
   LEN(High) > 0
GO

Once the update had been run, the client checked their reports and confirmed that they were now returning the correct figures.

Posted in Dynamics, GP, Management Reporter, Microsoft | Tagged , , , , , , , , , | 2 Comments

Management Reporter Is Unable To Connect To The Company

A client was recently having problems with the Microsoft Dynamics GP Datamart in Management Reporter 2012, so I removed the DDM and installed the Legacy GP Connector. I tested it on the server and all worked okay so I asked the user to try.

Unfortunately, it didn’t just work and they got the below error:

Management Reporter - Unable to connect to the Management Reporter – Unable to connect to the ‘{company}’. The connection to the Microsoft Dynamics GP database failed. Contact your system administrator.

Continue reading

Posted in Dynamics, GP, Management Reporter, Microsoft | Tagged , , , , , , , , , , , | Leave a comment