Implementing Jet Express: Installation

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Express sub-series.

Once you have ensured the prerequisites are met and have downloaded the software, Jet Express for Microsoft Excel with Microsoft Dynamics GP can be installed.

To launch the installer, double click the Jet Express Setup.exe. Click Install to start the installation:

Jet Setup

Continue reading “Implementing Jet Express: Installation”

Expiration Dates on Exchange Rates

Microsoft Dynamics GPI’ve been doing some work with a US-based company as they implement Microsoft Dynamics GP in Europe for one of their subsidiaries (we do a fair bit of this type of work for expertise with VAT and Intrastat). One of the issues they asked for assistance with was a problem they had while importing transactions.

All of the transactions which were in the functional currency, imported without a problem, but all of those in other currencies failed.

The cause of the problem was actually quite a simple one, and one I have seen before with other clients. On the Multicurrency Exchange Rate Maintenance window, there is an Expiration date field:

Multicurrency Exchange Rate Maintenance

Continue reading “Expiration Dates on Exchange Rates”

Configuring Workflow to use Gmail for Email Notifications

Microsoft Dynamics GPI’ve done a lot of work around the Microsoft Dynamics GP Workflow module and have configured Email Notifications to work with numerous different SMTP servers. One recent one we configured was Gmail.

This was not actually as straightforward as configuring other SMTP servers as the details Google publish are not accurate in that the port they list for SSL is not the correct one.

The settings required are below:

Workflow Setup

Continue reading “Configuring Workflow to use Gmail for Email Notifications”

Hands On With MDGP 2018 RTM: Configure & Use OData Service

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.

In the last post, I covered the installation of the GP OData Service. However, I am not going to cover the configuration and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

I am planning to do some work with Odata in the near future, and am likely to blog about it when I do.

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

Hands On With MDGP 2018 RTM: Configure Web Services

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.

After installing the Web Services for Microsoft Dynamics GP, the next step is to run the Web Services for Microsoft Dynamics GP Configuration Wizard.

This is available via the Windows start menu; once running, click Next on the Welcome step:

Microsoft Dynamics GP: Welcome to the Web Services for Microsoft Dynamics GP Configuration Wizard

Continue reading “Hands On With MDGP 2018 RTM: Configure Web Services”

Hands On With MDGP 2018 RTMS: Set eConnect Incoming Queue Permissions

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 the eConnect Service and the eConnect Incoming Queue configured, the final step is to configure permissions of the queue to accept messages.

Launch Computer Management from the Control Panel on the eConnect server. Expand the following nodes:

  • Services and Applications
  • Message Queuing
  • Private Queues

Right click on econnect_incoming and select Properties

Computer Management

In the Group or users names list, select Everyone and set Permissions for Everyone to Full Control. Click OK to accept the changes

Continue reading “Hands On With MDGP 2018 RTMS: Set eConnect Incoming Queue Permissions”

Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue

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 the eConnect Service configured, the next step is to configure the Incoming Queue.

This configuration change is done in the eConnect_Incoming.exe.config file which is located, by default, in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service\Incoming Service:

Windows Explorer

Continue reading “Hands On With MDGP 2018 RTM: Configure eConnect Incoming Queue”

Hands On With MDGP 2018 RTM: Configure eConnect Service

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 eConnect installed on the server, there are a couple of pieces of configuration which need to be done. The first is covered in this blog post, and that is the configuration of the eConnect Service.

Perfect Image maintain and support a Dexterity Extension written by a company which is no longer a Microsoft Dynamics partner; this customisation receives transactions via eConnect from an external line of business system. The default configuration results in timeouts if the eConnect service isn’t configured to receive large messages; which basically means adding the following to the Microsoft.Dynamics.GP.eConnect.Service.exe.config file:

receiveTimeout="infinite"

To add this element to the bindings node of the configuration file, open Windows Explorer and navigate to the file in C:\Program Files\Microsoft Dynamics\eConnect 18.0\Service.

Edit the node so it looks like the below and then save the file:

Notepad

Stop and restart the eConnect service to ensure the change is picked up.

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

Hands On With MDGP 2018 RTM: Deploy Sample Company

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 the system database deployed, the next step is to deploy the Fabrikam, Inc. sample company.

To do this, launch GP Utilities and log in using the sa account:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With MDGP 2018 RTM: Deploy Sample Company”

Copy Posting Report Configuration Between Companies

Microsoft Dynamics GPI wrote the first version of this script a long time ago, but recently had cause to return to it. A client I am working with has configured the posting reports in one company and wanted to copy the same configuration to the other companies.

This script allows you to do this, on a one by one basis. Set the first highlighted parameter to the source company, and the second to the destination company.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
DECLARE @SQLStatement VARCHAR(8000)
DECLARE @SourceCompany VARCHAR(5) = 'T16R2'
DECLARE @DestinationCompany VARCHAR(5) = 'P16R2'

SET @SQLStatement = 'UPDATE
				['Destination Posting Journal Destinations']
			SET
				PRNTJRNL = ['Source Posting Journal Destinations'].PRNTJRNL
				,ASECTMNT = ['Source Posting Journal Destinations'].ASECTMNT
				,PRTOPRNT = ['Source Posting Journal Destinations'].PRTOPRNT
				,PRTOFLNT = ['Source Posting Journal Destinations'].PRTOFLNT
			FROM
				' + @DestinationCompany + '.dbo.SY02200 AS ['Destination Posting Journal Destinations']
			INNER JOIN
				' + @SourceCompany + '.dbo.SY02200 AS ['Source Posting Journal Destinations'] ON ['Source Posting Journal Destinations'].SERIES = ['Destination Posting Journal Destinations'].SERIES
					AND ['Source Posting Journal Destinations'].TRXSOURC = ['Destination Posting Journal Destinations'].TRXSOURC
					AND ['Source Posting Journal Destinations'].PTGRPTNM = ['Destination Posting Journal Destinations'].PTGRPTNM'
EXEC (@SQLStatement)

As always with an SQL script, please make sure you have a good backup before running it.