| Microsoft Dynamics GP 10.0 Great Plains ERP system | | | | designed for eCommerce programmer and |
| is very attractive as back office accounting application, | | | | developers. The core of eConnect is the set of |
| plus you have rich functionality of ERP/MRP business | | | | encrypted SQL stored procedures, allowing you to |
| logic: Sales Order Processing, Purchase Order | | | | create and change GP master objects: employees, |
| Processing, Discrete Manufacturing, Payroll, General | | | | customers, vendors, GL accounts, and transactions: |
| Ledger, Inventory Control. If you are eCommerce | | | | SOP Invoices to give you example. However |
| developer, who builds your web site with MS Visual | | | | eConnect doesn't cross the border of Great Plains |
| Studio.Net editions and C#, VB and SQL scripting, you | | | | Dexterity limitations, including posting the documents |
| should know your options to post GP batches, | | | | 3. Integration Manager options. Great Plains IM can |
| especially in SOP module directly from your | | | | feed documents to GP from your legacy applications, |
| e-commerce application. In this small article we would | | | | it can also help you with EDI (Electronic Documents |
| like to address this issue in the form of FAQ dialogue: | | | | Interchange). However IM is restricted to Dex |
| 1. Microsoft Dexterity Posting Architecture. Sales Order | | | | architecture, the same situation as eConnect,. Plus you |
| Processing module is tightly integrated with Inventory | | | | should be aware that IM is currently on the way to be |
| control and it assumes that you first create so-called | | | | rewritten in eConnect for boosting IM performance as |
| work document: invoice, quotation, sales order or back | | | | SQL stored procedures (eConnect base) are faster |
| order. Then you have two options - you can post this | | | | than Dexterity cursors |
| invoice (or transfer sales order to invoice or back | | | | 4. Posting Server as Extension to eConnect. |
| order) or place it in the batch for future posting. In both | | | | Albaspectrum Posting server deploys Dexterity native |
| scenarios posting is something that should be done by | | | | posting logic, it calls Dex posting procedures from Dex |
| GP operator and it is not open for automations. This is | | | | custom module. All you as SQL or C# programmer |
| why eConnect doesn't allow you to post GP | | | | need to do is deploy ADO.NET and place ecommerce |
| transactions or batches | | | | batches, ready for posting in custom approved |
| 2. eConnect architecture. eConnect was specially | | | | batches table. |