Integrations for Dynamics GP

By definition from Microsoft, eConnect is a library of tools, components, and interfaces that allow applications to programmatically interact with Dynamics GP. It uses XML to import or export data and leverages the existing transaction-based business logic of Dynamics GP, which is a top benefit of using this tool. The key eConnect components and interfaces include:

• A .NET managed code assembly
• A Microsoft BizTalk® Application Integration Component (AIC)
• Microsoft Message Queuing (MSMQ) services

These eConnect interfaces allow external applications like web storefronts, point-of-sale systems, time-clocks, Epic software healthcare applications, or legacy applications to integrate with Dynamics GP. The external applications can perform actions like creating, updating, retrieving, and deleting records and transactions in GP. Although eConnect supplies a large number of documents, not every Dynamics GP feature is available through eConnect so other tools may be necessary.

The web service for Dynamics GP provides access to the primary documents in the accounting system. Some of the document types include:

• Customers
• Vendors
• Sales documents
• Purchase documents
• Receivables transactions
• Payables transactions
• General ledger transactions
• Accounts

Through the web service, integrated applications can retrieve documents, create new documents, update existing documents, and delete or void documents. The web service for Dynamics GP is fully integrated with the Dynamics Security Service. The administrator of the web service can configure security so only specified users are allowed to perform actions like creating or updating sales documents.

Using a Graphical User Interface, the Integration Manager for Dynamics GP is a user-friendly tool designed to move data quickly and easily from an outside data source into GP. The benefit of using the Integration Manager is that additional programming or extensive knowledge of the underlying databases is normally not required. It allows users to create an integration by specifying sources such as text files or ODBC databases and setting up the mapping to the destination file in GP, such as the Customer card, Payroll Employee record, or a transaction record. Examples of integrations using Integration Manager are the transferring of hours worked by each employee from the time-clock system to GP, the passing of patient billing information from Epic patient engagement software used by hospitals and clinics to GP and the import of sales information into GP from MICROS point of sale. Integration Manager can be scheduled to run daily, weekly, monthly, or whenever it is necessary for data to be moved from the source to Dynamics GP.

Sometimes the only way to accomplish the desired movement of data is by writing SQL jobs to push and pull data within or between Dynamics GP, WennSoft, Binary Stream and other ISV solutions. Our SQL programmers are experts in doing this for our clients and are available to assist you.