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