The values in the Price Per Unit field and in the Amount field may be incorrectly rounded in Microsoft CRM 1.2 (908524)


The information in this article applies to:

  • Microsoft Business Solutions CRM Sales, when used with:
    • Microsoft CRM 1.2
  • Microsoft CRM 1.2

SYMPTOMS

Consider the following scenario:
  • In Microsoft CRM 1.2, a user who has administrative privileges has customized the Invoice Product form so that the Price Per Unit field and the Amount field are accurate to five decimal places.
  • You create a write-in product.
You may experience one or more of the following symptoms:
  • The value of the fifth decimal place in the Price Per Unit field is rounded.
  • In the Quantity field, the values on right of the decimal point disappear when you move the insertion point to another field.
  • The value in the Amount field is rounded to two decimal places.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem.

To resolve this problem immediately, contact Microsoft Business Solutions Technical Support to obtain the hotfix. You can log on to the Microsoft Business Solutions Support site and create a new support request. To do this, visit the following Microsoft Web site:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact Microsoft Business Solutions Technical Support by telephone at (888) 477-7877.

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Business Solutions Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information

Install this update on computers that are running Microsoft CRM 1.2 server. Additionally, you must run a SQL script against the Organization_Name_MSCRM database. To do this, follow these steps:
  1. On the server that is running Microsoft SQL Server services and where the Microsoft CRM databases reside, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. In Query Analyzer, change the database list so that the Organization_Name_MSCRM database is selected.
  3. Paste the following script into Query Analyzer. 
    Update OrganizationBase set PricingDecimalPrecision=4
  4. On the Query menu, click Execute.

Prerequisites

There are no prerequisites to install this update.

Removal information

You cannot remove this hotfix.

Restart requirement

If you are prompted, restart the computer after you install the hotfix.

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 tool in Control Panel.
File nameFile versionFile sizeDateTime
Crmmsg.dll1.2.3297.12316,08807-Sep-200519:52
Edit.aspxNot applicable8,62419-Oct-200503:41
Kb908524.dll1.2.3297.10110,97619-Oct-200505:59
Mscrmcustom.dll1.2.3297.204121,56807-Sep-200519:52
Crmhotfix.cdfNot applicable2,44919-Oct-200515:31
Mscrmcustom.dll1.2.3297.204121,56807-Sep-200519:52
Updspapi.dll6.1.22.0371,93607-Sep-200518:53

MORE INFORMATION

For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Modification Type:MinorLast Reviewed:9/8/2006
Keywords:kbfield kbBug kbMBSMigrate kbQFE kbHotfixServer kbpubtypekc KB908524 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.