| |
Microsoft Dynamics GP Customization Upgrade – overview for developer
By Andrew Karasev
New name for Microsoft Great Plains or former Great Plains Dynamics is Microsoft Dynamics GP. Microsoft Dynamics GP 9.0 is definitely new product, comparing to old GPS Dynamics, however if you use so-called "fat" client – Microsoft Dexterity is still doing its graphical interface and database interaction job.
If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity – you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive (not supported by Microsoft since 2005) to MS SQL/MSDE.
Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.
However Great Plains 8.0 and even 9.0 is Dexterity based application, so you have to deal with it and it's customization.
Positive News. Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure – forcing Dexterity customization to be analyzed and partially rewritten with each upgrade. Not any more – GP structure stays the same – Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.
Negative News. Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms. This was upgrade problem in the past and it stays now – there is no way to do it in house (until you are willing to pay for full-time internal developer – who is usually in the learning curve). You got to bring in consultant.
Recommended approach. You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing – Visual Studio.net and slowly abandon Dexterity customization
1. Use SQL Stored procedures. Consider replacing dexterity data manipulation with SQL stored procedures. Dexterity is cursor-driven language and it is not efficient when processing huge datasets.
2. Use MS SQL Server Reporting Services or even Crystal Reports. Take advantage of open and leading technology. SRS or Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade. Base you Crystal report on the SQL view or stored proc
3. Web Publishing. Use Visual Studio – it is easy to find specialists and have them in staff. We are in the World when web publishing is very easy.
Please do not hesitate to call or email us: USA 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com
About the Author
Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.enterlogix.com.br http://ronix-systems.de ) - Microsoft Business Solutions Great Plains, Navision, Axapta, MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.
Article Source: http://www.simplysearch4it.com/article/26715.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/26715.html" as shown above and make it hyperlinked. |
| Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this ...
SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of SAP ERP brand. This ...
Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a core of fat client workstation plus it defines ODBC Dex ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you ...
Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, ...
|
|
| |
|
