Dynamics,Ecommerce,Programming computer Dynamics GP Ecommerce Programming and Integration Notes
----------------------------------------------------------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 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
Dynamics GP Integration Manager based (for version 10.0 andfuture versions 11.0 and up) on eConnect technology (in addition to supportingold OLE Server integrations), meaning that IM integration should be able toachieve the same goal with less efforts. And as you should expect the same limitations for eConnect as you havefor Integration Manager - most often manifesting limitation is eConnect andIntegration Manager Batch Posting inability. Now straight to the Great Plains eCommerce Developing topic: 1. eConnectis Software Development Kit, written in SQL Stored Procedures (encrypted), itallows you to program GP master records (Customer, Vendor, Employee, GLAccount, Inventory Item, Address, Project, Budget, etc.) and so-called WorkTransactions: SOP Quote, Order and Invoice, POP Purchase Order, GL Transaction,Employee Paycheck, Inventory Adjustment and Transfer, to give the idea. eConnect is friendly and requires very shortlearning curve for Microsoft Visual Studio .Net C#, VB and other .Net compliantlanguages programmers. Additional plusesif you have XML, SQL Scripting skills 2. SalesOrder Processing and Inventory Control modules and tables. These two are the most popular in ecommerceintegrations. SOP tables have SOP prefix(famous SOP10100 transaction header and SOP10200 lines), and Inventory INV (INV00101- item master and INV00102 Quantity master) respectively. Sometimes, especially in old Great Plainsecommerce legacy integrations you find Invoicing module (IV prefix) 3. Postingproblem. In ecommerce application youoften want to do all the way transaction processing: Sales Invoice creation andmodification, applying credit card payment deposit, allocating merchandise,approving and posting Sales Order Processing batch (or individual transaction). Here, you will hit the wall and realize thatPosting functionality is not included in eConnect or Great Plains IntegrationManager. There is no shortcut here (weassume that you are Not Dynamics GP Dexterity software developer with tons ofprogramming experience, including Dexterity Source Code Programming), you willneed to purchase Dynamics GP Add-On, we recommend Dynamics GP Posting Server,also known as Autopost 4. DynamicsGP eCommerce SQL Scripting. If you havethe opinion that your ecommerce integration routine is very simple and eConnectis too cumbersome and heavy in being considered for deployment, you can alwaysrescue to SQL direct insertion statement. Please review GP table structure: Dynamics GP -> Settings -> ResourceDescription -> Tables. Or, simplyinstall GP Software Development Kit from CD #2. Dynamics GP Business Logic might be too complex for intuitiveprogramming, so if you will get the buggy situation, consider creating testtransaction in GP user interface and review the records in GP tables. If you prefer proven set of stored procedures- we offer them as Order Connector, feeding data into SOP tables 5. Feelfree to call us on Microsoft Dynamics GP eCommerce integrations concerns:1-866-528-0577, [email protected]
Dynamics,Ecommerce,Programming