Software informational articles

Microsoft great plains upgrade ? equipment to bear in mind and faq - software


If you have Microsoft Great Plains and aid it for your band then you need to know some industrial fine points about Great Plains adaptation upgrade and what is going on at the back of the scenes, which options do you have in case of Dexterity, VBA, SQL customization, added density comes with migration from ctree/Pervasive to MS SQL/MSDE.

What is upgrade in the expression of technology? Upgrade has head waiter and client sides.

Server side - upgrade converts tables from old design to the new one. In common words - Microsoft Commerce Solutions developers may alter table structure, append added fields to add new functionality, belongings like that. Upgrade copies the table with changes to fleeting table, then drops creative table, recreates it with new build up and copies all the data from temp table to the newly bent one.

Workstation side - workstation is printed in Great Plains Ability and has Dynamics. exe - engine and DYNAMICS. DIC - dictionary. These two plus all the bonus files will be replaced with the new ones. Other dictionaries, such us REPORTS. DIC and FORMS. DIC be supposed to be also upgraded and upgrade will try to deal with them automatically. In some cases customized gossip (in REPORTS. DIC) could not be upgraded and need to be recreated in the new version.

What is customization upgrade? You be supposed to bear in mind altered types of customizations: Dexterity, VBA/Modifier, SQL, ReportWriter, Gemstone Reports

Dexterity Customization - being very short - Ability may have so called Custom Forms - these do not need upgrade - they must work as is. Then Adroitness may alter free Great Plains forms (so-called Alternative Great Plains forms) - in this case Adroitness customization must be redone for these forms/screens. Plus further concern ought to be given to Agility triggers, shadow tables, etc.

VBA/Modifier customization - Modifier allows you to amend free Great Plains windows - it creates so called customized Great Plains windows, stored in FORMS. DIC. By and large modification is introduction new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS. VBA). VBA scripts may call a bit nice, like Rock Report, or have some data admission logic. As a rule the old description of DYNAMICS. VBA workds with the new version. You may need to rearrange buttons on the custom-made form.

SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be misused in the new edition then you need to evaluate your SQL code. The good news is - Microsoft Affair Elucidation doesn't make a lot of changes since adaptation 7. 0, for the reason that Microsoft is now difficult to merge the food it owns: Great Plains, Solomon, Navision and Axapta - and so has altered priorities

ReportWriter - MBS doesn't alter tables, but it keeps varying Ability formulas used in ReportWriter earliest information - this is the badly behaved in so-called Adapted Gossip upgrade - as a rule you have these intelligence modified: SOP Blank Bill form, SOP Blank Alternative ticket, etc. If account can not be upgraded - it ought to be redone in the new description with some exceptions.

Crystal Hearsay - the nice thing about Gem Bang - id doesn't need to be upgraded (if the fields in the tables exist in the new edition - which is by and large 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 advantage for upgrade. You just need to know that your third-party is ready for the new Great Plains edition - 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 bed in Great Plains on SQL Ma?tre d'h?tel with accurately the same account/segments arrangement and then ensconce migration tool (it is Adroitness chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to aim SQL-based Great Plains Company, choose all coordination and ballet company tables, click the fasten 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 - if not you have to do handbook move, use SQL Allied head waiter to your bequest data

Do I need consultant? It is in all probability good idea to have consultant to do the upgrade. We brightly counsel you to use consultant in the subsequent cases

You have Adroitness customization

You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, chiefly when you have third-parties lacking migration tools

You have a lot or ReportWriter Bespoke Great Plains Reports

You have old description of Great Plains: Dynamics or eEnteroprise 6. 0 or prior - in this case you can not allure to Microsoft Mechanical Aid - 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 affair problems

You don't have aid - in this case you have to choice your Microsoft Affair Solutions Partner and pay for the once a year 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 Know-how Executive in Alba Spectrum Technologies - USA countrywide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Los Angeles, Houston, Atlanta, and Miami and having locations in numerous states and globally www. albaspectrum. com, he is Dexterity, SQL, VB/C#. Net, Gem Intelligence 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

Developed by:
home | site map © 2018