
Video and Audio], Broadcasting and podcasting Broadcast On the Net

[description], Story, any other text you want to use.

Great Plains Dynamics/eEnterprise Upgrade – things to consider and FAQ

by: Andrew Karasev

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier) 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. Currently you are probably thinking to upgrade to Microsoft Great Plains 8.0 or 7.5.

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

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia and having locations in multiple states and internationally (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

akarasev@albaspectrum.com

web radio links

Brodcast On the Net - streaming video, streaming audio, video conferencing, audio
Broadcast On the Net. If you are running a search for video conferencing and are looking for audio streaming or video streaminng and web conferenceing then you have come to the proper place. You can find many of the finest sites with the best conferencing services. Even find video studios or maybe the video talent to produce your program, no matter what you are looking for you can see the best streaming media here.
Brodcast On the Net - streaming video, streaming audio, video conferencing, audio

web radio links - a high stand of information

When you’re seeking information about web radio links the results can seem extremely overwhelming. But relax, because we’ve sifted through all the web radio links web sites we could find and have discovered the finest ones that will produce the results you want, and how you want them.
We know how crucial good results are when you’re searching for web radio links. Some Internet sites are superior than others and will meet your web radio links requirements in a better fashion.

If you’re looking for a high standard web radio links site you know you can count on, we suggest the above web site. We have taken the tiresome task out of your web radio links shopping and reduced our list of web radio links web sites down to only finest around.

Being assured you’re receiving value for money is crucial in buying web radio links, so by visiting our web site you can expect the assurance that you are getting the web radio links you paid for.

By purchasing through our suggested links you can also rest assured your web radio links will be of a high standard. How do we know? Because when we’re shopping for web radio links ourselves it’s where we go.

You might be pondering why we’re suggesting you visit outside links rather than stay on our own web radio links site. Well it’s because we’ve only recently created our site so it's early days. Our goal is to be the best site for web radio links info on the net, and real soon we’ll achieve it. So please bookmark us and come back soon.

Broadcast On the Net Index

Main Menu
Broadcast On the Net
Site Map

Affiliate Ads, Links, news, etc.

News for 24-Dec-25

Source: BBC News - Home
Chile anger as jailed Pinochet reign abusers ask forgiveness

Source: BBC News - Home
Israel settlements: Netanyahu snubs 'shameful' UN vote

Source: BBC News - Home
Libyan hijacker arrested in Malta

Source: BBC News - Home
Drip dry

Source: BBC News - Home
Man 'in love' drives through airport

Source: BBC News - Home
Gorging on love

Source: BBC News - Home
Syrian girl with severe burns gets life-changing surgery

Source: BBC News - Home
Preserving Mali's rural life

Source: BBC News - Home
Sri Lankan court acquits five men in Tamil MP murder trial

Source: BBC News - Home
The technology of touch

Links
Links
Links

Take Your Meds Go Antiques Medical Meetings