web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Number of decimals

(1) ShareShare
ReportReport
Posted on by 4,131

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,

I have the same question (0)
  • Suggested answer
    Mohit Rampal Profile Picture
    12,565 Moderator on at

    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.

    pastedimage1678245832492v1.png

  • Suggested answer
    GirishS Profile Picture
    27,833 Moderator on at

    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.

  • Mariano Gracia Profile Picture
    on at

    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

  • jt1024 Profile Picture
    197 on at

    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

  • Suggested answer
    Mohit Rampal Profile Picture
    12,565 Moderator on at

    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 Profile Picture
    197 on at

    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.

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

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

  • jt1024 Profile Picture
    197 on at

    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.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans