Differences Between Integration Manager and Integration Assistant for Excel

Question: What are the differences between Integration Manager and Integration Assistant for Excel?

Answer:The information provided relates tothe standard Dynamics/eEnterprise provider for Integration Manager. This does not cover the Direct to Table or the SQL Optimized providers. More information regarding those products can be found in their respective manuals.


The following are the destinations that Integration Manager and Integration Assistant for Excel allow you to integrate into.

Integration Manager Objects:

GL Accounts

1.) Posting

2.) Variable Allocation

3.) Fixed Allocation

4.) Unit Accounts

GL Budgets

GL Transactions

Bank Transactions

Bank Reconcile


Receivables Transactions

Cash Receipts


Payables Transactions

PR Master

PR Transactions

PR Manual Checks

Inventory Item

Inventory Transaction

Sales Order Processing Transaction

Exchange Rate Setup

Integration Assistant for Excel(Business Object Integrations)*

GL Accounts

GL Transactions



PM Transactions


RM Transactions

Cash Receipts

Bank Transactions

Bank Reconcile

*Integration Assistant for Excel does allow you to use the Build Desktop Application Integration wizard that will allow you to make custom integrations. This wizard will allow you to integrate into any module in Dynamics, as well as any third-party application written in Dexterity. Refer to the SanscriptSupplement.pdf file for more information relating to the Build Desktop Application component of Integration Assistant for Excel.

Source files

Integration Manager and Integration Assistant for Excel can use the following data sources.

Integration Manager

Text File (tab or comma delimited)

Microsoft Excel Spreadsheet

ODBCData Source(Tested with Microsoft Access, Microsoft Excel, Microsoft SQL Table, and Pervasive.SQL 2000)

Integration Assistant for Excel

Excel Spreadsheet

Other Differences

* Integration Manager allows the use of VBScripts in its integrations. Integration Assistant for Excel does not allow the use of VBScripts.

* Integration Manager allows you to schedule integrations with a scheduling program.

* Integration Manager allows you to perform data translations in the integration itself.

* Integration Manager and Integration Assistant For Excel do not allow you to integrate data to every field. To verify the field you want to integrate is available, open the Destination Mapping window to view the fields that are available.

This article was TechKnowledge Document ID:22989

The issue that is described in the Question section does not apply to Microsoft Dynamics GP 10.0.

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.