Loading

User Record Shows Wrong Currency

Date de publication: May 3, 2023
Description

There are steps you can take if the currency displayed incorrectly and changing the user's default currency does not fix it.

For example, my organization only uses British pound (GBP) - other currencies are inactive - and the custom currency fields show the amount in Euro (EUR).

Résolution


The user record contains two currency fields, known as DEFAULTCURRENCYISOCODE and CURRENCYISOCODE.

  • The first one (DEFAULTCURRENCYISOCODE) is the user's Currency field in the Locale Settings section.
  • The second one (CURRENCYISOCODE) is not available via the User Interface and can be accessed only via API.
 

To fix the displayed currency on the record you would need to use API, for example, the Data Loader. Follow the steps below:

  1. Open the Data Loader, choose Export, select the User object and follow the prompts to export a CSV file. Export at least the ID of the user and CURRENCYISOCODE. It is recommended that you will also export the username, so you can verify you are working on the correct user.
  2. Open the CSV and amend the CURRENCYISOCODE for the relevant user record (for example, from EUR to GBP).
  3. Go back to the Data Loader, use the Update option, select the file, map the fields and follow the steps. Select the directory where the success and error files should be saved, then click Finish.
  4. When a pop-up message appears asking you to proceed, click Yes.
Numéro d’article de la base de connaissances

000385010

 
Chargement
Salesforce Help | Article