Dynamics Ax 2012 High Precision Value Support for Float

Finance and Operations/AX Developer Forum
1

Hi Everyone,

I am facing the new problem. That is I cant able to give a float value(7 digit Precision) into the Real or EDT’s. It is only taking the 2 digit precision and it also round up the value in the 2nd digit. For Example if I give 48759.1234567, it is only taking the 2 precision ( 48759.12 ) and it is rounding up the value. In this I want to display the total exact value like 48759.1234567 this. I have tried more EDT’s and Real value for the table Fields. But I can’t. [:(] Is there any other way to take the full Precision of float value and store it exactly in a table column…?

Please help me If you know about this…

You will be appreciated…

Thanks In Advance…

2

AX definitely supports more than 2 decimal places, therefore it must be related to the EDT, there must be some rounding or you’re merely displaying it incorrectly in GUI.

As the first thing, verify whether the value is rounded in database or it’s just a problem with displaying.

3

Hi Martin,

Thanks for your reply. In database(AOT Table) it roundup the value like above conversation sample. In that I have tried with (Amount) EDT and Real EDT with Property “NoOfDecimals=7” and also tried with some other EDT’s which is still not taking the Exact value of the Float. In Table at which data type of field I need to use…and you know any other EDT which supports exact Float value like this(43785.5426135). Please let me know the EDT or any other data type which supports exact value like above given value. In the database level it need to take the exact float value. so It has to be needed for the table field…Please help me if you really know about this…

Thanks In Advance…

4

Do this with me:

  1. Create a new EDT based on real and set NoOfDecimals = 7.
  2. Create a new table.
  3. Drag the EDT to the table.
  4. Save the table.
  5. Open it in table browser.
  6. Create a new record.
  7. You should see the value as 0.0000000.
  8. Set 1.23456 to the field and save.
  9. The value is displayed as 1.2345600.

Do you say it behaves differently in your system?

5

Hi Martin,

Thanks a lot …

It is Working good …

Thank you for your great help. [:D]