Microsoft Great Plains Upgrade – Things to Consider and FAQ

Drubby World Wide Web Search

Microsoft Great Plains Upgrade – Things to Consider and FAQ

Drubby World Wide Web Search

Drubby's Popular Sites

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.
akarasev@albaspectrum.com
If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

GPS*Auto.com

WealthyMen.com
WeGiveCash.com
DVDit.us
eMovieSearch.com
Erect-IT.com
Golf GPS Products
Mister Linker

CHAT
iPod iTunes iLove
Song Lyrics Directories

MORE ARTICLES:

Web Site Owners Learn SEO (Search Engine Optimization) to Improve Search Engine Rankings
Web site owners are taking advantage of specialized training in search engine optimization to improve their overall search engine rankings.
Basic Differences Between Web Directories And Search Engines
Web directories and Search engines are two very common words these days which are being used wrongfully in many places. Although being mistaken as the same thing sometimes, they are actually two entirely different search services available to the web community. In this article, the fundamental differences between web directories and search engines will be briefly explained.
Search Engine Marketing 101: What Search Engines See When They Visit Your Web Site
If you have a Web site, have you ever wondered what a search engine sees when it visits your site to add the site to its index? Do you know that it doesn't see the beautiful graphics or the fancy Web design? Do you know that it only sees the source code, or the "skeleton" of your Web site?Do you realize that knowing this little tidbit of information and doing something about it can make a huge difference in your search engine rankings and, ultimately, the success of your online business?One very important thing that you need to remember is: the search engines like simplicity. The simpler your Web site is, the easier it is for the engine to determine what your Web site is about.
Search Engine Submission to Search Engine Optimization
A blog is shortened for Web Log. It can be termed as a regular web site because a blog also gets frequently updated with new content. Popular blogs are ones which get updated on a regular basis. They contain text ranging from various topics, backgrounds and genres. There are many of us who subscribe to these blogs through RSS (Real Simple Syndication) or Atom ?feeds?. These display the latest headlines and information, which saves navigation time. A blog is an increasingly popular medium and works also as a good e-Marketing strategy for creating and distributing Internet content.
Search Engine Optimization Firm, Brick Marketing Revises Search Engine Optimization Service
Brick Marketing, an internet marketing company, has recently revised and re-launched their search engine optimization services to adjust with growing trends. Brick Marketing has acknowledged that a revision of this product and the way it was offered to our clients had to be revised in order to stay competitive with other agencies. Potential customers can now be accustomed to similar pricing strategies has other players in the industry. The online marketing industry is a very fast moving industry with changes occurring sometimes over night. In order for firms and consultants to stay in a competitive range a watchful eye must be kept on all offerings in order to be able to provide only the best solution for clients.
YELLOW7 Interactive Named to Top 10 Search Engine Optimization Firms List by topseos.com
Topseos.com, a trusted and well-respected resource for evaluating internet marketing vendors, has announced the inclusion of YELLOW7 Interactive in their list of top 10 Search Engine Optimization firms in the US. Since 2002, topseos.com has evaluated the leading internet marketing services giving companies a trusted resource for locating the right online marketing vendors. Published each month, the top 10 list of Search Engine Optimization firms will feature YELLOW7 Interactive and is expected to reach more than 500,000 people.
Search Engine Submission Services Get Your Website Listed in Search Engines
Search engine submission services are the process of getting your web site indexed with search engines. Earlier the submission process was automated system. However, these days, most search engines have adopted measures to prevent this. This activity is generally done by experts in Search engine submission services. Getting listed on search engines does not mean that the sites will rank well for particular search terms. Rather, it is simply meant to get the search engine know about the existence of your pages. Visitors are of prime concern for any website owner. Search engine submission and website promotion are two noteworthy ways of driving traffic to your site.
Top Search Engine Marketing Firm Adds New Search Engine to Their Essential SEO 2.0 Tools
Blackwood Productions extends its arsenal of Search Engine Optimization tools and announces the endorsement of Search Engine SEOENG(TM) for reliable Search Engine Optimization results on top Search Engines.
Search Engine Optimization Tips: Rank High in the Search Engines for Your Keywords
Every internet marketer or webmaster aims to have their websites in the first page of the organic search results for their targeted keywords. In this article, Im going to reveal some vital search engine optimization tips that will boost your chances of being listed in the Top 10 results for your chosen keywords.
Watch Your Web Traffic Explode: Market To The Top 6 Search Engines
Search engines are responsible for almost 85% of all information researched online. That means if someone is looking for a product or service you offer, they will begin by typing a keyword or keyword phrase in a search box. Although there are thousands of search engine companies operating online, there are a select few that you can not afford to overlook. This article will give you some background information on the top 6 search engines.
Submit Your WebSite: Add Your URL to Web Directories & Search Engines
Why get into Search engines and directories?Increase backlinks of your webiste. If your website is listed in Directories then your website can get traffic from directries and search engines counting that backlinks for ranking of your website.
Guaranteed Top 10 Search Engine Results On Keyword Phrase Articles
If you are looking to get into online business or if you have already started on it then you know how difficult it can be. Promoting your website is really hard for you and there are a lot of things that you should learn. I bet you have started to write articles online that promote what you are trying to get across. However, did you know that there are really effective ways to get your message out there to everyone? You might even be using those pay per click companies that drain your money and only give you temporary success.
Search Engine Optimisation - The Top Ten Ranking Guide
Search engine optimisation is all about achieving a top ten ranking on the major search engines. This is a fiercely-contended task and to stand a chance of succeeding you need an internet marketing agency or SEO Consultants that can implement an online marketing strategy that will deliver not only traffic, but targeted traffic to get the results you require.
Top Search Engine Ranking Tips to Actually Rank For Any Keyword
All online marketers are looking for top search engine ranking tips to have their site rank well in Google and for good reason. Not only can Google send you a boatload of free traffic, it's also highly targeted, and is one of the best ways to drive your online business success.
Top Msn Position Search Engine Placement Search En
Search Engine Optimisation Uk: Recently search engines have been advancing their algorithms to try to detect pages that make use of hidden text for the purpose of rankings. Even though unethical SEO is tempting, and does work, you shouldn't do it - not only is it annoying to users, but it's likely to get you banned from the search engines sooner or later. You sites' search engine rankings just aren't worth the risk. Use efficient SEO techniques to get your site ranked higher, and stay away from anything that even looks like unethical SEO. SEO is a set of techniques used in order to attract visitors or prospective customers to your website, and the goal of a search engine is to provide high quality content to the users of the Internet. Thes...

Ask me how to get a site just like this...mdonovin@gmail.com | Site Map | Home