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:
2.) Variable Allocation
3.) Fixed Allocation
4.) Unit Accounts
PR Manual Checks
Sales Order Processing Transaction
Exchange Rate Setup
Integration Assistant for Excel(Business Object Integrations)*
*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.
Integration Manager and Integration Assistant for Excel can use the following data sources.
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
* 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.
Article ID: 853452 - Last Review: 28 Dec 2014 - Revision: 1