|
Microsoft Great Plains 10.0 and 9.0 Upgrade Alba Spectrum
At this time (fall of 2007) Microsoft Dynamics GP customers are actively upgrading to GP version 9.0 and initial upgrades are performed to Microsoft Dynamics GP 10.0. Version 10.0 will be in more active upgrade mode, when Microsoft will release GP 10.0 Service Pack 1, as current GP 10.0 upgrade path is limited to 8.0 SP5 and 9.0 SP2. Having reasonable number of GP version updates performed, we would like to share experience. Lets' start with the most popular upgrade to 9.0.
1. As versions 8.0, 7.5, 6.0, and earlier are discontinued for Microsoft Dynamics technical support, you should consider this bell as strong signal to walk away from these older versions. Versions 7.5 and older were available on MS SQL Server as well as on Pervasive SQL 2000 (former Btrieve) and Ctree. In the case when you are on non-MS SQL Server DB - you will have to undergo migration step to SQL Server based version. Assuming that your case is straight forward, let's move on and review known version upgrade issues
2. Purchase Order Processing tables problems. If you are using POP module, then you must check you Purchase Orders and Receipts work and historical tables on the subject of so-called orphan lines. These tables should be verified: POP10110, POP10310, POP30110 and POP30310 - they store purchase orders and receipts lines. Microsoft recommends doing checklinks, prior to upgrade process, however we saw situations, where potentially check links dont do all the orphans cleaning job. If check links doesn't help, please construct the script which will give you orphans in lines table, similar to the following: select a.* from POP10110 a left join POP10100 b on a.PONUMBER=b.PONUMBER where b.PONUMBER is null. And again, prior to rescuing to scripting, you should try check links approach.
3. If after check links, upgrade failed on POP tables, you will have to restore DYNAMICS and all Companies DB to initial version and try data repair with scripting. Then design delete scripts with your DBA person. Microsoft partner should be able to apply failed company rolling back script, so you do not have to start from initial version for all the databases, however this script is confidential.
4. Other potentially problem tables. Weve also seen the problem with IV10200 table. In version 9.0 inventory valuation formula was revised and it now relies on IV10200 to higher extent. In some cases this table conversion script fails and upgrading application freezes. The remedy is roll back to initial version, be sure that you did check links
If you like us to help you with GP upgrade, integration, software licenses, reporting, please give us a call
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale
Company: Alba Spectrum Group
|
| Related press releases |
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...
|
|
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...
|
|
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 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...
|
|
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...
|
|
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...
|
|
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...
|
|
Old Great Plains Dynamics versions support, recovery and upgrade Alba Spectrum [2007-08-29 05:31:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 10630-961-5918
In best case scenario you as Microsoft Dynamics GP customer who is following the recommended ve...
|
|
|
|
| DBEXform |
 Make database application development and use as easy as using word processor or spreadsheet with DBEXform. It builds application logic in background and frees developer to just on building interfaces. Support for Microsoft Sql and Access databases. |
|
| 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. |
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
| Dutch Duck IE History Viewer |
 History, Favorites, Cache and Cookies Manager for Microsoft Internet Explorer, with options to sort, group, search, print and export. It allows to selectively erase items from your history--no need to erase your entire history. |
|
| 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. |
|
| OfficeCalendar for Microsoft Outlook |
 Share Microsoft Outlook calendar, email, contact, and task information with this affordable Exchange alternative. Makes Outlook calendar sharing and Outlook group calendaring easy. Works with Microsoft Outlook 2000, XP, 2003 and 2007. Free trial. |
|
|
Latest press releases
