[SalesForce] How to use Dated Exchange Rates values in formula fields

I have a formula(Checkbox) field on the Opportunity object, which shows TRUE, when Some_Value__c (formula(Currency)) field >= 6000$:

Some_Value__c / CURRENCYRATE(TEXT(CurrencyIsoCode)) >= 6000

Default currency in our org is USD, but we have records with other currencies. We also have enabled Advanced Currency Management is enabled. Salesforce use those currencies, which could be updated manually in Currencies (Setup -> Company Profile -> Manage Currencies). But in the Opportunity records in UI, currency rate values are always get from Dated Exchange Rates ((Setup -> Company Profile -> Manage Dated Exchange Rates)).

So we have different values because of different rate values. As I know, there is no ability inSalesforce to use Dated Exchange Rates values in Formula fields.

So the question is do we have any ability to use Dated Exchange Rates values to have actual values in Opportunity records?

Best Answer

So, you are correct that formula fields can not take advantage of dated exchange rates

An Opportunity will always use Dated Exchange Rates on all Currency fields with CloseDate being the lookup key across the configured Dated Exchange Rates.

If you wanted an Opportunity field to use a different exchange rate than would be specified by the CloseDate, you need to make that field a Number and set it via a trigger or Lightning Flow. It would never display OOTB with a currency symbol though unless you overrode that part of the page with VF or LWC

An example of how to do this can be found in this answer

Related Solutions

[SalesForce] How to use Advanced Currency Management (ACM) in Custom Objects

Short answer: you can't do this without a major investment.

Longer answer: my job is developing FinancialForce's PSA application, which requires supporting dated exchange rates and other ACM features on custom objects. Salesforce has confirmed to us more than once that there is no native way to do this, so we've implemented our own currency conversion from the ground up to support our needs. We do support reading the dated exchange rates from ACM's tables, but we still have to do all our own math on the conversions in apex logic. At the very least this means that you can tap into the same currency data for your calculations, even if the implementation of the logic must be done independently.

The net effect is that if you want ACM functionality outside of the officially supported objects you're going to have to build you own currency conversion system, and your own apex-managed rollups rather than using the native functionality, for this to work. If you do go this route you'll probably want to turn off parenthesized currency conversions as they'd use the non-dated rates and effectively lie to users of your custom currency system.

This is obviously a non-trivial solution to the problem, but it's the only one that's currently possible today.

[SalesForce] How to use custom currency in a input field

Unfortunately, the same problem exists in aura, but the workaround is to use ui:inputcurrency . LWC does not have ui-inputcurrency equivalent yet and thus you have to build it yourself.

You can use SLDS classes to give lightning look, you can refer my sample:

<template>

<div class="slds-form-element">
  <label class="slds-form-element__label" for="text-input-id-1" id="fixed-text-label">Price</label>
  <div class="slds-form-element__control slds-input-has-fixed-addon">
    <span class="slds-form-element__addon" id="fixed-text-addon-pre">£</span>
    <input type="number" id="text-input-id-1" placeholder="2000" aria-labelledby="fixed-text-label fixed-text-addon-pre fixed-text-addon-post" class="slds-input" />
    <span class="slds-form-element__addon" id="fixed-text-addon-post">euro</span>
  </div>
</div>
</template>

Playground Link : https://developer.salesforce.com/docs/component-library/tools/playground/jee6KjW0-/1/edit

Best Answer

Related Solutions

[SalesForce] How to use Advanced Currency Management (ACM) in Custom Objects

[SalesForce] How to use custom currency in a input field

Related Topic