Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

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

In The News:

pen paper and inkwell


cat break through


The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Do You Know These Facts About Spyware ?

Imagine something that follows you home and sets itself up... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Choose your Java Wisely

Java has come along a long way. Many would agree... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More