Current version of Microsoft Dynamics GP is 10.0, it is only available on Microsoft SQL Server platform. If you are still on Pervasive SQL or Ctree, there should be respected reason for you to stick to the old version and do not undertake upgrade to 8.0, 9.0 or 10.0. Additional complication might be something like Intellisol add-ons: Advanced POP or Project Accounting
Microsoft Dynamics GP ERP application was initially designed and coded in Great Plains Software Dexterity. Dex is in turn EDI and shell, written in C++ programming language. Dexterity is tightly interrelated with Database structure, it has its own indexing, typically working with MS SQL Server primary keys and indexes.
Plus Dex has its own scripting language (which is not interpreted, but compiled) ? Sanscript. GP Dexterity might be not the first modification option, you like to try ? you can first research such tools as Modifier with VBA, eConnect, Extender, but if you think your custom add-on should be seamlessly integrated with GP user interface and security realm, then Microsoft Dexterity programming is the way to go. Let’s come through Dex highlights:
Microsoft Dynamics GP ERP, or former Great Plains Software Dynamics and eEnteprise have wide range of modification, software development, integration, EDI, reporting tools. However, please take into consideration the fact, that GP is mid-market accounting, ERP and MRP platform, meaning that its business logics and processes might be too complex for newcomers with natural good intention to help her or his company to deliver and implement tailored business logic in a few days or weeks
Microsoft Dynamics GP ERP version update requires consultant involvement and it is typically done through Great Plains Certified Partner and Reseller, also referred as VAR or Value Added Reseller. In upgrade initiative important role is Customization code review by Great Plains Dexterity or eConnect programmer as if your new version will fail in custom logic, all the company and business operations might be at risk.
Microsoft Dynamics GP has large number of installations and successfully implemented for various industries: wholesale, retail, transportation & logistics, pharmaceutical, project organization, non-profit, government and others.
GP has vertical and horizontal solutions, which you can purchase in the form of modules. In some cases you business processes are so unique or customization scope is small that it is feasible to develop add-on to GP standard ERP logic from scratch. In this small article we would like to highlight tools and scenarios: