Changing Decimal Places or Quantity In Microsoft AX

To change the number of decimal places in Microsoft Axapta 2012, follow these steps:
[ Note : the below example are given for Four Decimal Places, user can be can the same for more than 2 decimal places ]
1. Change the NoOfDecimals property of the AmountCur and Qty ExtendDataTypes to 4.
2. To do this, follow these steps:
a. Open the Axapta Object Table (AOT) by pressing CTRL-D on the keyboard.
b. Click Data Dictionary, and then click Extended Data Types.
c. Locate the AmountCur and Qty fields, and then change the NoOfDecimals property to 4.
d. Save the changes that you made in the AOT.
3. Change the round-off value for the exchange rates. To do this, follow these steps:
Path : Main Menu window -> General Ledger -> Setup -> click Exchange Rates.
a. Select the Currency -> Click the Round-off tab.
b. Set the round-off value to .0001 on all four modules. These are the following:
• General
• Sales Order
• Purchase Order
• Prices
Note You may have to expand the window to see all four modules.
The AmountCur ExtendDataType is used for pricing, and the Qty ExtendDataType is used for quantity amounts. When you change the NoOfDecimals property to 4, all fields and controls that are using these ExtendDataTypes are changed globally. The user can then type values with up to four decimal places.

When you change the round-off value, the value that the user types is saved correctly to the database. Make sure that you add enough zeros for the NoOfDecimals property that you specified. You must make sure to correctly set the NoOfDecimals property so that all four decimal places are used. For example, if you leave the round-off value at .0100, the Net Amount on a purchase order will be rounded to two decimals instead of four.

To make the changes to the decimal place visible for Production sessions and for Master Planning sessions, follow these steps:
1. In the Main Menu window, click Basic, click Setup, click Units, and then click Units.
2. Locate the unit of measure that you want to affect.
In the Decimals field, type 4.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>