Integration Manager error when running a Sales Order Processing integration

Microsoft Dynamics GPI created an integration recently using Integration Manager for a client to import sales invoices into Microsoft Dynamics GP. It worked fine when I was developing it, logged in as DYNSA, and for one of the finance teams managers, but produced an error for the user:

Integration manager error log
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 2 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 3 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 4 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 5 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 6 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 7 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
Integration Failed
Integration Results
7 documents were read from the source query.
7 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
7 failed to integrate.

I toggled the Integration Manager ini file parameters so I could see what was happening with the windows to get an indication of the problem. The first window opened was Sales Order Processing Setup; why tis opened I’m not sure, but the user didn’t have permissions for this window. I did a quick test by copying the users security to a test account and added access to that window and the integration ran through without a problem.

This seems to be an operating as designed thing, but it seems odd that the SOP Setup window needs access.

“The vendor has an existing purchase order…” error message when using Integration Manager

Microsoft Dynamics GPI’ve recently been working with a client to implement Microsoft Dynamics GP and have been using Integration Manager to import the opening data. While importing payables transactions I encountered the following error:

The vendor has an existing purchase order error
The vendor has an existing purchase order. Choose Continue to post or save. Choose Go To to view a purchasing navigation list. Choose Cancel to return to the window...

Continue reading ““The vendor has an existing purchase order…” error message when using Integration Manager”

Hands On with Microsoft Dynamics GP October 2019 Release: Integration Manager first run

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. With Integration Manager installed there is one last thing which you need to do, and that is run it as administrator and enter the registration key.

Find Integration Manager on the Windows Start menu and right click and select Run as Administrator. When it starts, click the Register Now button:

Integration Manager

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Integration Manager first run”

Hands On with Microsoft Dynamics GP October 2019 Release: Install Integration Manager

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. Integration Manager is installed from the installation media.

To install it, launch the Setup utility and, under the Additional Products heading, select Integration Manager:

Setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install Integration Manager”

Hands On with Microsoft Dynamics GP October 2019 Release: Integration Manager prerequisites

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. In this post, I’m going to take a quick look at the prerequisites for Integration Manager.

Integration Manager has two adaptors available for integrating data into Microsoft Dynamics GP.

The first adaptor is the Microsoft Dynamics GP one which requires you to have the Dynamics GP client open and logged into the company into which you want to integrate data.

The second adaptor is the eConnect one; this requires eConnect to be installed, although it doesn’t need the Incomging/Outgoing queues installed within eConnect which is different to the earlier post on installing eConnect; it also does not require Dynamics GP installed.

Hands On with Microsoft Dynamics GP 2018 R2: Integration Manager First Run

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

Now that we have Integration Manager installed, we can run it.

Running Integration Manager as administrator is required to ensure that relevant permissions are correctly set; the license key also needs to be installed.

Launch Integration Manager from the Windows Start menu by right-clicking and selecting Run as Administrator. Once it has started, a Register Now/Later dialog will be displayed. Click Register Now:

Integration Manager - Run Now

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Integration Manager First Run”

Hands On with Microsoft Dynamics GP 2018 R2: Install Integration Manager

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 R2 was released on the 2nd October. In this series of posts, I’ll be going hands on and installing the majority of the components; some of them, such as Analysis Cubes for Excel, which are little used, I won’t be covering.

The series index will automatically update as posts go-live in this series.

In the last post, I installed eConnect on the client to make the eConnect adaptors available to Integration Manager; in this post, I am going to install Integration Manager.

To do this, launch the setup utility and select Integration Manager from under the Additional Products heading:

Integration Manager

Continue reading “Hands On with Microsoft Dynamics GP 2018 R2: Install Integration Manager”

Integration Manager Bugs Fixed in Microsoft Dynamics GP 2018

Microsoft Dynamics GPEarlier in the year we added a new ERP Support Analyst to our support team and we’ve been doing training to bring him up to speed. While I was doing Integration Manager training, I was giving him some cuationary advice about error messages and tried to reproduce some of the annoying errors I’ve encountered in the past, only to find out that three of them have been fixed without me realising.

The fixes are:

Debugging Integration Manager Crashes

Microsoft Dynamics GPWe’ve had two separate clients recently log calls where Integration Manager was crashing while performing an integration.

The first client was doing an Inventory Items integration on Microsoft Dynamics GP 2015 R2 and the other was doing a Sales Transaction integration on Microsoft Dynamics GP 2016 R2.

Both of the integrations had been running fine for quite a long period of time before starting to crash; no changes had been made to either system and I’ve not been able to determine why Integration Manager (IM) has started crashing.

However, by the use of two ini file switches, we were able to determine what error was being encountered by IM resulted in a crash.

The two switches are already present in the ini file (C:\Program Files (x86)\Microsoft Dynamics\Integration Manager nn/Microsoft.Dynamics.GP.IntegrationManager.ini by default) where the False value needs to be changed to True:

[IMGPPrv]
ShowDynamics=False
DoUIRedraw=False

When these switches are set to True, the Microsoft Dynamics GP windows are not hidden when the integration runs.

We found that for the Inventory Items integration, accounts either didn’t exist, didn’t allow account entry or were inactive; for the Sales Transaction integration, Analytical Accounting (AA) had been enabled for one of the accounts and the integration didn’t handle AA.

I created a VB script for the Inventory Items integration to check the accounts in the Before Document script and cancel the document if the account was going to be a problem.

Hands On With MDGP 2018 RTM: Integration Manager First Run

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 Integration Manager now installed, the final step in it’s installation is to run it and enter the license key.

It is important that the first time Integration Manager is launched, you do so by right clicking and selecting Run as Administrator; this ensures that Integration Manager has sufficient privileges for writing the necessary registry entries.

When Integration Manager starts, you will be presented with a Register Now/Later window; to use Integration Manager, a licence key must be entered, so click Register Now:

Integration Manager: Register Now

Continue reading “Hands On With MDGP 2018 RTM: Integration Manager First Run”