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. Microsoft Small Business Manager or Small Business Financials is written in Dexterity and uses the same code base as Great Plains. You can install Dexterity from Great Plains 7. Great Plains is actually integration of multiple dictionaries.
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. Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on GPS proprietary programming language and development environment - Great Plains Dexterity. Great Plains Software provided participants with DYNAMICS. Great Plains Dynamics was released in 1994 and it is 11 years old product. 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. If you are on Pervasive SQL 2000 or Ctree Great Plains Dynamics or Great Plains Accounting 9. 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. Microsoft Great Plains requires professional support and Microsoft Business Solutions serves its clients through MBS partner network. Great Plains Software and later on Microsoft Business Solutions Partners, VARs, Resellers and ISVs had to reduce their workforce, merge with large auditing companies or simply close their doors.
As you probably know, when Microsoft purchased Great Plains Software - the whole strategy for Great Plains Dynamics/eEnterprise line was changed. 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. 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. Clients who migrated to Great Plains standard are now in the feeling that they paid for something that is free now.
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. 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. 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.
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. 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. 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.
Migration reads Btrieve tables of Great Plains Accounting and moves the data to Microsoft Great Plains tables. 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. 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. As of right now it is reasonable to upgrade to Microsoft Great Plains 8. 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.
The first question is - are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. As eCommerce designer you should be aware of several options and customization tools in your disposition, when you utilize Microsoft Great Plains 8. If you launch Great Plains workstation and follow this way. You need to know the anatomy of Great Plains tables structure. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV.
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. 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. 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.
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. Modifier allows you to place new button on the Great Plains screens and address new and existing fields in the VBA code. 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. 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. Continuum for VB and Delphi and new Microsoft light programming technology - VBA (Visual Basic for Applications), which was integrated into Dexterity application - Great Plains Modifier (requires customization site enabler license. If you don't have source code - you can try to do the best guess with Microsoft Great Plains Software Development Kit (SDK. When Microsoft Windows platform won the OS market (the last battle was in 1997 with PowerMac) Great Plains recommended OLE Server approach.
Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. Some introduction into Great Plains Software products, now Microsoft Business Solutions. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it.
Former versions - Great Plains Dynamics/eEnterprise was also popular in Europe. In Russia we saw dramatic situation, when multiple Great Plains Dynamics/eEnterprise resellers went out of business. 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. Microsoft did it for Microsoft Navision and Axapta (for corporate market.
Latest version of Microsoft Great Plains is available for MS SQL Sevrer/MSDE only and you should consider combination of Dexterity and Stored procs. 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. In our days Microsoft Great Plains is available for Windows and MS SQL Server only (since version 8. If you have Microsoft Great Plains Standard or Professional license, you Great Plains CD #2 has Dexterity installation files. Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS.
|
Can Group Collaboration Software Meet Business Needs?
Great Plains Dexterity - Microsoft Great Plains Customization Overview