Finance | Project Operations, Human Resources, ...

Number of decimals

(1) Share

Report

Posted on by Yuji

4,125

Hi experts,

If the customer would like to display the purch price in 4 decimals, which EDT should I change? I tried to extend PurchPrice EDT, but I could not find a way to change it.

Thanks,

All responses (8)

Answers (0)

jt1024 185 on at

Like (1)

Report

RE: Number of decimals

I did, but when I check my environment I think I'm one of my ISV packages is missing or out of date. I'll have to solve that before I can see ProductQuantity with 4 decimal places.
Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: Number of decimals

Hi Jim, After changing number of Decimals, have you build all models and synchronic database?
jt1024 185 on at

Like (0)

Report

RE: Number of decimals

Hello Mohit,

Your advice pointed me in the right direction. I want to give credit also to community.dynamics.com/.../number-of-decimals-in-entire-application

Now I'm on to other beginner problems related to this... haha. I've changed the number of decimal places in an EDT extension but now I can't logon to the environment and AX Batch service won't start. I feel like I'm playing Whack-a-Mole! One thing at a time I guess.
Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (1)

Report

RE: Number of decimals

Hi Jim, You need to check 'No of Decimals Is Extensible' property on these EDTs as mentioned in above suggestions. If the EDT is true then you can extend the EDT and change decimal numbers. However, if false, check Extends property of that EDT and check again if IsExtensible property is true.

I think creating new EDT and replacing everywhere in application is not feasible.
jt1024 185 on at

Like (0)

Report

RE: Number of decimals

Hello Girish,

I have a similar task, I need to set Product quantity (ProductQuantity, CostQuantity, and CAMMagnitude) and related data types (price) to 4 decimal places. This is one of my first X++ customization assignments and I have no other mentors on staff to assist. So bear with me as I ask what I expect is a very beginner question.

I have read learn.microsoft.com/.../decimal-point-precision.

Above you say "Only option will be creating new EDT with No of decimal set to 4 and then map the EDT to table field."

The learn.microsoft.com page does not talk about mapping the new EDT to the required table fields. For such basic fields such as quantity and price does this mean any and all tables across the application will need to be remapped to the new EDT?

- Jim
Mariano Gracia on at

Like (0)

Report

RE: Number of decimals

Here in the docs it is explained which EDT's must be extended in order to achieve what you are looking for

learn.microsoft.com/.../decimal-point-precision
Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Number of decimals

Hi Yuji,

As Mohit mentioned you cannot change the No of decimal property as 'No of Decimals is Extensible property' is false.

Only option will be creating new EDT with No of decimal set to 4 and then map the EDT to table field.

It is not recommended to change the "Nos of decimal" of standard EDT through extension as it will affect all the places which uses them.

Thanks,

Girish S.
Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (0)

Report

RE: Number of decimals

Hi Yuji, No of Decimals can not be edited because 'No of Decimals is Extensible property' is false for this EDT (As shown in below screenshot)

PurchPrice extends PriceCur EDT but No of Decimals is Extensible property' is false for PriceCur EDT as well.

PriceCur EDT extends UnitAmountCur where No. of decimals can be changed. However, please note that it won't just impact PurchPrice field but on all EDTs which are extended from UnitAmountCur EDT.