**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.
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
No comments:
Post a Comment