Leverage the benefits of Great Plains with custom WCF services

By | December 31, 2013

I know this is Sage 300 ERP blog. But one of our Sage partners came up with this challenging request in GP and it was a very exciting experience for our Custom Development team to work on something new and exciting. They have been working on sharing salesforce tips recently.
Anyways, in this, our client wanted a custom WCF service using which he can use to exchange data with Microsoft Great Plains.
READ ALSO: Convert your MS Dynamics GP database to Sage 300 ERP
The custom WCF service accepts the request in  XML format and gives response by processing the request.  Below are some basic feature of the WCF service –
Extract data from Great Plains –

  • Account Structure i.e. cost center, divisions, etc.
  • Sales person by invoices
  • Aging details by Accounts

Create data in Great Plains –

  • Vendors
  • Purchase Orders

In this custom web service, we made use of eConnect web services of Microsoft Great Plains. We extracted most of the details using  eConnect. However, if we did not find any specific details, then we queried the Great Plains SQL server database to fetch the data. Since we are using WCF services, it provides a rich level of security during data exchanges without compromising on the speed performance.
Since this is custom service, this can be tailored to meet more specific details of users. Need more details about the service, just drop us a mail at erpmig@greytrix.com.
Related Posts:

  1. What do you want to migrate to Sage ERP
  2. Data migration from your accounting system to Sage ERP
  3. Migration of Purchase Payment from QuickBooks to Sage 300
  4. Migration of Banks from QuickBooks to Sage 300 ERP