|
Great Plains Upgrade: notes from the field Alba Spectrum
In this small article we would like to share our Microsoft Dynamics GP version update experience, where upgrade was done for relatively large GP databases: over 70GB the largest company and we had 5 companies of similar size. Upgrade path was 7.5->9.0 service pack 2 and then to 10.0 service pack 1. In any case latest service pack is recommended if you move your GP version to 10.0. We understand that upgrade to 10.0 was really enabled for the majority of Great Plains customers only in November 2007, when Microsoft Business Solutions released GP 10.0 SP1
1. Prior to 10.0 SP 1 upgrade. When SP1 was not yet released, we tried probing upgrade and got issues with POP10100 table, which was pretty popular issue, known in 7.5 to 9.0 upgrade. Also Microsoft upgrade 9.0 SP2 to 10.0 (no service pack) took substantially longer than upgrade from 7.5 to 10.0. In our case in moving to version 10.0 we got upgrade issues for table IV10200. So, our recommendation dont even try upgrade to 10.0 without service pack applied to your 10.0 upgrading workstation.
2. Service Pack 1 fixes. First of all the upgrade performance increased the upgrade time was reduced from over 20 hour to about 5 hours. Next the problem with IV10200 disappeared.
3. Check Links recommendation. In our case check links prior to upgrade would take several days to run, which was not practical. However when upgrade was done and we went into production on version 10.0, we saw multiple places where check links would be a help: drilling down to GL open transactions, trying to open query to PM posted documents are two places. We immediately scheduled checklinks to run over next few weekends to cure all the companies. Warning for customers with custom integrations, where data is moved to GP through SQL stored procedures in your case check links may find integration business logic validation issues, so check with your custom integration developers if check links is safe thing to try
4. FRx. This time the decision was made to move FRx to Citrix 32 bit (as you may know it is not fully compatible with 64 bit Citrix at this time). FRx 6.7 move was surprisingly difficult we got a lot of problems, related to Citrix security restrictions. Also we got issues related to export to Excel as Microsof recommended there should not be spaces in path and file name, otherwise export to Excel produces errors
5. GP Security migration. As Microsoft explained in order to migrate old-fashioned security for users from 9.0 to new security model in 10.0, you GP workstation installation path should not have spaces which was a bit surprising as regular upgrade process creates GP workstation in C:\Program Files\Microsoft Dynamics\GP, and this path obviously has spaces. Please be aware about security upgrade problem
6. Reports problems. Also, we got issue with Purchase Order Blank form. By whatever reason temp table, which is replacement to POP10100 had empty company name, and ship to address fields. In order to work around we had to replace this table in ship to address calculated fields with Site master table this did the job, however it took us several hours to analyze the problem as not every PO was printed with blank ship to address. Company name was blanked on every report, until we replaced it with Company Name global field. Also this seems to be more often happening problem for 10.0 than it was happening for earlier versions Reports.dic becomes corrupt after several modifications of one of the reports the cure is simple: you make a copy of corrupt Reports.dic and import reports into fresh Reports.dic. The corruption in our cases behaved in the inability to add new text fields these new field were immediately turned to unknown field, when we moved cursor out of them
7. GP Integration Manager in Citrix. IM didnt manifest any issues, when it was moved to Citrix 32 bit (the reason to stop it at 32 was eConnect .Net components compatibility)
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com , help@albaspectrum.com. 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide, local service in Chicago and Houston. We specialize in technically challenging GP upgrade, integration, customization projects, including GP support for large corporations. We also do Great Plains Dexterity programming: upgrade Dex modifications, Dexterity custom reporting, Crystal Reports. Give us a call if you need in-depth Great Plains technical expertise
Company: Alba Spectrum Group
|
| Related press releases |
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
Upgrading to Microsoft Great Plains 10.0 Alba Spectrum Chicago [2007-08-07 07:15:48]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP upgrade service in Chicagoland: downtown Chicago, Chicago Southwest subur...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Great Plains Dynamics upgrade notes Alba Spectrum [2007-09-22 04:08:07]
If your organization deploys GP Dynamics or eEnterprise ERP versions 7.5, 7.0, 6.0, 5.5, 5.0 or 4.0 you should consider upgrade scenarios, plus you should also consider reenrollment into Microsoft Bus...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Microsoft Dynamics GP 10.0 opening the door Alba Spectrum [2007-08-17 04:56:34]
Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com
Microsoft Great Plains version 10.0 is released and at this time, August 2007, upgrade activit...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
|
|
| Cute Reminder Standard Edition |
 Create non-annoying reminders and manage desktop notes with just one or two mouse clicks. The program supports schedule, history, skins, audio files (mp3, wma), printing and more. Elaborate nice interface provides comfort at your workplace. |
|
| Krakout |
 Remake of a classic Arkanoid style game. Destroy all bricks while keeping the ball on the playing field. Some bricks will give you special powerups such as missiles, gun, long or double pad, and many more! |
|
| Amazon Price Watch |
 Amazon Price Watch help you to keep track of the price, get notice when hot item is available or price drops for your wishlist, and find great deals or filler items when you need a bit more for free shipping. |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| SnapaShot |
 Smallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button. |
|
| QText |
 Saving notes. |
|
| FotoTagger |
 FotoTagger can annotate images and image areas, grab and organize images. Add tags pointing to specific objects. Display tags in a form of balloons. Upload/download images to/from Flickr. Publish to blog and HTML. Search, hide notes. Organize images |
|
|
Latest press releases
