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. During the recession time a lot of former Great Plains Software and then Microsoft Business Solutions partners either went out of business or merged with Auditing firms and their Great Plains clients saw this instability and simply stopped annual enhancement program payments and become so-called orphan clients. Today, in 2005 ? it is time to upgrade from eEnterprise 6.0 to Microsoft Great Plains Professional 8.0. If you have major customization for eEnterprise ? you need to understand your options before you find your new Microsoft Business Solutions VAR of record. In this small article we will describe you the main steps and options to upgrade Dexterity customization:
? DYNAMICS.DIC with the source code. This is where your customization script should be originated from. The nature of Dexterity makes the developer to produce so-called Dexterity chunk from this DYNAMICS.DIC with the source code, in the chunk itself the code is stripped off. You should have this dictionary, if you don't ? contact your old VAR and see if somebody could give it t you. If you can not find the source code, then customization should be understood and recoded ? yes ? how sad it might sound.
? VBA / Modifier code. Alternative to Dexterity customization could be light (or heavy) VBA scripting. Modifier allows you to place new button on the Great Plains screens and address new and existing fields in the VBA code. VBA scripts are located in DYNAMICS.VBA dictionary. This dictionary should be present on each workstation, using the modification. Usually this code is not encrypted and programmer could analyze and upgrade the code. Modified forms could be also upgraded. Sometimes we see heavy VBA coding, using element of Continuum, where it switched Dexterity dictionaries and then uses inline Dexterity sacscript scripting. These customizations, probably considered as very high-skills programming in the past should be redone.
? Stored Procedures. In eEnterprise, beginning with version 5.0 Dexterity cursors were recommended to rewrite in the form of stored procedures, and so offload Dexterity logic into MS SQL Server scripting. 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. And you are lucky if they are not encrypted.
? Other custom elements. You may have ReportWriter reports: SOP Long Invoice Form, for example. These is a list of upgradeable and no-upgradeable, the last ones should be redone.
Good luck with customization upgrade and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com
Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia
![]() |
|
![]() |
|
![]() |
|
![]() |
User interfaces and accessibility are some of the most important... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
What is installation in the language of technology? Installation... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
How to delete the user? This is the first problem... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Following tips help you to learn a software in lesser... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
It is possible that if one avoided all sources of... Read More
While I was in college, if you would have asked... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
When Great Plains Software was designing and developing Great Plains... Read More
There are plenty of articles out there about how to... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
When it comes to running an office, the SOHO entrepreneur... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
All of us know that Microsoft bought former Great Plains... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
Navision Software was purchased by Microsoft and now it is... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
I like my software simple. If it's too complex or... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Microsoft Word is one of the most popular office applications... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
We all already got used to computer monitoring both at... Read More
It is really interesting that a bug can create problem... Read More
Sometimes your PC will start acting strange for no apparent... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
OEComplete is a utility for managing the personal information of... Read More
After almost two decades of existence, Quark has become the... Read More
There are several kinds of software piracy. The bottom line... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
In the real world a "fire wall" is a fireproof... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
This article will not attempt to advocate the use of... Read More
Itâ??s easy to understand why you might be drawn to... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
I provide, here clear explanations and a count of function... Read More
In the early days of the personal computer, we're talking... Read More
One day, you suddenly realize that your computer started to... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
Mike Dunville* had a decision to make. As the new... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Pirated software is on the increase and now accounts for... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Do you want to get quality software at a reasonable... Read More
Viruses and spyware usually show up on your computer one... Read More
There are so many different programs that clutter up your... Read More
If you've been using MySQL database to store your important... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
There are two major WYSIWYG(What You See Is What You... Read More
When Great Plains Software was designing and developing Great Plains... Read More
MS CRM is very close to document workflow automation, including... Read More
Software |