ECommerce Integration to Dynamics GP Great Plains: Tables Review

If you already have functioning legacy ecommerce website, which does the job of selling and now you are at the point of speculating on integration with Microsoft Dynamics GP, or you may have older versions, where this ERP and accounting package had Great Plains Dynamics or eEnterprise name.  We should give you upfront our recommendation to deploy eConnect Software Development Kit for Dynamics GP, especially when you are on GP version 10.0 or 9.0 (or consider upgrading to latest version 10.0), however if you are on old version: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2 - and if your ecommerce integration seems to be very simple to you, we would like you to give highlights to Great Plains ecommerce tables:

1. Sales Order Processing Tables.  In that module you typically create ecommerce invoices and save them into the batch, plus optionally you apply customer deposits to invoice (typically credit card payment, which you process via add-on directly in ecommerce application).  These tables have prefix SOP: SOP10100 Sales Document Header, SOP10200 Sales Document Line, SOP10102 Sales Distribution Work and History (this table stores GL accounts distribution for the Invoice, you do not need it if you are integrating Sales Orders), SOP10103 Sales Payment Work and History (if you are applying customer deposits), SOP10105 Sales Taxes Work and History - this set of tables should give you good start for further research

2. Inventory Tables.  Here you will need to look up for the items, and program inventory allocation to the invoice or sales order (however allocation could be done later on the SOP batch level, you need to check the settings in your SOP type).  These tables have INV prefix: INV00101 Item Master, INV00102 Item Quantity Master

3. Receivable Management Tables.  Here you look up your customers if you are doing business to business ecommerce.  Prefix RM: RM00101 Customer Master, RM00102 Customer Address Master

4. Other Tables.  We recommend you to create typical ecommerce invoice in GP directly and carefully research where records were added or modified.  Then, simply find the description of the table in Dynamics GP->Resource Description->Tables.  You can also install Dynamics GP SDK from CD #2

5. And now good luck.  If you do not want to reinvent the wheel, we welcome you to call our office or visit our website to get info on Order Connector, which already has the logic described above implemented in SQL stored procedures.  Give us a call: 1-866-528-0577, help@albaspectrum.com