Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise are Dexterity-written applications. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Great Plains is actually integration of multiple dictionaries. You can install Dexterity from Great Plains 7.
Great Plains Software provided participants with DYNAMICS. Great Plains Dynamics was released in 1994 and it is 11 years old product. Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on GPS proprietary programming language and development environment - Great Plains Dexterity. When Microsoft bought Great Plains Software, Dynamics was renamed into Microsoft Great Plains, but Dexterity is still the architectural base, there were trends to move MS Great Plains to. We are confident in Great Plains as an ERP platform for the following industries.
Now it is time for them to upgrade/recover their Great Plains Dynamics or migrate Great Plains Accounting to Microsoft Great Plains. Great Plains Dexterity is programming language and IDE and the complexity of the upgrade may vary, depending on the quality of customization design and coding and the level of integration with the main application (usually DYNAMICS. If you are on Pervasive SQL 2000 or Ctree Great Plains Dynamics or Great Plains Accounting 9. Microsoft Great Plains requires professional support and Microsoft Business Solutions serves its clients through MBS partner network. This piece is probably the one for outside Great Plains Dexterity consultant or programmer.
Microsoft obviously had no plan to keep this multiplatform capability and Great Plains was optimized to MS SQL Server and with the introduction of MSDE - the need to keep entry level Dynamics on Ctree/Btrieve disappeared. Microsoft Great Plains Business Solutions, later renamed to Microsoft Business Solutions was sending multiple signals to Dynamics customers to migrate to SQL Server, later on to upgrade to Great Plains Standard on MSDE. As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Clients who migrated to Great Plains standard are now in the feeling that they paid for something that is free now. You will be given Migration Tool quote - then install MSDE and Great Plains with exactly the same accounts structure that you have on Pervasive/Ctree.
Great Plains Dexterity - this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. You can install Dexterity from Great Plains 7. Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Great Plains is actually integration of multiple dictionaries. You can install Dexterity from Great Plains 7. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
Great Plains Accounting is in phasing out -Great Plains Software began this process back in 1995, when it did introduce Great Plains Dynamics and then Great Plains Dynamics/CS. This is a short article, written in question/answer/FAQ style to give IT Specialist/developer/programmer balanced top level information on Great Plains Accounting migration to Microsoft Business Solutions Great Plains. You can use Great Plains VAR/Partner - in this case your cost is usually lower - but you need to do due diligence - find the partner who has experience and has done at least couple of migrations. If you have Great Plains Accounting as main accounting and ERP system you need to know some technical details on the migration to Great Plains and what is going on behind the scenes. As of right now it is reasonable to upgrade to Microsoft Great Plains 8.
The first question is - are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. If you launch Great Plains workstation and follow this way. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. You need to know the anatomy of Great Plains tables structure. Andrew is Great Plains specialist in Alba Spectrum Technologies (http.
If you need seamless integration with Great Plains Dynamics, working in the realm of Dynamics security and database independent data access/modification - you do it in Great Plains Dexterity. In order to realize these two principles Great Plains Software created its own development environment and programming language - Great Plains Dexterity (DYNAMICS. When Great Plains Software was designing and developing Great Plains Dynamics/Dynamics CS+/eEnterprise - it placed several fundamental principles into the system. When Microsoft SQL Server won the database market - Great Plains Software began migration campaign from Ctree/Faircom, Btrieve/Pervasive SQL to MS SQL Server 7. Great Plains Dexterity, VBA, ReportWriter, Continuum, Integration Manager.
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into Microsoft Great Plains and Microsoft Business Solutions is in process of merging all its accounting applications. Database platform independence - initially Great Plains used Ctree (available for both PC and Mac) and Btrieve, later on with Microsoft SQL Server 6. Great Plains is actually integration of multiple dictionaries. Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Great Plains Dexterity with SQL Stored Procs Nowadays, most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
Modifier allows you to place new button on the Great Plains screens and address new and existing fields in the VBA code. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. At the end of XX century, in the late 1990th Great Plains Software eEnterprise was recognized as one of the leader on the midsize to large corporate ERP market. Due to the nature of eEnterprise architecture - it is Great Plains Dexterity based application and Dexterity imposes some specific to the database access and table structure - eEnterprise was subject to relatively inexpensive customization. Usually you need Dexterity programmer to take a look at your Company or Dynamics databases and tell you which stored procedures are deployed by Dexterity customization.
Since then Great Plains Dynamics/eEnterprise integration techniques use Microsoft technologies. Great Plains uses similar logic when you post the batch and see the status in Process Monitor window. Great Plains Dexterity integration with Great Plains process server. In this short FAQ style article we would like to introduce you - software developer, programmer, database administrator into Microsoft Great Plains Integration tools and options. It was initially created for eCommerce application integration to Great Plains.
Small companies use Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary DYNAMICS. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. This will allow you to deploy ODBC connection to Great Plains database. Sometimes you have to rescue to Great Plains Dexterity- when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy.
In Russia we saw dramatic situation, when multiple Great Plains Dynamics/eEnterprise resellers went out of business. Former versions - Great Plains Dynamics/eEnterprise was also popular in Europe. Microsoft Great Plains is Great Plains Software Dexterity written application. Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U. Dexterity has string resources and in order to localize DYNAMICS.
Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS. If you place custom fields and logic on the existing forms then, you should know that Great Plains can change the form for the new version and you will have to review and redo the custom logic. The most challenging portion of upgrade is Alternate Great Plains forms. Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. If you have Microsoft Great Plains Standard or Professional license, you Great Plains CD #2 has Dexterity installation files.
|