Microsoft Great Plains Upgrade ? Version 8.0 Overview For It Director/controller
|
If you have Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customizations, ctree/Pervasive migration to MS SQL/MSDE. As of right now it is reasonable to upgrade to Microsoft Great Plains 8.0
Is upgrade required? Not actually, but you have to consider these factors
? Technical Support discontinuation - the old version may not be supported - currently if you are on version 6.0 - support is already discontinued. You can not have Microsoft Business Solutions help you, but obviously you have MBS partners who can still help you. If you are on Ctree or Pervasive SQL, then your support expires December, 31 2004.
? Tax Updates/Magnetic media expiration - if you have US Payroll module and depend on it with W2 and other forms - you must stay with the version, which is supported and has tax updates. If you are on Ctree or Pervasive SQL - then you will not have tax updates for these platforms at the end of 2004 and your W2s maybe inaccurate. If you have a lot of employees - you may have issues with government.
? Following the Technology and Microsoft rules - Microsoft wants you to be on the newest platform and provides you the best support when you follow this rule
? If you do have heavy customization - we recommend you to skip one version, for example if you are on version 7.5 - do not upgrade to 8.0 and wait for the next version
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 eEnterprise 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 with 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 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Colorado, Kansas, Minnesota, Texas, New York, Washington, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
|
|
|
Ukraine It Myths Dispersed
While Ukraine is becoming a new popular IT outsourcing destination, there are still many myths about it and no clear understanding of the opportunities outsourcing to Ukraine can present. Let us look closely at some of those myths and find out whether there is any truth behind them.Myth No. 1 ? Ukraine is politically unstableThis myth has seen its rise in November-December 2004 during the events around the presidential elections that led to the Orange Revolution. However, presently there are no grounds for concerns. During the Orange Revolution, the Ukrainian people have shown their devotion to the democratic ideals and prevented the worst scenario from happening, bringing the legitimately elected president to the power. The new Ukrainian government has clearly voi...(related: Software)
Cisco Certification: Five Things To Do During Your Ccna Exam
There are plenty of articles out there about how to prepare for the CCNA exam. However, there are also things you can do to increase your chances of success on exam day during the most important part of the entire process -- the time that you're actually taking the test.
I've taken many a certification exam over the years, and helped many others prep for theirs. Here are the five things you must do on exam day to maximize your efforts.
1. Show up on time. Yeah, I know everyone says that. Th...(related: Software)
Software: What Suits Me?
Almost all new and major brand of PCs come with bundled software packages that can handle both business and personal needs.However, if you purchase a stripped down model, you might have to spend considerable time and money to add appropriate software packages you vitally need.Should that be the case, there are certain steps and factor you will need to consider to select the correct software for your computer.Write down your machines' vital statistics: i.e., operating system, amount of RAM and hard disk space available. You can access this information by going to the control panel and finally to system. If you have difficulty, select Help.In all ...(related: Software)
Microsoft Crm Customization ? Programming Closed Email Activity
Microsoft CRM is CRM answer from Microsoft and attempt to get market share from Siebel, Oracle and others traditional Client Relationship Management System vendors. Microsoft CRM uses all the spectrum of Microsoft recent technologies: .Net, MS Excha...(related: Software)
Marketing Your Winrunner Team
It won't matter how effective your WinRunner Team is if no-one outside your immediate organizatio...(related: Software)
Microsoft Crm Or Siebel
Siebel is traditional CRM market leader, however and mostly due to recession 200-2003, Siebel lost sizable portion of CRM market to new tiger, such as Microsoft CRM. Microsoft CRM s recent (2001) CRM answer from Microsoft and attempt top get market share from traditional vendors: Siebel, Oracle, Onyx. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress).We would like to give you Microsoft CRM selection advise, based on our MS CRM consulting practice, going back to its inception in 1999. This article ...(related: Software)
Msn Messenger Is A Sweet Way To Communicate
MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. I've just been 'hooked up' into Messenger and it's really a different kind of communication, quick, simplistic and even humorous with the capability to express your feelings with 'emotion' cartoons.With Messenger you can communicate with a group of close friends or business...(related: Software)
Story Development Software: Good Or Evil?
In the early days of the personal computer, we're talking the mid-'80s here, there was speculation that someday books would all be writen by computers. It sounded a little too science-fictiony for most writers. After all, words on a page---no matter how well they appear to work together---are meaningless without the insights and experiences of the writer behind them.At this point in time, I'm happy to report, computers are not writing all our books for us.However, writing software has progressed far beyond the basic word processing abilities of Word and Word Perfect.Today, we have a wide variety of story development software. Most can be used to write novels or screenplay...(related: Software)
Screenplay And Script Writing Software
When it comes to screenplay software each screenwriter needs to determine what they need from the program they purchase and pick one that fits their specific needs. Screenwriting software doesn't write the screenplay for you. Why do I say this? I don't want you to be under the impression one software application is "better" or the "best" script writing software. No script writing software should be chosen based on it helping you complete your screenplay "better" or "faster" than another.What makes a screenplay "better" is the skill and execution of the writer. What determines how fast a screenplay is completed is how fast the writer is with their skill and execution. Thinking particular screenplay software helps you write a bette...(related: Software)
Understanding Xml Server
XML Server can be a Web Server that stores the XML files in it and serves them on demand. The XML Server would have processing capabilities with an XML engine and to transform the XML document to other forms. Basically a server whi...(related: Software)
Free Microsoft Word Online Training Tutorial Resources
Microsoft Word is one of the most popular office applications that provide many features such as word processing, web publishing and database creation. Tapping into these Word resources, however, is not always easy and straightforward, leaving users stumped and puzzled.So where can you find out how to perform these great features in Microsoft Word? Below I have listed some great, free resources for help w...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software