Microsoft KB Archive/896598

From BetaArchive Wiki
Knowledge Base


When you use the "Print Quote for Customer" command in Microsoft CRM Sales for Outlook, numeric values in the Microsoft Word document are incorrect, and the text "!Syntax Error" may appear in the "Ext Amount" column

Article ID: 896598

Article Last Modified on 9/8/2006



APPLIES TO

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



Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry


SYMPTOMS

When you use the Print Quote for Customer command in Microsoft Business Solutions CRM Sales for Outlook (the Outlook client), numeric values that appear in the Microsoft Office Word document are incorrect. Also, the document may contain one or both of the following problems:

  • In the Qty column, in the Unit Price column, and in the Discount column, the decimal point may appear in an incorrect location.
  • The following text may appear in the Ext Amount column:

    !Syntax Error


CAUSE

This problem occurs if the computer that is running Microsoft CRM Sales for Outlook is configured to use a regional setting other than the English (United States) setting. To locate this setting, open Control Panel, double-click Regional and Language Options, and then click the Regional Options tab.

The Print Quote for Customer feature in Microsoft CRM Sales for Outlook does not support localization settings for any setting other than the English (United States) setting. In particular, the following problems occur:

  • The feature does not support the use of any decimal separator other than a period.
  • The feature does not correctly interpret the "thousands" separator.

Therefore, if you use a regional setting that uses a comma as the decimal separator, such as the French (France) setting or the Spanish (Spain) setting, you experience the problems that are described in the "Symptoms" section.

RESOLUTION

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

904435 Update Rollup 2 is available for Microsoft CRM 1.2


Install this update on computers that are running Microsoft CRM 1.2 Sales for Outlook. After you install this update, you must modify the Quote mail merge template file. To do this, follow these steps:

  1. On the computer that is running Microsoft CRM Sales for Outlook, locate the Quote mail merge template file. This file is named Quote.dot. By default, the Quote.dot file is located in the following folder:

    Installation drive:\Documents and Settings\Microsoft CRM Sales for Outlook user account\Application Data\Microsoft\Templates\Mail Merge

    Note Installation drive represents the letter of the hard disk where the operating system is located. Microsoft CRM Sales for Outlook user account represents the alias of the Sales for Outlook user account.
  2. Double-click the Quote.dot file to open this file in Microsoft Office Word.
  3. On the File menu, click Save As.
  4. In the Save as type list, click Document Template (*.dot), and then type a descriptive name in the File name box.
  5. Click Save to save this template in the same location as the Quote.dot file.
  6. With this newly renamed template file open in Word, show field codes. If field codes are hidden, press ALT+F9.

    Note The ALT+F9 keyboard shortcut displays or hides field codes in the document. You can use the ALT+F9 keyboard shortcut to help format the template.
  7. Modify the number-display formatting in the document as follows. You can use the Replace command on the Edit menu in Word to find and replace all instances in the document.
    • If the operating system uses a European regional option other than one of the French options, take the following actions:
      • Replace all \# ####0.00 formatting patterns with \# "##.##0,00".
      • Replace all \# ###0.00 formatting patterns with \# "#.##0,00".

      Note European numbers appear with the following formatting:

      123.456.789,00

    • If the operating system uses one of the French regional options, take the following actions:
      • Replace all \# ####0.00 formatting patterns with \# "## ##0,00".
      • Replace all \# ###0.00 formatting patterns with \# "# ##0,00".

      Note French numbers appear with the following formatting:

      123 456 789,00

  8. On the File menu, click Save.

After you modify this template file, you can select the new template instead of the Quote.dot template when you print quotes from Microsoft CRM Sales for Outlook.

If you have already installed hotfix 896598, this hotfix will be enabled when you install the Microsoft CRM 1.2 update rollup. However, if you have not installed this hotfix, you must manually enable this hotfix after you install the update rollup.

If you install the update rollup but you have not previously installed the hotfix, follow these steps to enable the hotfix on a computer that is running Microsoft CRM 1.2 Server:

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then click the following registry subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM

  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type EnableLocaleDecimalChar, and then press ENTER.
  5. Double-click EnableLocaleDecimalChar, type 1 in the Value data box, and then click OK.
  6. Exit Registry Editor.
  7. Restart Microsoft Internet Information Services (IIS). To do this, click Start, click Run, type iisreset, and then click OK.


MORE INFORMATION

For more information about the terminology that is used to describe Microsoft product 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


Keywords: kbmbsmigrate kbpubtypekc kbqfe kbhotfixserver KB896598