Software informational articles

Great plains dynamics/eenterprise upgrade ? equipment to be concerned about and faq - software


If you have Great Plains Dynamics/eEnterprise (version 6. 0 or earlier) and aid it for your business then you need to know some industrial facts about Great Plains edition 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. Now you are in all probability accepted wisdom to upgrade to Microsoft Great Plains 8. 0 or 7. 5.

What is upgrade in the dialect of technology? Upgrade has attendant and client sides.

  • Server side - upgrade converts tables from old arrangement to the new one. In all-purpose words - Microsoft Big business Solutions developers may adjust table structure, append added fields to add new functionality, equipment like that. Upgrade copies the table with changes to impermanent table, then drops creative table, recreates it with new arrange and copies all the data from temp table to the newly produced one.

  • Workstation side - workstation is on paper in Great Plains Adroitness 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 adapted gossip (in REPORTS. DIC) could not be upgraded and need to be recreated in the new version.

What is customization upgrade? You ought to be concerned about altered types of customizations: Dexterity, VBA/Modifier, SQL, ReportWriter, Rock Reports

  • Dexterity Customization - being very short - Adroitness may have so called Custom Forms - these do not need upgrade - they must work as is. Then Ability may alter offered Great Plains forms (so-called Alternating Great Plains forms) - in this case Agility customization be supposed to be redone for these forms/screens. Plus bonus contemplation must be given to Adroitness 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. Commonly modification is introduction new buttons or fields, which in turn will be given VBA scripts (stored in DYNAMICS. VBA). VBA scripts may call a little nice, like Gem Report, or have some data admission logic. Commonly the old adaptation of DYNAMICS. VBA workds with the new version. You may need to rearrange buttons on the customized form.

  • SQL - you may have some stored procs for data integration, EDI or the like - if the addressed tables will be misrepresented in the new description then you need to dissect your SQL code. The good news is - Microsoft Big business Elucidation doesn't make a lot of changes since description 7. 0, as Microsoft is now frustrating to merge the goods it owns: Great Plains, Solomon, Navision and Axapta - and so has altered priorities

  • ReportWriter - MBS doesn't alter tables, but it keeps altering Adroitness formulas used in ReportWriter earliest information - this is the badly behaved in so-called Customized Information upgrade - commonly you have these information modified: SOP Blank Bill form, SOP Blank Preference ticket, etc. If arrive can not be upgraded - it must be redone in the new account with some exceptions.

  • Crystal Information - the nice thing about Gemstone Bang - id doesn't need to be upgraded (if the fields in the tables exist in the new account - which is commonly 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 benefit for upgrade. You just need to know that your third-party is ready for the new Great Plains adaptation - 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 fit Great Plains on SQL Attendant with just the same account/segments build up and then fit migration tool (it is Agility chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to aim at SQL-based Great Plains Company, decide on all classification and band tables, click the badge 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 - or else you have to do blue-collar move, use SQL Allied attendant to your birthright data

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

  • You have Adroitness customization

  • You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, exceptionally when you have third-parties not including migration tools

  • You have a lot or ReportWriter Bespoke Great Plains Reports

  • You have old edition of Great Plains: Dynamics or eEnteroprise 6. 0 or prior - in this case you can not ask to Microsoft Industrial 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 cliquey your Microsoft Commerce Solutions Partner and pay for the twelve-monthly 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.

About The Author

Andrew Karasev is Chief Know-how Detective in Alba Spectrum Technologies - USA countrywide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia and having locations in manifold states and worldwide (www. albaspectrum. com), he is CMA, Great Plains Licensed Master, Dexterity, SQL, C#. Net, Gemstone Information and Microsoft CRM SDK developer. You can call Andrew: andrewk@albaspectrum. com

akarasev@albaspectrum. com


Developed by:
home | site map © 2018