Do you encounter error messages when using Integration Manager in Microsoft Dynamics GP? Let Business Ready Solutions help you better understand the most common errors that users run into when using Integration Manager, and how to resolve them.

ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing

The ADO field is nothing error is caused when a user still has the data source file open. Whether it is a text file or csv in Excel you want to ensure that the data file is closed before running the integration as this will resolve this error.

The destination could not be initialized due to the following problem: – You must close all Microsoft Dynamics GP windows in order to run an integration.

This error occurs if you have any windows open in Dynamics GP. Closing all GP windows will resolve this error.

ERROR: Null value not allowed for field 'XXX'. Destination Field: XXXX

For the most part any Null Value errors usually point to issues with the source data. This can be missing data such as missing account number or a value in a cell. This also can be cause by blank lines below or above the data. Right clicking the source in your integration and choosing Preview is a good way to check if there are any blank lines in the source data. Deleting any blank rows or filling in blank data points will resolve this error.

ERROR: Integration manager object reference not set to an instance

This particular error can have several causes. The most obvious one is an issue with the source data if you have the data file open you will sometimes see this error occur. If you are able to preview the data by right clicking the source then it may be caused by the next issue. This error can also occur if GP has frozen and had to be reopened. If you open task manager you may find multiple copies of dynamics.exe running. If this is the case you want to exit Dynamics GP and in task manager end all other dynamics.exe processed. When you re-launch GP there should only be one instance of dynamics.exe and this should resolve the error.

Contact us or call us toll free 877-433-0650 if you have any questions about Integration Manager or any module of Microsoft Dynamics GP. We are here to help you leverage the tool to grow your business.