Microsoft Dynamics GP 9.0 Service Pack 1 (SP1) is now available

Article ID: 919732 - View products that this article applies to.
Expand all | Collapse all

On This Page

Summary

Microsoft Dynamics GP 9.0 Service Pack 1 (SP1) is now available. This article contains information about how to obtain and how to install Microsoft Dynamics GP SP1. This article also contains a list of the documented problems that are fixed in this service pack.

For more information about the fixes that are included in this service pack and about how to install this service pack, see the installation guide that is included with this service pack.

More information

Service pack information

Service packs are cumulative. The problems that are fixed in a service pack are also fixed in later service packs. For example, Microsoft Dynamics GP 9.0 SP1 contains all the fixes that are included in 2005 Payroll Year End Update for Great Plains Version 9.0. You do not have to install an earlier service pack before you install Microsoft Dynamics GP 9.0 SP1.

For more information about how to obtain Microsoft Great Plains service packs, click the following article number to view the article in the Microsoft Knowledge Base:
904017 How to obtain service packs for Microsoft Dynamics GP and for Microsoft Business Solutions - Great Plains

For more information about how to install this service pack, contact Microsoft Business Solutions Technical Support. To do this, log on to the following Microsoft Business Solutions Support site, and then enter a new support request:
https://mbs.microsoft.com/support/newstart.aspx
Note For the subcategory, click INSTALL-SQL or INSTALL-MSDE.
You can also contact Microsoft Business Solutions Technical Support by telephone at (888) 477-7877.

Prerequisites

Before you install this service pack, follow these steps:
  1. Perform an SQL backup of all Microsoft Dynamics GP 9.0 databases.
  2. Back up all modified dictionary files. These include but are not limited to the following files:
    • Reports.dic
    • Forms.dic
  3. Have all users exit Microsoft Dynamics GP 9.0.

Removal information

You cannot remove this service pack.

Restart requirement

No restart is required.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformSP requirement
9.0sp1_install_guide_enus.pdfNot Applicable453,44223-May-200620:55Not ApplicableNot Applicable
Microsoftdynamicsgp-kb919732-v9-enu.mspNot Applicable48,391,68026-May-200616:41Not ApplicableNot Applicable

Installation information

For more information about how to install this service pack, see the 9.0SP1_Installation_Guide_ENUS.pdf file that is included with this service pack.

Problems that are fixed in Microsoft Dynamics GP 9.0 SP1

Collapse this tableExpand this table
ModuleArticle numberTitle
Analytical Accounting913663You cannot see all users in the User Access to Trx Dimension Codes window when you try to grant access to transaction dimensions in Microsoft Dynamics GP or in Microsoft Great Plains
Analytical Accounting913824Error message when you try to create a quick journal entry in Microsoft Dynamics GP: "Unhandled script exception: Long integer out of range"
Analytical Accounting913883An incorrect vendor ID for some transactions appears on the report when you run a distribution query or a multilevel query in Microsoft Dynamics GP or in Microsoft Great Plains
Analytical Accounting914890Error message when you run a distribution query in Analytical Accounting in Microsoft Dynamics GP or in Microsoft Great Plains: "Unhandled Script Exception class error dialog box"
Analytical Accounting914891Error message when you void a bank transaction after you install Analytical Accounting in Microsoft Dynamics GP: "An Error occurred executing SQL Statements"
Analytical Accounting914917No information appears in the "Journal Entry Inquiry" window when you use the "Journal Entry Inquiry" functionality in Microsoft Dynamics GP
Analytical Accounting915759When you export an Analytical Accounting budget to Excel, any negative budget amounts are exported as zeros
Analytical Accounting915760When you use the Correct Journal Entry window to create a backout entry and then a correcting entry, the transaction may not appear on any Analytical Accounting reports or queries in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Analytical Accounting915761Error message after you post a correcting transaction in Microsoft Dynamics GP and then print the Analytical Accounting error list: "The analysis type of transaction dimension <dimension_name> has been changed from not allowed to required"
Analytical Accounting916213You cannot change the Analytical Accounting information for intercompany distributions in Microsoft Dynamics GP or in Microsoft Great Plains
Analytical Accounting916214You cannot change numeric transaction dimensions by fractional amounts in the Analytical Adjustment Entry window in Microsoft Dynamics GP or in Microsoft Great Plains
Analytical Accounting916996Analytical Accounting details for each distribution in a transaction do not appear on the AA General Posting Journal report or in the "Analytical Accounting - Detail Journal Entry Inquiry" window in Microsoft Dynamics GP or in Microsoft Great Plains
Analytical Accounting917026Error message when you post a bank transfer in Cashbook Bank Management: "Error converting data type varchar to float. The stored procedure aagUpdateForAABMTransferPostJrnlRpt returned the following DBMS: 8114"
Analytical Accounting917251Error message when the originating currency differs from the functional currency in Analytical Accounting in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0: "Duplicate Key Error 2627"
Analytical Accounting917253Error message when you create a new user in Microsoft Dynamics GP or in Microsoft Great Plains: "A get/change first operation on table aaTrxDimCodeSetp failed accessing SQL_data"
Analytical Accounting917269Analysis information is incorrect or missing when you open the Journal Entry Inquiry window in Analytical Accounting in Microsoft Dynamics GP
Analytical Accounting917368You cannot open the Analytical Payables Manual Payment Entry window in Analytical Accounting in Microsoft Dynamics GP
Analytical Accounting918364Error message when you try to import an Analytical Accounting budget into Microsoft Dynamics GP or into Microsoft Great Plains: "Error converting data type varchar to numeric"
Bank Management914163The "Last Reconciled Balance" field in the "CBM ChequeBooks" list incorrectly displays the current chequebook balance in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Bank Management914165Error message when you run the Check Links process in Cashbook Bank Management: "The number of transactions do not match the number stored in the deposit header"
Bank Management916692Error message when you try to reconcile a chequebook in Cash Book Management in Microsoft Dynamics GP or in Microsoft Great Plains: "There is a problem with this Chequebook's balances"
Bank Management916717When you print a cheque, the amount in words is truncated to the hundredths place in Microsoft Dynamics GP and in Microsoft Great Plains
BAS & PAYG, or Business Activity Statement & Pay As You Go915466Several problems occur when you create a receivables transaction or a payables transaction that includes a terms discount amount and a Goods and Services Tax amount in Microsoft Dynamics GP
Collections Management915099A "Sent Letter" note is incorrectly attached to a customer record in the "Collections Management Main Window" window in Microsoft Dynamics GP
Extender916674Error message when you create an Extender view: "Table not found"
Extender916675The information that you entered in the Extender window is not transferred from the sales document, when you transfer a sales document to another type of document in Microsoft Dynamics GP 9.0 and in Microsoft Great Plains 8.0
Extender918506The EXT00100 table is not updated when you transfer a sales document that has Extender fields that were added to a line item in Microsoft Dynamics GP 9.0
Extender918507The "Hot Key" option is not saved with a window if you click the "Allow Hot Key" option in an "Extender Inquiries" window in Microsoft Dynamics GP
Extender918508The eOne logo appears in the pictures list in the Report Writer layout window in Microsoft Dynamics GP
Extender918510The value is not displayed in the Field Value column when you select a field that contains a List field type in the Extender Window Templates window in Microsoft Dynamics GP 9.0
Extender918511Error message when you click to select the "Auto Open" check box on an Extender Window for a scrolling window: "This method can only be selected when the selected window is a scrolling window"
Extender918512All SmartList objects and favorites are lost when you perform SQL maintenance on the "Explorer Favorites Master" object for Extender in Microsoft Dynamics GP
Fixed Assets919947Changes occur in the luxury automobile tax limits for depreciation schedules in Fixed Assets in Microsoft Dynamics GP
Human Resources916849How to install global updates for Human Resources in Microsoft Dynamics GP 9.0
Human Resources918940An ROE file that you submit from Payroll - Canada in Microsoft Dynamics GP 9.0 is rejected by Human Resources and Social Development
Human Resources918941Taxes are not withheld correctly on employee paychecks in Microsoft Dynamics GP or in Microsoft Great Plains
Human Resources919346An incorrect RECON batch is created in Payroll when you reconcile attendance transactions in Human Resources in Microsoft Dynamics GP
Human Resources/Canadian Payroll910744An update is available for Microsoft Dynamics GP that provides the Pay Steps functionality, a hotfix for updating Canadian Payroll, and the year-end tax updates for 2005
Inventory918253The inventory value is incorrect when you print the Historical Stock Status report for a historical date in Microsoft Dynamics GP or in Microsoft Great Plains
Manufacturing908545The numbers in the "On Hand Total" box and in the "On Hand Firm" box are incorrect for the week views and for the month views in the "MRP View" dialog box in Microsoft Dynamics GP
Manufacturing908546u receive a "The employee is not assigned a pay code, so the standard rate will be used" error message when you enter labor in the "Time Card Entry" dialog box and then post the labor in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Manufacturing914097You cannot select a range by MO number when you show MRP planned orders in the "Edit Manufacturing Order Status" window in Microsoft Dynamics GP
Manufacturing916779The printed MRP Exception Report does not include information for a purchase order that has a Planned Order release date that is in the past in Microsoft Dynamics GP or in Microsoft Great Plains
MultiLevel Checks914287The Spanish translation of check amounts is grammatically incorrect on multilingual checks that are printed in Microsoft Dynamics GP
MultiLevel Checks917612When you print Spanish-language checks for amounts in millions, the checks may use a singular Spanish word instead of the plural form in Microsoft Dynamics GP or in Microsoft Great Plains
Personal Data Keeper913847Error message when you try to select a cost category in the Timesheet Entry window of Personal Data Keeper in Microsoft Dynamics GP and in Microsoft Great Plains: "A get/change operation on table P_CPY_SETP_Income failed accessing SQL data"
Project Accounting900511The value of the PAShipmentExtCost field in the PA31102 table is incorrect in Microsoft Dynamics GP and in Microsoft Great Plains
Project Accounting910160Error message when you try to create a billing invoice in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0: "The default document number is invalid. Please check module setup"
Project Accounting910166The "On Account" amount is incorrect in the "Project Maintenance" dialog box in Microsoft Great Plains
Project Accounting912770Error message when you try to post a billing invoice in Project Accounting in Microsoft Dynamics GP: "You cannot post the document. All amounts should be positive or negative"
Project Accounting912771Message in the File Maintenance Error Report in Microsoft Great Plains after you run the PA Check Links File Maintenance Procedure: "Shipment Extended Cost was changed"
Project Accounting912772The project loss amount is overstated when you run revenue recognition for a project in Project Accounting in Microsoft Dynamics GP
Project Accounting913004Billing transactions outside the cut-off date are included in a revenue recognition transaction in Microsoft Dynamics GP
Project Accounting913006Error message when you try to reverse a fee that has been fully billed in Microsoft Dynamics GP: "The billing amount cannot be reduced to more than the previously billed amount"
Project Accounting913774Error message when you try to reverse a fee that has been fully billed in Microsoft Dynamics GP: "The billing amount cannot be reduced to more than the previously billed amount"
Project Accounting913775The cost and revenue distributions may be incorrect when you run revenue recognition for a project in Project Accounting in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Project Accounting916776A revenue recognition transaction produces incorrect costs and incorrect revenue distributions when you process several revenue recognition transactions for a project in Microsoft Dynamics GP
Project Accounting913777The program sorts and breaks down the content incorrectly in the Project Cost Breakdown report in Project Accounting in Microsoft Dynamics GP
Project Accounting914807A credit is posted to the earnings in excess of billings account instead of the billings in excess of earnings account in Project Accounting in Microsoft Dynamics GP
Project Accounting914809An incorrect distribution is created when you create a revenue recognition transaction in Project Accounting in Microsoft Dynamics GP
Project Accounting914885The actual cost on the project is not updated correctly when you manually enter the extended cost on a shipment transaction or on an invoice transaction in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Project Accounting915095The accrued revenue is incorrect when you enter an employee expense transaction that includes a unit of measure in Project Accounting in Microsoft Dynamics GP
Project Accounting915336A Billings in Excess of Earnings distribution is created even though the project status is completed when you create a revenue recognition transaction in Microsoft Dynamics GP and in Microsoft Great Plains
Project Accounting915338"Billings in Excess of Earnings" distribution is understated when you create a revenue recognition transaction for a fixed price project in Microsoft Dynamics GP
Project Accounting915469The billing amount is not calculated when you enter only purchasing transactions in Microsoft Dynamics GP
Project Accounting915470Error message when you enter a miscellaneous log transaction that has a negative value for the total quantity in Project Accounting in Microsoft Dynamics GP: "You are not allowed to have negative actual quantity"
Project Accounting915471Errors are generated in the Reconcile Utility report, and the value of the cost category is reset in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Project Accounting915474You experience slow performance when you run the Reconcile Utility in Project Accounting in Microsoft Dynamics GP
Project Accounting915475You experience slow performance when you select "PA Budgeting Cards" in the "PA Check Links" window in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Project Accounting915476The "Begin Date" field and the "End Date" field contain the posting date instead of the line item date when you post transactions in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0
Project Accounting915477Incorrect information appears in the Project Periodic Fee window when you run the Recreate Periodic utility in Project Accounting in Microsoft Dynamics GP
Project Accounting915572A loss amount is calculated for each cost category in Microsoft Dynamics GP 9.0 or in Microsoft Great Plains 8.0 even though only one cost category has a loss amount
Project Accounting915901The tax details are not included in the return transaction when you post a TM Return transaction in Project Accounting in Microsoft Dynamics GP
Project Accounting915913Some of the cost categories have the same loss amount when you create a revenue recognition transaction in Microsoft Dynamics GP
Project Accounting916490Error message when you try to select a cost category in the Timesheet Entry window of Personal Data Keeper in Microsoft Dynamics GP: "A get/change operation on table P_CPY_SETP_Income failed accessing SQL data"
Project Accounting916781The same loss amount is calculated for multiple cost categories in Project Accounting in Microsoft Dynamics GP even though only one cost category incurred a loss
Project Accounting916825A negative cost shows for a line item in the Purchase Receipts Inquiry window in Microsoft Dynamics GP and in Microsoft Great Plains
Project Accounting916951Hotfix rollup 916951 is available for Microsoft Dynamics GP 9.0
Project Accounting917009The subtotal is overstated in the Receivings Transaction Entry window in Microsoft Dynamics GP 9.0
Project Accounting917706Error message if you close the Billing Transaction Entry Distribution window in Project Accounting in Microsoft Dynamics GP: "The Unbilled Rev/Unbilled AR distribution(s) does not equal the actual amount"
Project Accounting918531Error message after you delete a fee from a billing invoice and then post that transaction in Microsoft Dynamics GP: "Distribution(s) contain errors"
Project Accounting918538Error message when you run the PA Check Links process in Microsoft Dynamics GP 9.0: "A remove operation on table 'PA_Project_Fee_MSTR' failed because the record could not be locked"
Project Accounting918539You experience slow performance when you match an invoice to a shipment transaction in Microsoft Dynamics GP 9.0
Project Accounting918540The Recreate Periodic utility does not create periodic records for each fiscal period for fees in Microsoft Dynamics GP 9.0
Project Accounting918541Amounts are posted to the Unbilled Accounts Receivable and Unbilled Project Revenue accounts when you process a purchasing invoice transaction for a project in Microsoft Dynamics GP 9.0
Project Accounting918542An invalid partially populated line is added to an invoice in Project Accounting in Microsoft Dynamics GP 9.0
Project Accounting918543Microsoft Dynamics GP 9.0 does not recognize revenue in the "Revenue Recognition Entry" window
Project Accounting918544The invoice quantity is incorrect when you try to bill a previously billed line item in Project Accounting in Microsoft Dynamics GP 9.0
Project Accounting918545An employee expense transaction is missing from the Time and Materials Billing window in Microsoft Dynamics GP 9.0
Project Accounting918546Error message when you enter a Return w/Credit transaction for a purchase order in Microsoft Dynamics GP 9.0: "The project number entered does not exist for the given PO"
Project Accounting918549Error message when you try to create a new project in Microsoft Dynamics GP 9.0: "Please enter MC Currency ID"
Purchase Order Processing919940You receive incorrect warning messages when you try to save a landed cost in Microsoft Dynamics GP 9.0
Receivables Management919718Description of the principal payments functionality in Receivables Management in Microsoft Dynamics GP 9.0
Report Writer928171Error message when you try to access Microsoft Dynamics GP: "Unhandled script exception: Object has no reference: EXECEPTION_CLASS_SCRIPT_BAD_PARAM, SCRIPT_CMD_DEFER_TABLE"
Safe Pay913825An electronic file uses the vendor name instead of the vendor check name in Safe Pay in Microsoft Dynamics GP and in Microsoft Great Plains
Sales Order Processing864073Sales tax is recalculated when you transfer a quote to an order or an order to an invoice in Microsoft Dynamics GP
Sales Order Processing912718Error message when you try to fulfill a serial-tracked item on a sales order in Microsoft Dynamics GP: "The line item was originally overridden. Do you want to select from the existing serial numbers?"
Sales Order Processing917071Error message when you try to copy a sales order in Microsoft Dynamics GP: "Message #0 missing"
System Manager918086Error message when you start Microsoft Dynamics GP 9.0: "GPS Error 61"
System Manager918532Error message when you try to create a new company by using Microsoft Dynamics GP 9.0 Utilities: "Could not find stored procedure '<DATABASENAME>.dbo.smGetDbo'"
US Payroll917063An employee ID of REPRINTED appears in the payroll tables when you void a paycheck during a pay run in Microsoft Dynamics GP 9.0
US Payroll918256Extra pay code line items appear on the paycheck stub for an employee in Microsoft Dynamics GP 9.0
Vat Daybook914162You can no longer use the 2005 VAT (Value Added Tax) Daybook report layout because of changes in the 2006 report layout in the German version of Microsoft Dynamics GP
Project Accounting920289The Work in Progress (WIP) account is not fully relieved when you bill a purchasing Shipment/Invoice transaction in Microsoft Dynamics GP 9.0

References

To download the most recent Microsoft Windows Installer update (MSP) file for Microsoft Dynamics GP, visit the following Microsoft Web site.

https://mbs.microsoft.com/customersource/support/downloads/servicepacks/MicrosoftDynamicsGP90_MSPReleases.htm

The issue that is described in the Summary section does not apply to Dynamics GP 10.0.

Properties

Article ID: 919732 - Last Review: October 24, 2012 - Revision: 7.0
Applies to
  • Microsoft Dynamics GP 9.0
  • System Manager
Keywords: 
kberrmsg atdownload kbmbsmigrate kbbug KB919732

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com