How to decrease the number of decimal places in Currency Setup
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.
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.
- 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.
- Select the DYNAMICS database.
- Run the following statement to reset the decimal places to two. Note In this statement, "Z-US$" is the currency that you selected and then changed in the Currency Setup window.
UPDATE MC40200 SET DECPLCUR=3 where CURNCYID='Z-US$'
Set the "DECPLCUR" value according to the following table.
Number of decimal places that you want DECPLCUR value 0 1 1 2 2 3 3 4 4 5 5 6
Article ID: 865702 - Last Review: 03/28/2016 21:06:00 - Revision: 7.0
- kbnosurvey kbmbsmigrate KB865702