Free Articles, Free Web Content, Reprint Articles
Thursday, May 23, 2019
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

Great Plains Customization and Development: Dexterity, eConnect, SQL scripting

Microsoft Dynamics GP ERP belongs to Microsoft Dynamics family of applications together with Axapta, Navision, Solomon, MS CRM.  Great Plains is open for modification and custom programming and you as software programmer, who has reasonable background in accounting and MRP business processes and logic should understand your options in customizing GP

Do not expect GP modifying process to be very easy, and it also may lead you to the option of subcontracting the programming phase to professional GP Dexterity developer or technical consultant

1.       Tools.  In this small article we would like to give you highlights on the commonly used tools: Dexterity, eConnect and SQL stored procedures.  Each tool has advantages and disadvantages, so you should analyze them in the light of your customization project, let’s briefly review the tools

2.       Great Plains Dexterity, currently referred as Microsoft Dexterity.  Dex is written in C programming language and it is the shell for GP architecture.  With Dex scripting language Sanscript GP was built initially in earlier 1990th.  Dexterity customization is typically distributed via so-called chunk files.  Chunk file integrates itself with GP user workstation software on the first GP launch.  Dexterity and Sanscript look as proprietary technologies, and MBS requires you to purchase Dexterity programming license in order to program Dexterity in-house.  These two facts may incline you to subcontract Dex programming to GP ISV partner

3.       eConnect.  This is rather integration programming tool for Great Plains, initially dedicated to eCommerce programmer to enable GP objects manipulation: customer, vendor, Sales Invoice, etc.  With current GP version 10.0 eConnect is strategic technology for such integration tools as GP Integration Manager, where some connectors are redeployed on eConnect technology.  eConnect programming could be done in-house – you need C# or VB .Net programming skills plus familiarity with SQL scripting and GP tables and objects structure

4.       SQL stored procedures and scripting in general.  We recommend you first to consider eConnect as customization or integration tool, which already has encrypted SQL stored procedures to create, modify or delete GP objects.  Direct SQL scripts could be the alternative if the job itself is too small and simple and rescuing to eConnect programming is not feasible because of that.  However, please be aware that such SQL statements as update or insert might be dangerous and cause GP data inconsistencyScience Articles, as they just do change and do not validate GP business logic

Source: Free Articles from


Andrew Karasev, Alba Spectrum 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide.  Local service in Chicago, Houston, Dallas, San Diego.  Please visit our information portal Pegas Planet: .  If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports.  We also provide instant support to new and existing clients via web sessions 

Home Repair
Home Business
Self Help

Page loaded in 0.119 seconds