Dynamics GP eCommerce Solutions: Great Plains Order Connector and Posting Server Notes

If you plan to deploy Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise as back office accounting and sales order processing system, you should make your homework in understanding your Great Plains ecommerce integration tools and options.  We are favoring so-called “Solutions” approach, where we offer ecommerce codes and scripts, plus our service in tuning these solutions to fit your unique business processes.  This approach is especially good, when you are not starting from the ground, when you already have ecommerce website in production, which is in time very loosely integrated with your Accounting system (typically email is sent to the GP AR clerk, or even paper printed Sales Order).  Let us give you several ecommerce scenarios:

1. SOP Order Connector.  This product is the set of SQL Stored Procedures, allowing you to feed Sales Order or Invoices to Great Plains Sales Order Processing tables.  This product doesn’t use eConnect encrypted stored procedures and you can get instant real time or large volume batch mode integration in a few seconds.  Order Connector works with Dynamics GP 10.0, 9.0, 8.0, 7.5 and earlier Great Plains Dynamics versions, assuming that you are on Microsoft SQL Server DB platform

2. Posting Server.  This product allows you to break through eConnect restrictions and post SOP, POP and batches of virtually all the natures in Dynamics GP directly from your ecommerce application (written in C#, VB.Net or any other programming language, allowing you to call SQL Stored Procedures)

3. eConnect scripts.  We also offer packages of eConnect samples to automate ecommerce to SOP and ecommerce to Receivables Management integrations.  We recommend you to take eConnect programming route if your Great Plains version is recent: 10.0 or 9.0.  If you are on legacy version of Dynamics GP Great Plains: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0 or earlier, please review stored procedures or Order Connector route

4. Sales Order Transfer to Invoice.  It is common practice, when you are first creating Sales Order (especially when you are working in B2B model with some negotiation) and then from ecommerce web page your customer decides to turn Sales Order to Sales Invoice.  This functionality is realized in Alba Spectrum Posting Server, please read about it in Paragraph #2

5. Dynamics GP Integration Manager in eCommerce scenarios.  IM is intuitive and end user friendly tool, however you could raise integration complexity with VBA scripts: Before Document Commit is one of the most popular.  We offer help in guru level IM Sources, especially Advanced ODBC.  IM Integration could be called on demand by Great Plains user (preferred) or scheduled for execution by Windows macro (or third party Windows macro surrogates)

6. Direct SQL Insert or Inhouse Custom Stored Procedures.  We also respect this route, taken by your IT department, in this case we offer short orientation training on Great Plains Tables Structure and data flow

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



Source by Andrew Karasev

Leave a Reply