A Flexible Import Framework for Microsoft Dynamics GP Integration with Third-Party Services

For many companies, Microsoft Dynamics GP is not the only software generating financial transactions. The implementation of third-party applications, such as point-of-sale terminals and web stores are vital to the operation of today’s businesses. The challenge is bringing all of those data elements together in Dynamics GP so a comprehensive and accurate view of the company’s financials can be maintained.

As the data structure for each third-party solution is different, and no unified standard of financial data exchange has been established, our technical consultants at the TM Group, a leading Microsoft Dynamics GP partner based in Michigan, developed a flexible data import framework we’ve successfully deployed for several clients.  By using the data import framework we can easily import third-party data provided via FTP sites, web service calls, SQL queries, as well as many other data sources into Microsoft Dynamics GP.

Our Microsoft Dynamics GP  import framework processes data from virtually any third-party source.  The data is validated against the accounting rules in Microsoft Dynamics GP as well as company-specific rules, and then imported into Dynamics GP using web services or eConnect transactions.  Data can also be exported from Dynamics GP to the third-party applications allowing us to maintain synchronous data between both systems.

For one of our clients, a franchise restaurant company, we used this technology to import data from MyMicros, a restaurant point-of-sale device, with Microsoft Dynamics GP. We also implemented integrations with Waterstreet, a franchise sales management tool.

We helped another client,  a private university, with their need to integrate to CashNet, their point-of-sale terminals.  We use our data import framework to import GL Transactions from CashNet into Microsoft Dynamics GP.  We also export the available GL accounts from Dynamics GP to the CashNet service to update the point-of-sale terminals.

We’ll continue to post other examples from our clients about their growing needs for integrating third-party systems to Microsoft Dynamics GP.   If you’d like more information about the Microsoft Dynamics GP data import framework solution developed by The TM Group’s Microsoft Dynamics custom development team, feel free to contact me at kenj@tmgroupinc.com or call 888-482-2864. 

By The TM Group, a Michigan Microsoft Dynamics Partner for Microsoft Dynamics GP, Microsoft Dynamics SL, Microsoft Dynamics NAV, Microsoft Dynamics CRM and Microsoft Office SharePoint Portal Server

Related Posts

1. 3 Ways To Import Data Into Microsoft Dynamics GP – Integration Manager, eConnect & Web Services
2. Integration Framework for Microsoft Dynamics GP and Microsoft Dynamics CRM
3. FAQ: Integration of SQL Server Reporting Services with Microsoft Dynamics GP 2010