Configure Currency Conversion Table:

You’ll set up conversion rates for the currencies you plan to use in your org. This will set the rate of conversion between your Functional and Reporting Currencies. You will set up the conversion rates in the Currency Conversion Table.

The currencies in the Currency Conversion Table must match the types of currencies enabled in Salesforce’s Active Currencies table. If these tables do not match, not all of your currencies will be accessible for Business Groups, Stores, and Sales Orders, and conversions will not work. Make sure you have the same type of currencies enabled in both tables. This is discussed previously in Manage Active Currencies in Salesforce.

For example: If JPY (Japanese Yen) is enabled in Salesforce’s Active Currencies table but not in Fonteva’s Currency Conversion table, JPY currency will not be available in your org and Community Portal.

Currency Conversion Table (Fonteva)

Fonteva’s Currency Conversion Table is located under Custom Settings. The conversions you set in this table will be referenced for all Business Group and Store transactions.

  1. Navigate to Settings > Custom Settings.

  2. Locate the Currency Conversion Table from the Custom Settings available and select Manage. The Currency Conversion Table will open.

The Currency Conversion Table has five different columns: Source Currency Code, Target Currency Code, Conversion Rate, Source Rounding Setting, and Target Rounding Setting.

  • Source Currency Code: This is the initial currency that will be converted. It is represented by an ISO code in the table.

  • Target Currency Code: This is the currency that the Source Currency will be converted into. It is also represented by an ISO code in the table.

  • Conversion Rate: This is the rate of conversion from the Source Currency to the Target Currency. You might also refer to this as the currency exchange rate. This is the rate at which the Source Currency will be converted to the Target Currency.

  • Source Rounding Setting: This setting will round the amount in the Source Currency to the nearest rounding value you designate.

  • Target Rounding Setting: This setting will round the amount in the Target Currency to the nearest rounding value you designate.

Rounding Settings:

The Currency Conversion Table uses decimals as rounding values for conversions. Here are some rounding values you can use in your conversions:

Rounding Value

Rounding Output

0.01

rounds to the nearest cent

0.5

rounds to the nearest 50 cents

1

rounds to the nearest dollar

10

rounds to the nearest 10 dollars

null

if the value is null, it will not round the converted amount

Creating a Conversion:

  1. From the Currency Conversion Table, click New. The Currency Conversion Table Edit screen will open.

  2. Type a name for your conversion in the Name field. This is required.

  3. Provide the Conversion Rate for the conversion.

  4. Provide the ISO code of the Source Currency in the Source Currency Code field.

  5. Provide the ISO code of the Target Currency in the Target Currency Code field.

  6. Provide a rounding value to round your Source Currency in the Source Rounding Setting. You can leave this empty if you prefer not to round your currency.

  7. Provide a rounding value to your Target Currency in the Target Rounding Setting. You can leave this empty if you prefer not to round your currency.

  8. Click Save to add the currency conversion to the table. You can also click Save & New if you want to create many new conversions at once. You will need to make conversions for every type of currency conversion you want to include in your org.

Make sure the types of currencies enabled in Fonteva’s Currency Conversion table match the currencies in Salesforce’s Active Currencies table. This is discussed previously in Manage Active Currencies in Salesforce.

The Currency Conversion Table reads entries both ways (USD to EUD and EUD to USD, for example.) You do not need to make extra entries to cover transactions back to your Source Currency from your Target Currency.

Next Steps:

Now that you’ve configured your currencies and ensured they are matching in both tables, it’s time to choose your Reporting and Functional Currencies. Learn how in Designate Reporting and Functional Currencies.