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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / how to change decimal ...
Microsoft Dynamics AX (Archived)

how to change decimal place from 2 to 4

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All

      Under Trade Agrmt ---> Sale Price, I want to made change on the "Price" field from 2 decimal place to 4.   Would be greatly appreciated if anyone know the solution.

Thanks in advance!

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi, this is a trivial change.  The extended data type PriceUnit is used for this sales price field.  This is an extension of EDT:  Qty

    You would have to change the noOfDecimalPlaces property on the Qty EDT to accomplish this.  This however will change any field that off hand uses this EDT so it will affect many other places in the system.

    Another solution would be to create your own EDT with 4 decimal places and assign the sales price field the created EDT.

    Search this forum, there are many discussions on it.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Good Morning Bob

          Thank you very much for your prompt response.  I made change accordingly and also made change  on "AmoungCur" field to have 4 on "NoOfDecimalPlaces"

    Have a nice day!

  • Lars Bergmann Profile Picture
    Lars Bergmann 25 on at

    Hi

    I have been assigned this task as well but with the addon that the user must be able to set this up dynamically in a form, e.g. with the following fields in the table:

    Table, Field, NoOfDecimals

    Is that possible without altering the AOT? I have also thought about a setup and a sync button that reflected the setup in the AOT but it will not work as each field doesn't have it's own ext. type.

    Thanks!

    Best regards,

    Lars

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Lars,

    I would strongly recommend that you not do this.  You can customize a form and update EDT's via x++ but to enable end users to do this is not a good idea.  Whenever you change a property like this the db needs to synchronize to update the tables that use it.  Doing this in a live environment with many users would open up many possible problems.  I would push back on this request.

    Regards.

  • Lars Bergmann Profile Picture
    Lars Bergmann 25 on at

    Hi Kent

    Thanks for your input, much appreciated!

    The AOT is not "touched" so that it needs a db sync when changing the amount of decimals displayed on an ext. type so that should be an okay thing to do.

    However I am looking into this together with the consultant and so far the scope is forms only. I can then solve it by adding a few lines of code in the class SysSetupFormRun and altering the running form.

    Best regards,

    Lars

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans