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;
Continue reading “Integration Manager Error – MSScriptControl”
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;
Continue reading “Integration Manager Error – ADO Field Is Nothing”
I am in the process of implementing Microsoft Dynamics GP for a new client and am currently testing the static data integrations (chart of accounts, suppliers, customers, stock and so on) using Integration Manager.
I’d successfully run an integration of the chart of accounts which threw out a couple of warnings. After amending the file I realised that GP was no longer showing in the task bar and assumed that I had accidentally closed it. I restarted it and logged into the test company and tried to run the COA integration again and got the following error message;
Continue reading “Integration Manager Error – You Must Close All Microsoft Dynamics GP Windows”
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 “Fixing A Corrupt Account Index Master”
It 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 “Integration Manager Error: ADO Field Is Nothing”
I 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 “Integration Manager Error: Source Document ‘GJ’ Does Not Exist”