Many companies utilize Integration Manager to import data into Microsoft Dynamics GP.   Integration Manager allows users to quickly map their source data to an appropriate data object and safely import master records and transactions into Dynamics GP.

With the use of Scripts, users can expand the functionality of Integration Manager to better manage their source data and increase their options importing and updating data within Dynamics GP.   All too often users need to open and manipulate their source files prior to import.  Much, if not all, of this work can be accomplished through the use of scripts.

Scripts can be incorporated at multiple stages of your Integration.  They can be added to fields within the Destination Mapping, to Source Queries and before/after the actual integration.

Integration Manager includes a Visual Basic Script Library which provides common scripts you can utilize without programming or scripting knowledge.  Examples of some common scripts are setting document types based on an amount column, removing special characters and concatenating source file fields. Advanced scripting can be added as well for tasks such as database lookups, renaming and removing source files, SQL Insert and Update Statements, etc.

Integration Manager scripting is a powerful, time saving feature.   Consider reviewing your existing integrations for opportunities to add scripting.

OTT, Inc., is a Microsoft Dynamics Gold Certified Partner and member of Microsoft Dynamics President’s Club for 2012 and Accounting Today’s Top Var 100 list for 2012.

By Craig Conzemius, Senior Consultant, with OTT, Inc., St. Paul, Minnesota. Leading Microsoft Dynamics ERP & CRM partner.

July 31, 2012 by OTT, Inc.

Email | Print

Ask The Author

Posted in ERP Software Information | Comments Off on Utilize Scripts within Integration Manager in Microsoft Dynamics GP

More Posts By OTT, Inc.

1. How to Streamline Supply Chain Management, Gain Greater Insights
2. Strengthen Inventory Management and Support Growth with ERP
3. Streamline Business Operations to be Productive and Profitable Anywhere, Anytime
4. What Are You Waiting For? Get the Data You Need, When You Need It
5. Things to Know for Analytics & Reporting in Dynamics GP

Related Posts

1. Dynamics GP – Love at First Sight!
2. What’s New In GP 2010 (GP 11)
3. New White Paper! Learn 4 Keys to Successful Government Contracting
4. Top Ten ERP Software Blog Posts for 2012
5. “Make Room Make Room” . . . Microsoft Dynamics GP Runs Out of Space