Dynamics GP ecommerce programming: eConnect, Dexterity, SQL Scripts

If you already have Microsoft Dynamics GP, formerly known as Great Plains Dynamics, implemented in your company, and you also have established and in-house supported ecommerce application, it is natural next step to automate integration.  Typically automation covers Catalog items synchronization and publishing from Dynamics GP Inventory Control module; Sales Orders or Invoices batch mode or real time integration from ecommerce web site to Great Plains Sales Order Processing module; new Customers creation and existing customers info update in ecommerce and moving or updating them in Dynamics GP Receivables Management module.  Sometimes you go beyond these basic integration routines and do Stock availability for specific item in specific warehouse or location; Sales order tracking, where you check order lines fulfillment in Dynamics GP SOP module with shipping via Starship or another FedEx or UPS tracking add-ons.  We are here to offer you help in tuning our existing custom solutions and scripts to expedite ecommerce integration projects, please read ecommerce integration highlights below:

1. eStore ecommerce server integration to Great Plains.  We offer scripts for eStore integration to Dynamics GP SOP, Receivable Management and Inventory Control modules.  We are happy to provide several case studies and customer references, where ecommerce is deployed on eStore and Dynamics GP tandem

2. eConnect coding.  With Dynamics GP eConnect SDK you can expect master records (customer, inventory item, address, vendor, etc.) and work transactions in the batch creation and update directly from your ecommerce C#, VB.Net application.  Again, here we are emphasizing Solutions approach, where we will give you integration codes and guide your eConnect MS Visual Studio programmers in tuning and deploying these codes

3. Microsoft Dexterity and eCommerce integration.  One of the obvious advantages in deploying Great Plains Dexterity engine is GP batches posting directly from your eCommerce application.  We have special product, dedicated to Posting Great Plains Batches automatically – Alba Spectrum Posting Server or Autopost.  It is written in Dynamics GP Dexterity and it deploys original GP Posting logic

4. SQL Scripting in GP ecommerce.  This approach is a bit challenging as you will have to imitate Dynamics GP business logic in direct SQL insert statements, and here we encourage you first to review eConnect, as it does exactly the same things in encrypted SQL Stored Procedures.  We have Dynamics GP Order Connector, this is the set of our custom SQL Stored Procedures and it enables ecommerce programmer to integrate Sales Order and Invoice directly to GP SOP module.  The advantage of Order Connector is high performance, comparing to both Dexterity and eConnect (as we use simplified business logic, assuming that you are following simple ecommerce integration rules)

5. Please, feel free to call us: 1-866-528-0577, help@albaspectrum.com