Round off decimal value to only 1 decimal digit in Amount and Balance field

(0) Share

Report

Posted on by Mukesh Bisht

I have to round off the decimal values in 3343.image_5F00_2020_5F00_01_5F00_03T10_5F00_11_5F00_24_5F00_157Z.png the Amount and Balance field in Ledgers to only 1 decimal place

, Here the there are four decimal digits after the decimal in the Balance and amount field , is there any method that could be used to round it off to only 1 decimal value , please let me know how should I resolve this issue.

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mukesh Bisht,

As far as I remember the 'old' AX4 system, there is a GL parameter for the currencies that allows specifying how amounts are rounded.

Can you check this configuration in the currency setup forms and how the parameter setting was made?

You should be able to specify that INR amounts are rounded to 1 decimal place only.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mukesh,

Ludwig is correct with the rounding options on currencies. Note that it will round the amounts, but will not adjust the display on forms. To have just one decimal displayed on e.g. reports, you need to customize it.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good Morning Mukesh,

Have you been able to find the rounding option and have you been able to get your issue resolved in the meantime?

Best regards,

Ludwig

Was this reply helpful? Yes No
Mukesh Bisht 90 on at

Like (0)

Report

Hello Ludwig,

I couldnt find what you said tho I did try changing Decimal field in the properties of the Amountcur EDT , this however is not actually rounding the decimal digits , instead just making it 0 , for instance 425.8200 when rounded off should be 426 but instead it showing 425.0 , which is incorrect , maybe I have to right a Round off method to achieve this , Kindly do let me if this can be done by writing a method , cant find the rounding off option that u said either .

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi,

Please check the currencies form

Was this reply helpful? Yes No