Microsoft Dynamics GP Great Plains web integration overview
by: Andrew Karasev
eCommerce highlights for Microsoft Great Plains Dynamics GP eConnect with XML Web Services, Automatic posting, cross platform integrations with Oracle, IBM Lotus Notes Domino
Microsoft Great Plains should be considered as open platform for eCommerce web development, especially since such development tools as eConnect were introduced for .Net C# and VB web developers. However there are certain limitations in utilizing these new tools, especially when business processes requires full automation, including autoposting and automatic sales orders execution. In this small article lets take a look at the technology highlights and work around:
eConnect. If you think that eConnect is panacea this is true with some limitations. You should understand that eConnect automates only subset of Microsoft Dynamics GP modules: SOP, POP, AR, AP, but at the same time other modules are outside of eConnect scope good example Invoicing module. Besides standard GP modules you as developer should be aware about third-party modules, such as Mekorma, Avalara, DynamicsZip, Horizon Manufacturing, etc. These modules are typically created with Microsoft Great Plains Dexterity and are also outside of the eConnect scope
Posting Issue. eCommerce often requires automatic invoice posting, especially when customer pays online via credit card. eConnect allows you to create order or invoice and receive deposit against this order, but it doesnt allow you to post the order this is reasonable restriction, because you as developer should create business logic for invoice posting and deploy Microsoft Great Plains posting logic, which might be very sensitive to your specific GP settings
Cross-Platform. You have two options: resolve cross-platform data streams with XML inbound and outbound streams. In this case eConnect XML web services interface is the way to go, plus you should supplement eConnect with your own XML web services (having SQL heterogeneous stored procs behind) and the second way is deploying either linked server from MS SQL Server side and stored procedures or similar tools from Oracle to create ODBC JDBC connection
Please, do not hesitate to call us: 1-866-528-0577, 1-630-961-5918,
[email protected] or skype: albaspectrum
About The Author
Andrew Karasev, Alba Spectrum Group (
http://www.albaspectrum.com http://www.enterlogix.com.br ), serving MS Dynamics GP, SAP Business One, Oracle EBusiness Suite to clients in USA nationwide: Chicago, Houston, New York, Boston, San Francisco, San Diego, Los Angeles, Phoenix, Atlanta, New Orleans, Miami, Orlando, Tampa, Minneapolis, Denver, Washington, Seattle, in Canada: Toronto, Montreal, and internationally: Australia, New Zealand, UK, Spain, Mexico, Brazil, Asia
