Microsoft Dynamics GP ECommerce Partner in Los Angeles Notes

Mar 18
09:19

2010

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

There are several approaches to eCommerce implementation for mid-market Corporate ERP applications, such as Microsoft Dynamics GP or SAP Business One. The first one is to redeploy ecommerce on new product or ecommerce add-on - here you have to sacrifice former investment into custom ecommerce web application and make new ecommerce implementation.

mediaimage
Second approach is to capitalize on the old investment into legacy custom ecommerce application and integrate it with Dynamics GP via custom connectors.  We are favoring the second approach and this small publication should give you initial highlights on ecommerce integration programming:
1. Integration Manager - batch mode ecommerce integration.  If you do not need real time (or quasi real time - say every half an hour) ecommerce transactions integration and you can simply export ecommerce transactions into text file or expose ecommerce SQL tables via ODBC DSN - then you may decide to use Dynamics GP Integration Manager module,Microsoft Dynamics GP ECommerce Partner in Los Angeles Notes Articles where you setup Sales Order Processing documents integration and call it on demand (maybe every morning or every night).  Yes, it might be that simple and you can reduce your proposed ecommerce integration budget to just purchasing GP Integration Manager and if required ask for Dynamics GP consultant help in setting up the integration
2. eConnect.  This is Software Development Kit with code samples in C# and VB.  If you consider yourself as experienced or even moderate Microsoft Visual Studio .Net programmer with some SQL and XML expertise - you can explore eConnect and make self discovery.  Programmatically you can create SOP transaction (such as ecommerce Invoice, Sales Order or Quote) and place it into the Work batch for future approval in Great Plains and posting by the GP user.  eConnect can do real time integration as single transaction integration could be event driven (when ecommerce customer places the order).  If you are about to decide to take eConnect route - we recommend you to upgrade Dynamics GP to current version 11.0, or at least 10.0 (9.0 at minimum), as we believe that eConnect came to its maturity for GP 10.0
3. eConnect automatic batch posting.  In order to post batches directly from your ecommerce web application you need Alba Spectrum Posting Server.  This add-on is programmed in Great Plains Dexterity with the references to Dynamics GP Source Code (original Dexterity Sanscript codes in Dynamics.dic, available to Source Code Partners)
4. eCommerce Order Connector.  This add-on is written in SQL stored procedures with simplified logic, which should potentially be very time efficient.  Plus Order Connector should be compatible with legacy versions of Great Plains: 9.0, 8.0, 7.5, 7.0 (assuming that you are on MS SQL Server DB platform)
5. Great Plains eCommerce and version consideration.  If you are on older version of Great Plains Dynamics or eEnteprise - consider Integration Manager as reasonable approach, as IM is available with most of the versions down to version 4.0 (5.0, 5.5, 6.0 and up)
6. Local Dynamics GP eCommerce support in Los Angeles, Orange County and San Diego.  We have two offices in Los Angeles and Carlsbad to cover Southern California metro area.  Our consultants speak Spanish (Mexican and South American connection), Chinese (Asian connection and Port of LA), Portuguese (Brazilian connection, where we recommend SAP Business One for your Brazilian subsidiary), Russian (connection with Russia, where we recommend SAP B1 and 1S Bukhgalteria as well as Microsoft CRM for locations in Moscow)
7. Give us a call: 1-866-528-0577. Or email us: help@albaspectrum.com