Dynamics GP Custom Coding or How to Modify My New Corporate ERP

Feb 9
08:36

2011

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Corporate ERP is typically the thing that requires professional consulting touch. We would like to give you the initial information on the modification methodology and tools to let you do your homework on consulting company and the right tool selection.

mediaimage

In the case of Great Plains we would like to review traditional custom programming tools,Dynamics GP Custom Coding or How to Modify My New Corporate ERP Articles such as Dexterity, Modifier with VBA, Integration Manager, as well as new tools: eConnect, Web Services, Extender, Microsoft Visual Studio SDK.  Let’s begin with Dexterity:

1. Great Plains Dexterity was initially created as the whole architecture for the newly introduced ERP application back in earlier 1990th on Microsoft Windows and Macintosh platforms.  Dex has its own Integrated Development Environment, where you can alter existing forms, scrolling windows, add new fields, procedures, functions, triggers, constants, tables.  And it has its proprietary programming language Sanscript – it might resemble Visual Basic.  In Dexterity you have utter power over the application logic.  At the same time, we do not recommend you to program this tool in-house, as learning curve is unreasonably long, typically you can get Dexterity programmers from nationwide Technology Partners

2. Modifier with VBA.  This tools is in fact Dex module, where only some of the Dexterity functionalities are enabled, plus it has VBA editor.  It is probably good idea to deploy Modifier for the small or mid-size modification project.  Please, note, that Modifier does only the modification, it doesn’t create new forms

3. Integration Manager.  Here you also have VBA scripts as well as the possibility to base your integration on such powerful constructions as SQL View, including cross-platform DB views, where you are joining tables from MS SQL Server, Oracle, MySQL, MS Access, Excel, FoxPro, Pervasive SQL and other ODBC compliant platforms

4. Extender.  Here you do whatever is not possible in Modifier – you just extend – or in other words create new forms.  If you would like to animate the forms with Sanscript codes, consider Extender Enterprise, available directly from eOne

5. eConnect.  If you are Microsoft Visual Studio C# or VB developer, this tool might be your favorite, as it allows you to add eConnect libraries into your VS project.  It has code samples in C# and VB, plus in C++, this is why we recommend you to be familiar and comfortable with these languages, as modern programming is too complex to do without code samples

6. Web Services.  This is the way to call eConnect methods through SOAP or HTTP post.  The idea is great for non-Microsoft platform, such as Linux/PHP/MySQL, where you do not need to program eConnect directly but call it via SOAP

7. VS SDK.  Here you may call Dexterity logic from MS Visual Studio project.  Please, be aware, that you still have to create such objects as new tables in Dexterity

8. Support domestically in the USA, Canada, Mexico and internationally.  This option is possible via Web Sessions, Skype or Phone conferences and direct visits onsite (in the case of the large scale project).  Our consulting team speaks English, Chinese, Portuguese, Spanish, Russian, Filipino.  Feel free to call us 1-866-304-3265, 1-269-605-4904, or email help@efaru.com