Currency field increase the decimal value to show four decimals(example: 0.000 currently shows 0.00)

KrishnakantM
Tera Contributor

Currency field increase the decimal value to show four decimals(example: 0.000 currently shows 0.00)

I have updated the sys property 'glide.currency_price.use_all_fraction_digits' value to true now its accepting the decimals upto 4 but the filed default shows as 0.00 I am expecting it to show 0.000 on the field to avoid confusion.

KrishnakantM_0-1715102249262.png

Is there a way this can default set to show 0.000??

 

1 REPLY 1

Mark Manders
Mega Patron

Did you also try this:

  1. Navigate to All > System Localization > FX Currency Configuration.
  2. Click New.
  3. In the Table field, select the table that contains the FX Currency dictionary attribute.
    For example, if you created a custom table that stores transactional information and contains an FX Currency field, select it from the table listing. To learn more about creating tables in an instance, see Create a table.
  4. In the Field field, select the column with the FX Currency field type.
    For example, if you created a custom table column for entry of the transaction cost, select it from the listing of fields for the table.
  5. Click Save.
  6. Click the Display tab.
  7. In the Display Digits field, select the number of digits that should appear after the decimal point in lists and reports.
  8. In the Display Value Currency field, select what currency value appears in the designated FX Currency field on forms and lists.
  9. In the Aggregation Source field, select the currency type to use when aggregating currency amounts for the designated field on reports.
  10. Click Save.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark