Great Plains Customization Tools: Dexterity, Modifier, eConnect, Auto Posting Server

Instead you should probe yourself as GP developer with eConnect – C#, VB and SQL skills are helpful here, or even in VBA – this programming technique comes together with GP Modifier module.  Let’s review the tools:

1.       eConnect.  This is Software Development Kit with sample codes in VB and C#.Net.  At the end of the chain eConnect calls encrypted SQL stored procedures, which you can not modify, and you shouldn’t as these procs replicate Dexterity business logic, where eConnect has some features of Object Oriented Programming.  eConnect was initially dedicated to eCommerce Microsoft Visual Studio developer, who is given the objective to integrate e-commerce website with GP ERP at the back end.  eConnect has some restrictions, one of them is lack of batch posting ability, so we recommend you Alba Spectrum Posting Server

2.       Auto Posting Server.  Again, GP is written in Microsoft Dexterity and it has its internal logic, which is available for Dexterity source code developer.  Posting Server calls GP Dex batch posting native logic to post batches in the queue.  You, as SQL programmer should place batches, created in eConnect or Integration Manager into this queue table.  In our opinion, this product is more flexible and gives you more control, than Autopost, developed by Parity Software, GP VAR from South Africa

3.       Modifier with VBA.  If you have comfort level in VBA scripting and past experience programming and modifying MS Excel, Access, Word or other office applications with VBA, the research this option of GP customizing.  Modifier allows you to place new fields to GP forms and screens and then you as programmer can associate VBA scripts with these new fields.  If you plan to alter DB, by clicking or filling up new fields, please be sure that you are familiar with Microsoft ADO technology