ECommerce,Integration,Dynamics computer ECommerce Integration to Dynamics GP Great Plains: Tables Re
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
We should give you upfront our recommendation to deployeConnect Software Development Kit for Dynamics GP, especially when you are onGP version 10.0 or 9.0 (or consider upgrading to latest version 10.0), howeverif you are on old version: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2 - and if yourecommerce integration seems to be very simple to you, we would like you to givehighlights to Great Plains ecommerce tables: 1. SalesOrder Processing Tables. In that moduleyou typically create ecommerce invoices and save them into the batch, plusoptionally you apply customer deposits to invoice (typically credit cardpayment, which you process via add-on directly in ecommerce application). These tables have prefix SOP: SOP10100 SalesDocument Header, SOP10200 Sales Document Line, SOP10102 Sales Distribution Workand History (this table stores GL accounts distribution for the Invoice, you donot need it if you are integrating Sales Orders), SOP10103 Sales Payment Workand History (if you are applying customer deposits), SOP10105 Sales Taxes Workand History - this set of tables should give you good start for furtherresearch 2. InventoryTables. Here you will need to look upfor the items, and program inventory allocation to the invoice or sales order (howeverallocation could be done later on the SOP batch level, you need to check thesettings in your SOP type). These tableshave INV prefix: INV00101 Item Master, INV00102 Item Quantity Master 3. ReceivableManagement Tables. Here you look up yourcustomers if you are doing business to business ecommerce. Prefix RM: RM00101 Customer Master, RM00102Customer Address Master 4. OtherTables. We recommend you to createtypical ecommerce invoice in GP directly and carefully research where recordswere added or modified. Then, simplyfind the description of the table in Dynamics GP->ResourceDescription->Tables. You can alsoinstall Dynamics GP SDK from CD #2 5. Andnow good luck. If you do not want toreinvent the wheel, we welcome you to call our office or visit our website toget info on Order Connector, which already has the logic described aboveimplemented in SQL stored procedures. Give us a call: 1-866-528-0577, [email protected]
ECommerce,Integration,Dynamics