Category Archives: Integration Manager

Error Running Integration Manager For The First Time

Posted on 27th March 2012 by Ian Grieve

Well, they do say the old ones are the best. I recently installed Microsoft Dynamics GP on a client site and encountered the below error message when starting Integration Manager for the first time;

Integration Manager - Could not create all default data due to the following error: - Access to path 'C:\ProgramData\Microsoft\Microsoft Dynamics GP\11.0.0.0' is denied.

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , | 2 Comments

Integration Manager: “Argument ‘Start’ must be greater than zero”

Posted on 13th March 2012 by Ian Grieve

A client doing some work with Integration Manager 10 recently reported the following error when trying to load the VB Script Editor;

Integration Manager - Argument

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , | 2 Comments

Update Creditor Addresses From CSV To Work Around An Integration Manager Bug

Posted on 7th March 2012 by Ian Grieve

I was doing some work for a client recently where we were loading lists of new creditors into Microsoft Dynamics GP from CSV files via Integration Manager. There is, however, a bug in IM 10 where it adds extra zeros to the phone and fax number fields of both creditors and debtors. These extra characters are, rather bizarrely, not always at the end but can be interspersed in the phone number.

The easiest work around was to put together a SQL script for loading the phone and fax numbers from CSV file which I did while on site which updated only a single address on the PM Creditor Master (PM00200) and PM Address Master (PM00300) tables.

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , , , , , , , | 2 Comments

Integration Manager Error – MSScriptControl

Posted on 12th December 2011 by Ian Grieve

I’ve spent a fair bit of time recently importing data into Microsoft Dynamics GP using Integration Manager with which I have encounterd a few different error messages (ADO Field Is Nothing, All GP Windows Must Be Closed and Source Document Doesn’t Exist).

The latest error I’ve encountered related to the MSScriptControl;

Integration Manager - MSScriptControl Error

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , , | Leave a comment

Integration Manager Error – ADO Field Is Nothing

Posted on 7th December 2011 by Ian Grieve

During a recent implementation I was using Integration Manager to load data into GP and on one occasion I got the following message in the progress window;

Integration Manager Error - ADO Field Is Nothing

Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , | 1 Comment

Fixing A Corrupt Account Index Master

Posted on 4th November 2011 by Ian Grieve

A while ago I investigated an issue where some reports were not working correctly on a client system; they’d been written with Crystal and were not returning transactions for newly created accounts.

As reports I write tend to do, these reports were joining to the General Ledger via the GL Account Index Master (GL00105) table and then joining to GL Account Master (GL00100) for the account descriptions. I wrote the following script to check the two tables against each other to see where the problem lay (my suspicions were on GL00105 being corrupt as the accounts were being used within Microsoft Dynamics GP Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , , , | 3 Comments

Integration Manager Error: ADO Field Is Nothing

Posted on 31st August 2011 by Ian Grieve

Microsoft Dynamics GPIt seems it is a week for Integration Manager errors. Another client has logged an error when using Integration Manager. In this case, they were attempting to load a payroll journal using the GL Trx One Source File integration Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , | 1 Comment

Integration Manager Error: Source Document ‘GJ’ Does Not Exist

Posted on 30th August 2011 by Ian Grieve

Microsoft Dynamics GPI like dealing with Microsoft Dynamics GP as it is easy to use and is a very flexible system. I don;t enjoy using some of the related systems as much and most especially Integration Manager.

We have a few customers who use it for importing journals or invoices into the system from elsewhere and occasionally they encounter errors which are more than an incorrectly formatted file so they contact the helpdesk to log a call.

One such involved the below error message regarding the source document ‘GJ’ not existing Continue reading →

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , | Leave a comment