Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. Al these suites will be integrated into web-based Microsoft Business Portal

This move, probably wise in the long run, exposed businesses with heavily customized MBS products to serious customization upgrade problems. We'll give you our recommendation, based on our practice. In this article we'll talk about Microsoft Great Plains.

Great Plains Dexterity Customizations ? Microsoft announced that its products will be moved to .Net platform. This means that Dexterity will be phased out/discontinued. However, even now Microsoft Great Plains 8.0 is still Dexterity-based application. So, if you have Dexterity customization - our recommendation is to phase it out or consider replacing it with these: Crystal Reports, SQL Stored Procs and triggers, Web Publishing (Visual Studio.Net) from Great Plains database, eConnect (SDK created to eCommerce developers to deploy Great Plains as back end)

Pervasive SQL/Ctree migration to MS SQL - If you are still on these old platforms - then you are in trouble - you will be without Microsoft technical support by the end of 2004. When you do standard data migration via migration tool - Great Plains tables are migrated by the tool, however migration tooll has no info about your custom tables - these tables should be migrated manually. You can use MSSQL Server Linked Server construction to link to Pervasive/Ctree data. ODBC drivers can be installed from GP CDs.

VBA/Modifier/Continuum ? all these are good candidates for replacement by newer technologies, because these will not have their place in .Net platform.

Additional notes: When Great Plains Software designed Dexterity as the replacement to its discontinued Great Plains Accounting - it proclaimed that Dexterity is DB independent - which is true to some extent. However there are specifics, and Dexterity customization should be analyzed and tuned to work with MS SQL Server, if it was originally designed for btrieve/ctree. We are talking about customization upgrade for Great Plains Dynamics/eEnterprise 5.0, 5.5, 6.0, 7.0 to Microsoft Great Plains 8.0 or 7.5.

Happy upgrading! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Colorado, Arizona, Texas, Florida, Georgia, New York, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

---

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

An Easy Way to Deal with Email Viruses and Worms

If you feel intimidated when someone tries to teach you... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

PHP On-The-Fly!

IntroductionPHP can be used for a lot of different things,... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... Read More

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Microsoft CRM or Siebel

Siebel is traditional CRM market leader, however and mostly due... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... Read More

Dreamweaver vs FrontPage

There are two major WYSIWYG(What You See Is What You... Read More

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Microsoft CRM Customization

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

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More