Dynamics GP Ecommerce Programming and Integration Notes

Microsoft Dynamics GP is open to ecommerce programmer through eConnect SDK, as well as Microsoft SQL Server programmability equipment (ordinarily Saved Procedures and Views).  Before you dive into specialized task of eConnect programming, make sure you, evaluation Fantastic Plains Integration Manager module and its customization possibilities: VBA scripting of Ahead of Document Dedicate (as extremely typical modification issue) function you can program IM integration with Home windows Macro or deploy totally free and ready for purchase purposes, extending simple Home windows Macro with further functionalities.  Dynamics GP Integration Manager primarily based (for variation 10. and potential variations 11. and up) on eConnect technology (in addition to supporting outdated OLE Server integrations), this means that IM integration really should be equipped to attain the same intention with much less attempts.  And as you really should assume the same limits for eConnect as you have for Integration Manager – most often manifesting limitation is eConnect and Integration Manager Batch Posting lack of ability.  Now straight to the Fantastic Plains eCommerce Developing topic:

one. eConnect is Software Growth Kit, written in SQL Saved Procedures (encrypted), it allows you to plan GP grasp documents (Consumer, Vendor, Worker, GL Account, Inventory Item, Handle, Project, Price range, etcetera.) and so-named Do the job Transactions: SOP Quote, Get and Bill, POP Invest in Get, GL Transaction, Worker Paycheck, Inventory Adjustment and Transfer, to give the concept.  eConnect is friendly and needs extremely quick discovering curve for Microsoft Visible Studio .Web C#, VB and other .Web compliant languages programmers.  Additional pluses if you have XML, SQL Scripting techniques

two. Gross sales Get Processing and Inventory Control modules and tables.  These two are the most well known in ecommerce integrations.  SOP tables have SOP prefix (popular SOP10100 transaction header and SOP10200 strains), and Inventory INV (INV00101 – product grasp and INV00102 Quantity grasp) respectively.  Sometimes, specially in outdated Fantastic Plains ecommerce legacy integrations you find Invoicing module (IV prefix)

three. Posting difficulty.  In ecommerce application you often want to do all the way transaction processing: Gross sales Bill generation and modification, implementing credit card payment deposit, allocating products, approving and putting up Gross sales Get Processing batch (or particular person transaction).  Here, you will hit the wall and notice that Posting features is not included in eConnect or Fantastic Plains Integration Manager.  There is no shortcut here (we assume that you are Not Dynamics GP Dexterity application developer with tons of programming encounter, which includes Dexterity Supply Code Programming), you will have to have to purchase Dynamics GP Include-On, we propose Dynamics GP Posting Server, also identified as Autopost

4. Dynamics GP eCommerce SQL Scripting.  If you have the feeling that your ecommerce integration regimen is extremely very simple and eConnect is way too cumbersome and major in currently being considered for deployment, you can generally rescue to SQL direct insertion statement.  Please evaluation GP desk structure: Dynamics GP -> Options -> Resource Description -> Tables.  Or, merely put in GP Software Growth Kit from CD #two.  Dynamics GP Company Logic could possibly be way too complex for intuitive programming, so if you will get the buggy scenario, contemplate building take a look at transaction in GP consumer interface and evaluation the documents in GP tables.  If you choose demonstrated established of saved techniques – we give them as Get Connector, feeding info into SOP tables

five. Experience totally free to contact us on Microsoft Dynamics GP eCommerce integrations considerations: one-866-528-0577, [email protected]