Microsoft Dynamics GP ERP, formerly known as Great Plains Dynamics and eEnterprise has good selection of custom programming and integration tools, plus from the SQL Server itself you could try Stored Procedures integration. Consider Dynamics GP Integration Manager, where you can simply setup integration without programming or even add some integration logic alteration via VBA scripts in Before Integration, Before Document Commit and other events
If your integration requires very deep interaction with Great Plains tables and custom tables, you can try Dynamics GP Dexterity programming (where you create custom tables and handle integration on both standard and custom ones) or eConnect Microsoft Visual Studio C# or VB.Net programming. This publication is not intended as eConnect eCommerce programming guide, we would like to give you the orientation in what to expect from eConnect, and we assume that you as software developer will be able to include eConnect libraries to your MS VS project and work with eConnect sample codes on your own:
1. Work Transactions and Master Records. eConnect allows you to create so-called work transactions, place them into the batch: Sales Order Processing Order or Invoice (this is especially valuable in ecommerce website programming), Purchase Order, GL transaction, etc. and if required create or alter existing master records: customer, vendor, GL account, Payroll Employee, Address
2. eConnect versus SQL Stored Procedures. If you think that there is no need to deploy eConnect and instead code your own custom SQL Stored Procedures, please note, that you in essence will be recoding GP business logic, which is already coded by Microsoft Dynamics GP programmers in Microsoft – in our opinion it is waste of time, unnecessary learning curve and potential source of numerous bugs and even data integrity threat. And again in our opinion Stored Procedures should be coded only when your integration project is very simple – and even here, please look at Great Plains Integration Manager first
3. eConnect versus Integration Manager. The tendency is the following – IM is in process of being rewritten with eConnect connectors, and walking away from legacy OLE Server based approach. This fact should mean for you that IM is as fast as custom eConnect application. eConnect application, however might be triggered in real time, where IM should be either called by IM operator or scheduled with Windows scheduler or special Windows Macro based application
4. Automatic Batch Posting in ecommerce. This is something that eConnect doesn’t have, you should deploy Dynamics GP ISV add-on, Alba Spectrum Posting Server, which will allows you to place batches in Autopost queue and then posting process will be launched by Posting Server GP workstation
5. If you feel that you need Dynamics GP consultant help, please call your Great Plains Guru, or if you do not have one, consider calling to Great Plains Resellers in your area or who are familiar with your industry. Feel free to call us: 1-866-528-0577, help@albaspectrum.com
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
