Currency Conversion in Multicurrency Org.g

In organizations with multicurrency enabled, sometimes we desperately need a way to create formulas that convert an amount from one currency to another using the current exchange rate configured in the system.

It is absolutely annoying to find that the currency conversions are not made available for Salesforce formulas.

Given below is a sample scenario and the solution using a small piece of Apex.

Scenario:

A multicurrency organization with many accounts.
The account currency could be any of the active currencies.
Any account can have a number of contracts associated with it. These contracts could be for any regions in the world making it be in any currencies (also an active currency in the system).
Imagine the Account is in USD and it has four different contracts; one for Europe(in EUR), one for Japan (in JPY) , one for UK(in GBP) and one in USA (in USD). Each of the individual contracts will display the contract values in the records currency and in user currency; also possibly in the corporate currencies in any reports.
But if you want to see the Total contracts' value of the all the 4 contracts on the account to see the Account's worth, it is not possible to create a roll up summary; remember the Contract to Account relationship is just a look-up in Salesforce.
This demands that we need to convert each of the contract amounts from their currencies to USD, which is the Account currency, in order to sum it up and store it on the account record.

Solution:

Add trigger on the Contract to invoke the below given trigger handler class that convert the currencies and store it on the account. This solution creates a map of currency and exchanges rates in the memory and uses it for every conversion. The convertCurrency method can be used in any similar situations for currency conversions.

PS: This code snippet shows only the update trigger. This has to be extended for delete and undelete too. However, in case of the Contracts, an Insert trigger is not needed as it the contract will be created as draft always. So the update on the status will trigger the update trigger.

Contract Trigger:

trigger ContractTrigger on Contract (after update) {

ContractTriggerHandler conTriggerHandler = new ContractTriggerHandler();

}

        if(trigger.isAfter && trigger.isUpdate){

            conTriggerHandler.handleAfterUpdate(trigger.newMap,trigger.oldMap);

        }

}

Trigger handler class.

public class ContractTriggerHandler {

      Map<String, Double> CurrencyRates  =  new Map <String, Double>();

      public ContractTriggerHandler() {

            for (CurrencyType cRates : [SELECT ISOCode, ConversionRate FROM CurrencyType WHERE IsActive=TRUE]) {

                  CurrencyRates.put(cRates.IsoCode, cRates.ConversionRate);

            }

      }

      public  void handleAfterUpdate(Map<id,Contract> newMap,Map<id,Contract> oldMap){

            List<Contract> ConListToProcess = new List<Contract>();

            for ( Id ContractId : newMap.keySet() ){

                  if ( newMap.get(ContractId).Annual_Value__c != oldMap.get(ContractId).Annual_Value__c || newMap.get(ContractId).Status != oldMap.get(ContractId).Status) {

                        ConListToProcess.add(newMap.get(ContractId));

                  }

            }

            If(ConListToProcess.size() > 0)

                  updateAccountClassification(ConListToProcess);

      }

      public  void updateAccountClassification(List<Contract> ContractsList ){

            Decimal TotalContractValue = 0;

            Set<id> accIds = new Set<id>();

            List <Account> accListToUpdate = new List <Account>();

            for (Contract Contracstobject : ContractsList) {

                  accIds.add(Contracstobject.AccountId);

            }

            List <Account> accList = new List <Account> ([SELECT CurrencyIsoCode, Total_Contract_Value__c, OwnerId, (SELECT CurrencyIsoCode,Annual_Value__c from Contracts where Status='Activated') from Account WHERE Id in :accIds]);

           

            for( Account accObject: accList ) {

                  TotalContractValue = 0;

                  for (Contract contractlist : accObject.Contracts) {

                        if (contractlist.CurrencyIsoCode == accObject.CurrencyIsoCode) {

                              TotalContractValue = TotalContractValue + contractlist.Annual_Value__c;

                        } else {

                              TotalContractValue = TotalContractValue + convertCurrency(contractlist.CurrencyIsoCode,accObject.CurrencyIsoCode,contractlist.Annual_Value__c);

                        }

                  }

                  accObject.Total_Contract_Value__c = TotalContractValue;

                                                }

                  accListToUpdate.add(accObject);

            }

            update accListToUpdate;

      }

      public Double convertCurrency(String inCurrency, String outCurrency, Decimal inAmount ) {

            Double inCurrencyRate  = CurrencyRates.get(inCurrency);

            Double outCurrencyRate = CurrencyRates.get(outCurrency);

            Double amountInCorpCurr = inAmount/inCurrencyRate;

            Double outAmount = amountInCorpCurr *  outCurrencyRate;

            return outAmount;

      }

}

The key method here is convertCurrency.
This method has the following signature
public Double convertCurrency(String inCurrency, String outCurrency, Decimal inAmount ). The method accepts an InCurrency and OutCurrency and the Amount. It converts the Amount in InCurrency to an Amount in InOutCurrency and returns to the caller. This is done by converting the amount to the corporate currency and then converting the corporate currency to the OutCurrency.