Great Plains Econnect Posting Dilemma

Microsoft Dynamics GP 10.0 Great Plains ERP systemdesigned 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 businessencrypted SQL stored procedures, allowing you to
logic: Sales Order Processing, Purchase Ordercreate and change GP master objects: employees,
Processing, Discrete Manufacturing, Payroll, Generalcustomers, vendors, GL accounts, and transactions:
Ledger, Inventory Control. If you are eCommerceSOP Invoices to give you example. However
developer, who builds your web site with MS VisualeConnect doesn't cross the border of Great Plains
Studio.Net editions and C#, VB and SQL scripting, youDexterity 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 yourfeed documents to GP from your legacy applications,
e-commerce application. In this small article we wouldit 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 Orderarchitecture, the same situation as eConnect,. Plus you
Processing module is tightly integrated with Inventoryshould be aware that IM is currently on the way to be
control and it assumes that you first create so-calledrewritten in eConnect for boosting IM performance as
work document: invoice, quotation, sales order or backSQL stored procedures (eConnect base) are faster
order. Then you have two options - you can post thisthan Dexterity cursors
invoice (or transfer sales order to invoice or back4. Posting Server as Extension to eConnect.
order) or place it in the batch for future posting. In bothAlbaspectrum Posting server deploys Dexterity native
scenarios posting is something that should be done byposting logic, it calls Dex posting procedures from Dex
GP operator and it is not open for automations. This iscustom module. All you as SQL or C# programmer
why eConnect doesn't allow you to post GPneed to do is deploy ADO.NET and place ecommerce
transactions or batchesbatches, ready for posting in custom approved
2. eConnect architecture. eConnect was speciallybatches table.