Fx Currency type field is not taking value up to 3 decimal places

Sandeep87
Tera Contributor

‎03-28-2023 12:48 AM

Hi Servicenow Community,

I have requirement to update the "Fx currency type" field through script for 3 decimal place value. Its inserting record in "fx_currency2_instance" but on the incident table where the field is located its not taking value with 3 decimal places.

0 Helpfuls
  • 827 Views
1 REPLY 1

Community Alums
Not applicable

‎03-28-2023 01:25 AM

Hi @Sandeep87 ,

 kindly go to the System properties and select the value of the glide.currency_price.use_all_fraction_digits property to true.

 

SandeepDutta_0-1679991827274.png

 

  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.

 

  1.  
Specific number of digits that should appear after the decimal, with selectable values from 0 through 12. If you select more than 1, it pads the values with zeroes.
  • For example, if you select 3, and the calculated value is 1.1, the currency value appears as 1.100.
  • If you select 5, this value appears as 1.10000.

 
0 Helpfuls