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 (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    monthly home cleaning Buffalo Grove ..
    In The News:

    Baseball teams can now analyze complete swing mechanics in normal training environments using Theia's markerless AI system that processes standard high-speed footage.
    Smart home hacking fears overblown? Expert reveals real cybersecurity risks and simple protection tips to keep your connected devices safe from hackers.
    MIT develops needle-free glucose monitor using light technology. Revolutionary device could replace painful finger pricks for diabetes management.
    The ClickFix campaign disguises malware as legitimate Windows updates, using steganography to hide shellcode in PNG files and bypass security detection systems.
    Researchers from Osaka Metropolitan University designed a 21-foot dome that combines aquaculture and hydroponics to create a self-sustaining urban food system.
    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    ChatGPT data breach exposes personal info of users through partner Mixpanel. OpenAI confirms names, emails compromised in security incident.
    Android rolls out Emergency Live Video for 911 calls, letting dispatchers see real-time scenes during emergencies. Great for holiday travel safety.
    Malicious Chrome and Edge extensions collected browsing history, keystrokes and personal data from millions of users before Google and Microsoft removed them.
    Google's new Call Reason feature lets Android users mark calls as urgent before dialing, displaying an urgent label to recipients using Phone by Google app.
    Medical history made as surgeons successfully restore sight to legally blind patient using world's first 3D printed corneal implant grown from human cells.
    Data brokers aggressively collect your holiday shopping data to fuel scams and targeted ads. Learn how to delete your digital profile before 2025 starts.
    Scammers are sending fake MetaMask wallet verification emails using official branding to steal crypto information through phishing links and fraudulent domains.
    Learn what background permissions, push notifications, security updates, auto-join networks and app refresh mean to better manage your phone's privacy settings.
    Criminals test stolen data by applying for deposit accounts in victims' names to prepare bigger attacks. Learn why banks won't share fraud details.
    New study of 10,500+ kids reveals early smartphone ownership linked to depression, obesity, and poor sleep by age 12. Earlier phones mean higher risks.
    A phone phishing attack compromised Harvard's alumni and donor database, marking the second security incident at the university in recent months.
    AutoFlight's zero-carbon floating vertiport uses solar power to charge eVTOL aircraft while supporting emergency response, tourism, and marine energy maintenance.
    A new phone return scam targets recent buyers with fake carrier calls. Learn how criminals steal devices and steps to protect yourself from this fraud.
    New Anthropic research reveals how AI reward hacking leads to dangerous behaviors, including models giving harmful advice like drinking bleach to users seeking help.
    The Fox News AI Newsletter gives readers the latest AI technology advancements, covering the challenges and opportunities AI presents.
    Holiday email scams, including non-delivery fraud and gift card schemes, spike in November and December, costing victims hundreds of millions, the FBI says.
    Holiday visits offer the perfect opportunity to help older parents with technology updates, scam protection and basic troubleshooting skills for safer digital experiences.
    Swiss scientists create grain-sized robot that surgeons control with magnets to deliver medicine precisely through blood vessels in medical breakthrough.
    Researchers exploited WhatsApp's API vulnerability to scrape 3.5 billion phone numbers. Learn how this massive data breach happened and protect yourself.

    Groupware: What Works the Way Businesses Do?

    GroupwareThe internet is full of 1.5 million to 7 million... Read More

    Navision Attain C/ODBC Crystal Report ? Customization Example

    Microsoft Business Solutions Navision is main ERP application for European,... Read More

    The Hidden Power of Online Manual

    Writing software manuals is boring, isn't it? We often think:... Read More

    5 Mac Security Tips You Can?t Live Without

    So, you've bought a new Macintosh, and now you may... Read More

    Does your Company have Documentum?

    Are you lost in the mess of documents that get... Read More

    Review of TikiWiki Content Management System

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

    OEComplete ? A Personal Information Manager

    OEComplete is a utility for managing the personal information of... Read More

    Reloading Windows XP

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

    Instant Messaging is a Sweet Way to Communicate

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

    New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

    Three highly respected names in Human Resources have joined forces... Read More

    The Software 2005 Conference - A Review

    The Software 2005 conference is now a wrap. This conference,... Read More

    SQL Administrator Skills Required to Support Microsoft Great Plains

    Microsoft Great Plains is becoming more and more popular and... Read More

    Google Brings the Earth to Your Desktop

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

    Lotus Notes Domino and Microsoft CRM Integration

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

    MCP Market News: Microsoft SQL Server & SQL Reporting Services

    Are you ready? SQL Server 2005, the next-generation data management... Read More

    Microsoft Great Plains as ERP and Microsoft CRM as CRM

    If you have Microsoft Great Plains and support it for... Read More

    Windows x: Basic Windows ?Security? Issues

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

    Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

    Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More

    Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

    If you are software developer or database administrator - we... Read More

    Reduce Pop-ups and Annoying Ads

    There is many things more frustrating than surfing a website... Read More

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    netstat - Linux Command to Display Networking Information

    In linux, one of great commands for finding out information... Read More

    Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

    Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

    The Importance of Timely Timesheets

    Whether you are a small consultancy firm, a medium sized... Read More

    What To Do When Windows Wont Boot

    When Windows fails to boot it is normally caused by... Read More

    scheduled maid service Mundelein ..