Dynamics GP Ecommerce Programming and Integration Notes

Dynamics GP Ecommerce Programming and Integration Notes

Microsoft Dynamics GP is open to ecommerce programmer via eConnect SDK, as perfectly as Microsoft SQL Server programmability resources (ordinarily Stored Techniques and Sights).  Before you dive into technical venture of eConnect programming, remember to, assessment Good Plains Integration Manager module and its customization possibilities: VBA scripting of Prior to Document Commit (as very popular modification place) occasion you can schedule IM integration with Windows Macro or deploy no cost and all set for order apps, extending fundamental Windows Macro with more functionalities.  Dynamics GP Integration Manager based (for version ten. and potential versions 11. and up) on eConnect technology (in addition to supporting old OLE Server integrations), which means that IM integration need to be able to attain the exact same target with a lot less efforts.  And as you need to hope the exact same restrictions for eConnect as you have for Integration Manager – most normally manifesting limitation is eConnect and Integration Manager Batch Posting incapability.  Now straight to the Good Plains eCommerce Developing topic:

one. eConnect is Software package Growth Kit, composed in SQL Stored Techniques (encrypted), it enables you to software GP learn information (Consumer, Vendor, Employee, GL Account, Inventory Merchandise, Address, Project, Finances, and many others.) and so-referred to as Do the job Transactions: SOP Estimate, Order and Bill, POP Invest in Order, GL Transaction, Employee Paycheck, Inventory Adjustment and Transfer, to give the notion.  eConnect is welcoming and involves very shorter understanding curve for Microsoft Visible Studio .Net C#, VB and other .Net compliant languages programmers.  Additional pluses if you have XML, SQL Scripting techniques

2. Product sales Order Processing and Inventory Management modules and tables.  These two are the most popular in ecommerce integrations.  SOP tables have SOP prefix (renowned SOP10100 transaction header and SOP10200 strains), and Inventory INV (INV00101 – product learn and INV00102 Quantity learn) respectively.  Sometimes, especially in old Good Plains ecommerce legacy integrations you uncover Invoicing module (IV prefix)

three. Posting issue.  In ecommerce software you normally want to do all the way transaction processing: Product sales Bill creation and modification, applying credit score card payment deposit, allocating items, approving and putting up Product sales Order Processing batch (or personal transaction).  Here, you will hit the wall and comprehend that Posting performance is not bundled in eConnect or Good Plains Integration Manager.  There is no shortcut below (we think that you are Not Dynamics GP Dexterity software program developer with tons of programming practical experience, which includes Dexterity Source Code Programming), you will require to order Dynamics GP Add-On, we endorse Dynamics GP Posting Server, also recognised as Autopost

4. Dynamics GP eCommerce SQL Scripting.  If you have the impression that your ecommerce integration schedule is very easy and eConnect is as well cumbersome and heavy in being viewed as for deployment, you can generally rescue to SQL immediate insertion statement.  Please assessment GP desk framework: Dynamics GP -> Settings -> Resource Description -> Tables.  Or, simply just install GP Software package Growth Kit from CD #2.  Dynamics GP Enterprise Logic could be as well complicated for intuitive programming, so if you will get the buggy scenario, take into consideration making test transaction in GP person interface and assessment the information in GP tables.  If you prefer verified established of stored procedures – we provide them as Order Connector, feeding data into SOP tables

5. Truly feel no cost to call us on Microsoft Dynamics GP eCommerce integrations worries: one-866-528-0577, support@albaspectrum.com

Comments are closed.