Microsoft Great Plains Upgrade ? Things To Consider And Faq
|
If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.
What is upgrade in the language of technology? Upgrade has server and client sides.
Server side - upgrade converts tables from old format to the new one. In general words - Microsoft Business Solutions developers may change table structure, append additional fields to add new functionality, things like that. Upgrade copies the table with changes to temporary table, then drops original table, recreates it with new structure and copies all the data from temp table to the newly created one.
Workstation side - workstation is written in Great Plains Dexterity and has Dynamics.exe - engine and DYNAMICS.DIC - dictionary. These two plus all the additional files will be replaced with the new ones. Other dictionaries, such us REPORTS.DIC and FORMS.DIC should be also upgraded and upgrade will try to deal with them automatically. In some cases modified reports (in REPORTS.DIC) could not be upgraded and need to be recreated in the new version.
What is customization upgrade? You should consider different types of customizations: Dexterity, VBA/Modifier, SQL, ReportWriter, Crystal Reports
Dexterity Customization - being very short - Dexterity may have so called Custom Forms - these do not need upgrade - they should work as is. Then Dexterity may alter existing Great Plains forms (so-called Alternate Great Plains forms) - in this case Dexterity customization should be redone for these forms/screens. Plus additional consideration should be given to Dexterity triggers, shadow tables, etc.
VBA/Modifier customization - Modifier allows you to modify existing Great Plains windows - it creates so called modified Great Plains windows, stored in FORMS.DIC. Usually modification is placing new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS.VBA). VBA scripts may call something nice, like Crystal Report, or have some data access logic. Usually the old version of DYNAMICS.VBA workds with the new version. You may need to rearrange buttons on the modified form.
SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be changed in the new version then you need to analyze your SQL code. The good news is - Microsoft Business Solution doesn't make a lot of changes since version 7.0, because Microsoft is now trying to merge the products it owns: Great Plains, Solomon, Navision and Axapta - and so has different priorities
ReportWriter - MBS doesn't change tables, but it keeps changing Dexterity formulas used in ReportWriter original reports - this is the problem in so-called Modified Reports upgrade - usually you have these reports modified: SOP Blank Invoice form, SOP Blank Picking ticket, etc. If report can not be upgraded - it should be redone in the new version with some exceptions.
Crystal Reports - the nice thing about Crystal Report - id doesn't need to be upgraded (if the fields in the tables exist in the new version - which is usually true statement)
What is upgrade for third-party modules? Your Great Plains may have so-called third party modules: Mekorma, Kampdata, Horyzon, Wennsoft, Avalara, Truepay, Trinity, Intellisol to name a few
Third party modules may have their own utility for upgrade. You just need to know that your third-party is ready for the new Great Plains version - if not - you just wait and stay on the old version.
What is migration from Ctree/Pervasive.SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data
Do I need consultant? It is probably good idea to have consultant to do the upgrade. We strongly recommend you to use consultant in the following cases
You have Dexterity customization
You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
You have a lot or ReportWriter Modified Great Plains Reports
You have old version of Great Plains: Dynamics or eEnteroprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems
You don't have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade
Good luck in upgrading and if you have issues or concerns ? we are here to help!
About The Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Los Angeles, Houston, Atlanta, and Miami and having locations in multiple states and internationally www.albaspectrum.com, he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.
If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
|
|
|
Recovering Microsoft Great Plains Customization ? Tips For It Director
Remember nice and prosperous Clinton era? When you implemented innovative those old days accounting application ? Great Plains Dynamics. And did a lot of customizations to fit your business requirements precisely. You still remember the names of consultants and programmers who did the job and probably the name of the company ? Great Plains reseller in your business metro. This compan...(related: Software)
Microsoft Office Selecting Secrets
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you may have even yelled at your computer when it happened. All you want to do is select (highlight) some text or data in a Microsoft Of...(related: Software)
Microsoft Update - 5 Reasons To Update Service Pack 2
Microsoft released Service Pack 2 (SP2) for the Windows XP operating system back in August (2004), re...(related: Software)
Microsoft Crm Customization
Microsoft CRM customization techniques are very diversified and based on the whole spectrum of recent Microsoft technologies. The main terms you should know are: Microsoft CRM SDK 1.2 and Visual Studio.Net 2003. And of course you should be familiar with all the legacy internet technologies, such as HTML, XML, XSLT, JavaScript and be good C#/VB/Net developer.If you are developer who is asked: how d...(related: Software)
Software Review: Xsitepro Total Site Management Software
It's not very often I get excited about a software program, but today I'm so excited I just had to tell you about Xsitepro, the top tool for Internet marketers. In particular, those who have been using HTML applications programs like Dreamweaver and Frontpage to produce their Internet media will find this program revolutionary in that it can at least halve your time for site development.In 1996 while studying a Master's degree in multimedia and online learning I learnt about HTML which seemed like a backward step after using and teaching wor...(related: Software)
25 Things Mapping Software Can Do For You
1. With mapping software you can create a report that tracks your retirement plan for you.2. Use mapping software to create an Executive Dashboard, which tracks the bottom line.3. Use mapping software to find the snowfall reports for your favorite ski resorts in Idaho.4. You can even use mapping software to explore an interactive map of India for school reports, business, or travel.5. Track your store incoming and outgoing inventory, including shipping information and warehouse location, mapping software.6. You can conveniently book your own airline seat, so you don't need to worry if you are a "window person" as opposed to an "aisle person."7. Know the who, what, when, where, and how of your department by using m...(related: Software)
Microsoft Crm And No-frills Cadillacs
In today's business world it's all but impossible to escape Microsoft. Either you're using MS applications, developing you...(related: Software)
Edi: Electronic Document Interchange For Microsoft Great Plains ? Overview For Software Developer/pr
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP system, originally targeted to mid-size - now, with advancements and increasing reliability of its database - Microsoft SQL Server, Great ...(related: Software)
Reporting For Microsoft Great Plains/dynamics/eenterprise: Rw ? Reportwriter ? Tips For Developer
Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexteri...(related: Software)
Adware And Spyware Blockers
The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your c...(related: Software)
Know Linux
Linux essentials:
- It's free for download but you have to pay a tiny bit to mail order it or buy it from a company. If you're getting Linux for more than 2-3 PCs, you can also get training and support at a small free, if you choose to have it. Else it's the Linux community on the Net to your rescue.
- If you want to get comfortable with Linux, you don't have to let go of windows. Get Linux installed on a seprate partition and you can switch between Windows and Linux. There are some Linux versions that run off CDs too-xandross and Knoppix.
- You don't have to be a geek to work with Linux. There are Desktop environments that let you work in Linux as you work in Linux as you would in Windows.
Windows X: Basic Windows ?security? Issues
Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inabilit...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software