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. Destinations 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 Customers Receivables Transactions Cash Receipts Vendors 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 Budgets Vendors PM Transactions Customers 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.Differences Between Integration Manager and Integration Assistant for Excel
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.