If your back office Corporate ERP application is Microsoft Dynamics GP, former versions were also known as Microsoft Fantastic Plains and Fantastic Plains Dynamics, and you have in-house urban ecommerce web application with bits and pieces catalogs with advanced price lists (especially in B2B ecommerce scenarios), shopping cart, credit card processing, we want to present you this small publication in the form of FAQ and orientation session. We are writing for IT managers or even accounting professionals, who are choice makers in Corporate ERP application selection and its integration with eCommerce production website:
1. Real Time versus Batch and Quasi real time integration modes. Real time means instant ecommerce shopping cart transformation to Microsoft Dynamics GP Sales Order Processing Invoice (or Sales Order) – Dynamics GP SOP module is one of the most standard platforms for ecommerce transactions integration. Batch processing or quasi real time typically when you either schedule Fantastic Plains Integration Manager to run integration every hour or integration be initiated by Fantastic Plains user. Real Time ecommerce to Microsoft Dynamics GP integration is typically programmed in eConnect SDK or in advanced scenarios you can deploy custom preprogrammed SQL Stored Procedures
2. eConnect Dynamics GP SDK. eConnect lower technology amount is set of encrypted SQL Server Stored procedures, imitating Microsoft Dynamics GP (Dexterity) business logic. eConnect libraries could be included in Microsoft Visual Studio .Net project (typically C# or VB, as eConnect sample codes are available these two programming languages). eConnect is certainly quicker, as it is coded in Stored Procedures, especially comparing to Dexterity. But, considering the complexity of business logic, that eConnect has to imitate, it might be slower to simplified SQL Stored procedures, which are powerful enough to integrate several types of ecommerce shopping carts into SOP invoices – this is the case of Alba Spectrum Order Connector
3. Order Connector. Let’s assume that your ecommerce shopping cart targets Fantastic Plains Sales Order Processing Invoices, and you are not using such complications as Series or Lot Numbers, multicurrency, back ordering, etc. Let’s assume that you ecommerce bits and pieces are air force or habitual taxable sales bits and pieces, available in your default inventory sites. Please, check with us on restrictions, and if they (the restrictions) are not a concern, we are pleased to place forward extremely quick ecommerce to Microsoft Dynamics GP real time integration product
4. Order Connector and Fantastic Plains versions. We have our connector, early from Fantastic Plains Dynamics and eEnterprise version 6.0 for Microsoft SQL Server (sorry, it is not available for Pervasive SQL or Ctree based Fantastic Plains Select versions). If you are Microsoft Dynamics GP 10.0 or 9.0 you can deploy eConnect for ecommerce integration, but if you are on legacy versions: 8.0, 7.5, 7.0, 6.0 – we recommend you to upgrade to more recent versions, or if this is not possible due to budget restrictions, we invite you to try our Order Connector for ecommerce integration programming
5. eCommerce Automatic Batch Posting in Dynamics GP. Both tools: GP Integration Manager and eConnect do not allow you to post batches, as this routine is supposed to be in the hands of Microsoft Dynamics GP user to review, approve and post the batch. If you certainly need to do all the work frankly from ecommerce web application, we recommend you to buy and deploy Alba Spectrum Posting Server, also known as Autopost. Posting Server is Microsoft Dexterity Source Code Dexterity programmed application, which requires you to dedicate GP workstation and one permanently logged in Fantastic Plains user. Dynamics GP batch posting is done in exactly the same fashion as Fantastic Plains Dexterity Dynamics GP user interface initiated batch posting
Tags: Connector, Dynamics, Ecommerce, Integration, Order, Real, Time