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.

    In The News:

    pen paper and inkwell


    cat break through


    Adware and Spyware Blockers

    The most important things you can do for your computer... Read More

    Software Review: Xsitepro Total Site Management Software

    It's not very often I get excited about a software... Read More

    Cisco Certification: Introduction To ISDN, Part IV

    In part III of this ISDN primer, we learned that... Read More

    These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

    1. What determines the software price? Is it Per Seat... Read More

    Ukraine: a Prospective Player on the World Software Outsourcing Market

    The destruction of the Soviet Union about 15 years ago,... Read More

    How to Backup Windows XP Home Edition

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

    Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

    It would be easy to think, like most people apparently... Read More

    Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... Read More

    Microsoft Great Plains Middle East - Arabic Language Support

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

    Instant Messaging is a Sweet Way to Communicate

    MSN messenger is a pretty cool invention. I mean I'm... Read More

    Microsoft Great Plains IV: Inventory Management

    Great Plains Inventory Management (IV) module gives your business a... Read More

    What is Spyware? Are You Being Watched?

    Find out why Spyware Removal from computers is important and... Read More

    Bridging the Gap between Paper and Data

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

    CRM 101: Customer Relationship Management for Beginners

    Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

    Microsoft Great Plains, Navision, Axapta ? Selection Considerations

    During the years of our consulting practice, which comes back... Read More

    Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

    Microsoft Business Solutions Great Plains has I'd say end user... Read More

    Screenshots Vista Windows

    Features Additionally, Vista will include many other new features.Aero Vista... Read More

    Microsoft Great Plains SOP: Sales Order Processing

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

    Who Is Minding Your Sensitive Data?

    Stealing company information used to be the specialty of spies... Read More

    Does Microsoft have any real competition?

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

    The End of Spyware?

    The US House of Representatives has recently passed the "Spy... Read More

    How a Bug Challenges to a Software Professional

    It is really interesting that a bug can create problem... Read More

    Software For Your Hard-Drive

    All your software is stored on a hard-drive. But how... Read More

    Microsoft CRM ? Consulting in the Post-Recession Time

    New post-recession era has new features, which didn't exist in... Read More

    How to Choose the BEST Charting Software

    I suggest that you do not spend a lot of... Read More

    Tools for Customizing Great Plains

    Microsoft Business Solutions ? Great Plains has captured the US... Read More

    Reloading Windows XP

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

    Review of TikiWiki Content Management System

    TikiWiki is open source software - it is written in... Read More

    Internet Relay Chat - A Basic Introduction

    What is IRC?IRC is Internet Relay Chat. It is a... Read More

    Explore the Internet in a Whole New Way

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

    Algebra Help Software

    Need help making sense of algebra? Have algebra lectures in... Read More

    Online PowerPoint Presentation ? Convert PowerPoint to Flash

    Although we don't know whether Microsoft ever envisioned such a... Read More

    Why do Manufacturers Invest in Business Management Software?

    With many manufacturing shops heading over seas in favor of... Read More