Microsoft Dynamics GP 7.5, 9.0 version update notes

3. Upgrading from Microsoft Dynamics GP 9.0 to 10.0. This upgrade is especially sensitive to Service Packs. Do not expect simply to insert GP 10.0 CD1 into DC drive and begin upgrade process - upgrade requires Service Packs matching list for GP 9.0 and for GP 10.0. In this article we would like to share with you one substantial Microsoft Dynamics GP 10.0 upgrade issue, when you are downloading Dynamics GP 10.0 DVD with Service Pack 3 incorporated
**ISSUE RESOLVED**This issue is resolved with Microsoft Dynamics GP 10.0 Service Pack 4. Install Service Pack 4 prior to launching Microsoft Dynamics GP 10.0 Utilities for the update to resolve the issue. Click HERE to download Service Pack 4.

Unlimited life Microsoft MCTS Training, Microsoft MCITP Certification at certkingdom.com




If you are updating from Microsoft Dynamics GP 9.0 with version 9.00.0337 or later and using Microsoft SQL Server 2000, the SEE30303 table will fail with the error "[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('." This table is for the Historical Inventory Trial Balance (HITB) product. Even if you do not use the product, the update will fail as it is installed by default. This issue will be addressed in an upcoming service pack. Refer to the workaround steps below:

a. Do not restore the company database. Leave the company database at the failed state.
b. Close Microsoft Dynamics GP 10.0 Utilities.
c. Run the following script in Query Analyzer:

UPDATE DYNAMICS..DU000030 set Status = 0, errornum=0 where fileNumber = 1 and PRODID = 5597

d. Run the following script in Query Analyzer to create the required index on the SEE30303 table:

CREATE UNIQUE CLUSTERED INDEX [AK5SEE30303] ON [dbo].[SEE30303]
( [GLPOSTDT] ASC, [ITEMNMBR] ASC, [QTYTYPE] ASC,
[SEQNUMBR] ASC )

By the way, the issue above is reported to be resolved in Microsoft Dynamics GP Service Pack 4

Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally. We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Colombia, Ecuador, Chile, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico. Please visit our information portal Pegas Planet: http://www.pegasplanet.com