We assume that in your case you have established Microsoft Dynamics GP (also known as Great Plains Dynamics in the past) and use it in production for accounting, Sales Order Processing, AP, AR, distribution and logistics.
Plus you have working ecommerce website, where integration to GP is very loose: maybe it triggers email to Picking and Packing department, or Sales Order Processing people. In this small publication we would like to review relatively open for end user or in the case of software developer - not difficult to begin integration coding. We do not specifically review here differences between B2B and B2C ecommerce scenarios in Dynamics GP, please review our past articles. There are ready for deployment solutions, we assume that you already did this homework and decided to preserve your investments into your current eCommerce web application, and all you would like to do is robust integration:
1. Real Time versus Batch Mode integrations. Real Time ecommerce transactions move to GP Sales Orders or Invoices is definitely cool to have, however if this is not absolutely required, we recommend you first to think about Batch Mode ecommerce integration. Batch mode means, that ecommerce may have some lookups for your customers if item is available in one of your warehouses (via simple SQL query to your Dynamics GP Company database), however ecommerce transactions are moved to GP Sales Document only once per day, or maybe every hour, if you are larger ecommerce retailer
2. GP Integration Manager. This tool is very friendly to Great Plains users, and it could be extended by programmer via VBA event driven scripts. IM is first choice if you are planning integrate in Batch Mode. Please, do not be mislead by some GP consultants, that IM is for text files only. For advanced ecommerce integration to GP we recommend you to base IM data queries on SQL Server Views (Advanced ODBC based query) and the View itself looks at the existing GP orders and lines and into new ecommerce document - in that case your scenario could be completely automated. Plus IM integration could be called automatically via Windows macro third party tiny applications (or you can purchase Integration scheduling tool from Microsoft Business Solutions, check with your Dynamics GP Partner on that). We helped implement scenarios for large Computer IT integrator and warehouse, where all transactions are coming through B2B ecommerce website on PHP/Linux and GP Integration Manager is scheduled to run every 20 minutes to be close to real time mode integration. OK, now if you think IM is too simple, let's move on to eConnect
3. eConnect SDK and technology for Dynamics GP. If you are C# or VB.Net ecommerce programmer or programming savvy web master, please review eConnect, as it has set of libraries, which could be added to your MS Visual Studio web projects and you could create, edit, delete virtually all GP Master records: customer, vendor, GL account, Item, Address, Employee, and work transactions: Sales Invoice, Purchase Order, Purchase Receipt, GL Transaction, Customer Payment. Please, note that you cannot post GP Batches (such as popular in ecommerce scenarios Sales Order Processing Batch) - if you need complete automation with Batch Posting you need to consider Alba Spectrum Posting Server or Autopost. Also, eConnect doesn't cover some rather historical modules, such as Invoicing (usually Great Plains Customers prefer more robust Sales Order Processing module). And plus, eConnect from Dynamics GP doesn't cover third party Dynamics GP ISV modules, which you may deploy - consider to check with you Great Plains ISV partner if they have extensions for eConnect. If you are on Dynamics GP 10.0 and 9.0 - eConnect is the way to go, however if you are on older version, consider to upgrade to GP version 10.0 prior to deploying eConnect in your ecommerce integration programming
4. Beyond eConnect. If you believe that your integration is SOP only and it is very simple, we offer Alba Spectrum Order Connector. This tool supports all current versions: 10.0 and 9.0 plus older versions: 7.5 and 8.0. You can also combine some Great Plains Dexterity programming to alter business processes in GP as additional help to Integration. We are trying to discourage you from considering direct SQL Server Stored procedures coding, as eConnect already have this work done for you - its initial layout is encrypted MS SQL Server Stored Procedures, plus consider the fact that Dynamics GP Business Logic and Data Flow is complex, and its database is not protected from inexperienced SQL programmer - you can compromise data integrity and incur additional unexpected expenses in involving GP Technical consultants to do data recovery and repair
5. How to get help? Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com We are very technical and real Dynamics GP Dexterity, SAP Business One SDK programming gurus. We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs. Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants. If you prefer skype: albaspectrum
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
