Great Plains Upgrade - notes from the field - Alba Spectrum

Softarea51.com is your source for all the latest computer technology and software related press releases.
Browse our archive for more press releases!

Released on: 31, December 1969
, Author: Alba Spectrum Group
, Audience: Computers related

Recommended: Click here to run a Free driver update scan »


In this small article we would like to share our MicrosoftDynamics GP version update experience, where upgrade was done for relatively largeGP 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 anycase latest service pack is recommended if you move your GP version to 10.0. Weunderstand that upgrade to 10.0 was really enabled for the majority of Great Plainscustomers only in November 2007, when Microsoft Business Solutions released GP 10.0SP11. Prior to 10.0 SP 1 upgrade. When SP1 was not yet released, we tried probingupgrade and got issues with POP10100 table, which was pretty popular issue, knownin 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 toversion 10.0 we got upgrade issues for table IV10200. So, our recommendation don t even try upgrade to 10.0 without service pack applied to your 10.0 upgradingworkstation.2. Service Pack 1 fixes. First of all the upgrade performance increased theupgrade time was reduced from over 20 hour to about 5 hours. Next the problemwith IV10200 disappeared.3. Check Links recommendation. In our case check links prior to upgrade would takeseveral days to run, which was not practical. However when upgrade was done and wewent into production on version 10.0, we saw multiple places where check links wouldbe a help: drilling down to GL open transactions, trying to open query to PM posteddocuments are two places. We immediately scheduled checklinks to run over next fewweekends 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 linksmay find integration business logic validation issues, so check with your customintegration developers if check links is safe thing to try4. FRx. This time the decision was made to move FRx to Citrix 32 bit (as you mayknow it is not fully compatible with 64 bit Citrix at this time). FRx 6.7 move wassurprisingly difficult we got a lot of problems, related to Citrix securityrestrictions. Also we got issues related to export to Excel as Microsofrecommended there should not be spaces in path and file name, otherwise export toExcel produces errors5. GP Security migration. As Microsoft explained in order to migrateold-fashioned security for users from 9.0 to new security model in 10.0, you GPworkstation installation path should not have spaces which was a bit surprising asregular upgrade process creates GP workstation in C:\Program Files\MicrosoftDynamics\GP, and this path obviously has spaces. Please be aware about securityupgrade problem6. Reports problems. Also, we got issue with Purchase Order Blank form. Bywhatever 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 inship to address calculated fields with Site master table this did the job, howeverit took us several hours to analyze the problem as not every PO was printed withblank ship to address. Company name was blanked on every report, until we replacedit with Company Name global field. Also this seems to be more often happeningproblem for 10.0 than it was happening for earlier versions Reports.dic becomescorrupt after several modifications of one of the reports the cure is simple: youmake a copy of corrupt Reports.dic and import reports into fresh Reports.dic. Thecorruption in our cases behaved in the inability to add new text fields these newfield were immediately turned to unknown field, when we moved cursor out of them7. GP Integration Manager in Citrix. IM didn t manifest any issues, when it wasmoved to Citrix 32 bit (the reason to stop it at 32 was eConnect .Net componentscompatibility)

And rew Karasev, Alba Spectrum Group, http://www.albaspectrum.com ,help@albaspectrum.com. 1-866-528-0577, 1-630-961-5918, serving GP customers USA andCanada Nationwide, local service in Chicago and Houston. We specialize intechnically challenging GP upgrade, integration, customization projects, includingGP support for large corporations. We also do Great Plains Dexterity programming:upgrade Dex modifications, Dexterity custom reporting, Crystal Reports. Give us acall if you need in-depth Great Plains technical expertise


Source: Express-Press-Release.com
Related downloads


Convert ANSI PST to Unicode PST with MS Outlook PST Upgrade utility that easily & quickly Upgrade Outlook PST files in to MS Outlook 2003/2007. PST Upgrade works as PST Degrade tool too and degrade PST 2007/2003 into Outlook 2002 & any older versions

Extensions for Windows is the first community driven, modular upgrade for Windows XP and Vista. It contains numerous new features, tools and applications seamlessly integrated with Windows, including 2-Panel Windows Explorer, Screen Capture and more.

Freebie Notes is a easy to use reminder for Windows. With Freebie Notes you can create notes displaying on your desktop. Your notes can be displayed immediately after creation or in the certain moments of time.

FREE, easy to use sticky notes for your PC -- great for desktop reminders,

Simple, yet cool notes that roll up and roll down, control them individually or all at once. Hide or show all with a click. Very easy to use, completely free.

Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven sound-topics with different listener-positions and changing backgrounds gives a long prolonged motivation.

Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven game-accompanied sound-topics and changing backgrounds gives Blocker Plains a long prolonged motivation.

With jk-ware Theater Blocker Plains, Color LIFE Sound and Perpetuum mobile can be started multiple times and run simultaneously. Think and purpose of jk-ware Theater is to test the capability of modern computers playfully.

You are a pilot of the plane, your goal is to destroy the city, erase it from the surface of Earth. Game control is not easy, but very easy! The bomb hatch is always open, simply press ANY key and the bombs will start to fall.

Real-time OscilloScope + FFT Spectrum Analyzer of data accepted from sound card or other ADC you will want.

This sophisticated piece of software turns your computer into a modern, State-of-The-Art spectrum analyzer giving you features that go far beyond the possibilities of any stand-alone hardware unit.
Softarea51.com RSS Feed

Get RSS updates on latest computer technology and software related press releases Subscribe to Latest Press Releases RSS feed    Subscribe



You are welcome to include these headlines in your own pages. If you want to find out how to parse this RSS file please read our tutorial How to parse RSS feeds with PHP.