Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. How to decrease the number of decimal places in Currency Setup

How to decrease the number of decimal places in Currency Setup

View products that this article applies to.

In Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains, you increase the number of decimal places in the Currency Setup window from the original setting. Then, you try to reset the number to the original setting.

When you do this, you receive an error message that states that the number of decimal places for a currency cannot be decreased after the currency has been saved.

↑ Back to the top

Cause

This issue occurs because you can only increase the number of decimal places in the Currency Setupwindow. If you try to decrease the number, you receive the error message that is mentioned in the "Symptoms" section because of an issue in which reports may be incorrect because of rounding. The error message is to prevent problems on your trial balance.

↑ Back to the top

Resolution

To resolve this issue, follow these steps.

Important Use this method if you have to change the decimal places back to two (or to another number) and if you have not entered any transactions by using the additional decimal places.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
  1. If you are using Microsoft SQL Server 2000, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    If you are using Microsoft SQL Server 2005, click Start, point to Programs, point to Microsoft SQL Server 2005, click SQL Server Management Studio, and then click New Query.
  2. Select the DYNAMICSdatabase.
  3. Run the following statement to reset the decimal places to two. 
    UPDATE MC40200 SET DECPLCUR=3 where CURNCYID='Z-US$'
    Note In this statement, "Z-US$" is the currency that you selected and then changed in the Currency Setup window.

    Set the "DECPLCUR" value according to the following table.
    Number of decimal places that you wantDECPLCUR value
    01
    12
    23
    34
    45
    56
Note If you are using SQL Server Desktop Engine (also known as MSDE 2000), use the Support Administrator Console. For more information about how to do this, contact Microsoft Business Solutions Technical Support at 1-888-477-7877.

↑ Back to the top

Keywords: kbnosurvey, kbfreshness2007, kbmbsgp10,, kbmbspartner, kbmbsmigrate, kb

↑ Back to the top

Article Info
Article ID : 865702
Revision : 1
Created on : 1/7/2017
Published on : 3/28/2016
Exists online : False
Views : 190