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 –
- 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 firstname.lastname@example.org.