Ecommerce For Dynamics Gp Notes: Econnect Batch Posting

Microsoft Dynamics GP is becoming very standard ecommerce ERP and accounting back office. This trend is probably related to success of eConnect SDK, especially for Dynamics GP 10.0 and 9.0 versions. eConnect allows you, being generic C#, VB.Net programmer with excellent SQL and XML skills to program Fantastic Plains objects manipulation: Customer, Address, Sales Invoice, Customer Payment and other attributes of ecommerce shopping cart. eConnect, being coded in SQL Server Stored Procedures (they are encrypted, so you probably should not expect to trace SQL code for Fantastic Plains business logic there). In this small publication we want to share with you ecommerce coding experience and Dynamics GP automatic batch posting from eConnect application frankly:1. Older versions of Fantastic Plains Dynamics GP. If you are on GP 8.0, 7.5, 7.0, 6.0, 5.5, 5.0 or earlier versions, we recommend you to upgrade to Dynamics GP 10.0 as for this version eConnect is really advanced. If you do not have registration key, probably due to the fact of lapsing in Dynamics GP Fantastic Plains once a year maintenance program, consider deploying Sales Order Connector, or set of SQL stored procedures, produced for ecommerce web developers of older Fantastic Plains version to connect ecommerce shopping cart with GP Sales Order Processing module, please call us for details. If you are on Pervasive SQL or Ctree, your options are very limited, you can still try to program ODBC connection to Pervasive SQL 2000 database, but then you will have to reprogram the logic, which is in fact available in eConnect (if you migrate from Pervasive to Microsoft SQL Server and upgrade to new version GP 10.0)2. Automatic Batch Posting. Here we evenly hear from ecommerce programmers the question – why eConnect doesn’t have the tools and logic to post Fantastic Plains SOP Batches (as well as post batches in other Fantastic Plains modules). The answer is in GP architecture (it is pretty common, and you should expect similar restrictions in other ERP and MRP platforms). The concept of ERP business transactions flow suggests you to use three phases of transaction life: work, open and historical. eConnect allows you to make work transactions, in Fantastic Plains these are newly produced invoices or sales orders, placed in the batch and submitted for Fantastic Plains user review and posting. In order to trigger Dynamics GP batch posting from eConnect application frankly – you have to deploy Fantastic Plains add-on – Alba Spectrum Posting Server3. Posting Server. It consumes one user license and deploys Dynamics GP Dexterity source code to trigger the same coded logic in Dexterity for batch posting. Autopost is targeted to eCommerce web programmers, plus it post virtually all types of Fantastic Plains Batches: GL, Inventory, Payroll, AP, AR, SOP

Tags: , , , , ,

Comments are closed.