Blog

      What is Salesforce multicurrency?

Before we look at how multicurrency works and what you need to look out for, lets look at what it offers:

  • Adds the ability to record amounts in different currencies. If you don't have multicurrency enabled, then amounts are just displayed as an amount.

  • Allows amounts to be converted, displayed and reported according to exchange rates
  • Allows the use of dated exchange rates so the value at a certain time can be fixed

     Why Use Multicurrency?

  • You may have just added a custom currency field (as in the example below) to the records you need to record an alternate currency. Now you are finding you need a consolidated report of all amounts. Without multicurrency, you would need to run separate reports for each currency and then apply a conversion rate.


  • Opportunities can be entered in multiple currencies
    Opportunity in USD
  • Products can be priced in different currenciesProducts in AUD and USD
  • Reporting and forecasting can be done in record currency and corporate currency. ‘Converted’ fields are added and available for reporting.

Salesforce Currency Converted Report Field

Salesforce Converted Amounts Report

    What is Important to Know?

  • Once enabled, multiple currencies can’t be disabled
  • The enablement process temporarily locks your organization, preventing any integration processing and user logins. The lockout duration will be up 1 hour and done after 5pm by Salesforce.
  • You need to raise a case to request the enablement. Be sure to raise the case well before the date you want it enabled and ask for confirmation. Also be careful to specify the time you would like it done and your timezone. When I requested it, I asked for it to be done after 5pm on a certain date. It was actually done around 3am the next morning.
  • Upon enablement, all existing records are stamped with a default currency code that you provide in your enablement request. Here is an example where the default currency code was set to Australian Dollar.Salesforce corporate currency
  • A currency field is added to standard and custom objects, even managed objects. Here is the standard currency field that was added to the Contact object.
    contact-currency
  • After enablement, all currency fields display the ISO code of the currency before the amount. For example, $100 displays as USD 100.
  • By default, all converted amounts in your organization rely on the current conversion rates defined for your organization. Conversion rates must be set and updated manually. Changing the exchange rate automatically updates converted amounts on all records, including on closed opportunities. This may not be the behaviour that you are expecting. Lets say you sold a contract in USD. You set the currency of the contract record to USD and record the amount in USD. You will see the amount displayed in USD and converted into AUD using the current exchange rate. So you will always have the current value of that contract in AUD, whereas what you really want is the value of that contract in AUD when it was sold.
  • In this example two currencies are defined, USD and AUD and the exchange rate between the default currency AUD and the additional currency USD is defined.Salesforce Exchange Rates Amounts
  • After enablement, the primary currency displays as usual and, optionally, a secondary currency amount appears in parentheses. The primary currency is typically the default corporate currency, unless it’s overridden at the record level. In the example below, two currencies have been enabled, and USD is selected. The amounts are show in the record currency and are converted to the corporate currency and shown in parenthesesSalesforce multi-currency opportunity selection

Salesforce multi-currency opportunity

  • When you change the default currency of a record, currency amounts are not converted; they simply display with the new currency code. In the example below, you can see a record was initially entered with the currency code of AUD and then changed to USD. The amount has stayed the same. After the currency code was changed, the corporate currency amount is now displayed in () using the current exchange rate.

Screen Shot 2014-06-01 at 3.14.12 PM

Screen Shot 2014-06-01 at 3.15.17 PM

    What Should I Look Out For?

  • The Salesforce documentation states: "When you change the default currency of a record, currency amounts are not converted; they simply display with the new currency code." This is true only if the record is updated with the Salesforce user interface
  • If DataLoader is used to update currency codes, any amounts in the records will be updated using the exchange rate defined.
  • If you do need to use Dataloader to update currency codes on existing records, set the exchange rate to 1:1, update the records and then set the exchange rate back to the correct value
  • The Salesforce documentation states: "You can opt to use dated exchange rates by using advanced currency management to track historical exchange rates." You may think advanced currency management will apply to all objects but it turns out it only applies to opportunities and opportunity related objects.
  • Roll up summaries will not work between an object that is enabled for advanced currency management and one that is not. For example if you have a rollup summary between opportunity and a custom object, or another standard object such as quotes, they will be automatically disabled. They will work only between two advanced currency management objects, e.g. "Opportunity and Opportunity Line Items”

What Certification are you studying for now?

Focus on Force currently provides practice exams and study guides for sixteen certifications

Salesforce Multicurrency – What You Need to Know

      What is Salesforce multicurrency?Before we look at how multicurrency works and what you need to look out for, lets look at what it offers:Adds the ability to record amounts in different currencies. If you don’t have multicurrency enabled, then amounts are just displayed as an amount.Allows amounts to be converted, displayed and reported according to exchange ratesAllows the use of dated exchange rates so the value at… Read More

Salesforce Multicurrency – What You Need to Know

Preventing Duplicate Records with Salesforce Config

The Salesforce mantra is ‘clicks not code’ so we always look for a config solution to a problem before resorting to code. While we can set the unique indicator on a custom field to prevent duplicate values for one field across records, how do we prevent records inserted with duplicate values across all or some of the fields? Do we need to write a trigger to handle this? Or is… Read More

Preventing Duplicate Records with Salesforce Config

Salesforce Case Management

In most every company which prides itself on taking care of its customer base to the fullest, the Salesforce native functionality of Case Management goes hand in hand with customer success. The departments in an organization that deal with customer service, product support, issue resolution and service requests can all benefit from utilizing the case management functionalities; and related automation options; within Salesforce. As described in Salesforce Service Cloud Overview … Read More

Salesforce Case Management

Using DataLoader with Lookup Fields

External Ids provide a convenient way to integrate data from an external system, by allowing the use of a unique record identifer for records instead of the Salesforce Id. For example, you may define an Account Code external id on the Account object, which is the unique key for an account record in an ERP system that is integrated with Salesforce. When using DataLoader or another integration tool to update… Read More

Using DataLoader with Lookup Fields

Salesforce Mass Email

When you hear that Salesforce has a mass email capability you may think that you don’t need a marketing automation package to do that for you. Dig a little deeper and you will find that although Salesforce can send mass emails, there are a number of limitations that may have you looking back at AppExchange products. Firstly, lets look at what you can do with Salesforce mass email capability. You… Read More

Salesforce Mass Email

Quick Start Guide to using Conga Composer with Excel

Conga Composer is one of the most widely used 3rd party AppExchange apps for document generation with Salesforce. It can be used to merge Salesforce data to produce documents in Word, Excel, Powerpoint, HTML Email and PDF format. Here is a quick guide to generating an Excel spreadsheet with data from Salesforce. Create Your Excel Template Define the Fields and Reports it will use Add Merge Fields to the Excel… Read More

Quick Start Guide to using Conga Composer with Excel

How to Delete Multiple Records from a Salesforce Related List

You may be faced with the situation where you need to be able to delete multiple records from a related list in one click. Standard related lists do not have a feature to select all and delete all selected records. The standard way to delete from a related list is to use the del link and delete each record individually. This can be very time consuming and tiresome if there… Read More

How to Delete Multiple Records from a Salesforce Related List

Salesforce Cross Filter Report Examples

You may have come across cross filters when learning about Salesforce reports but having no immediate need for them, forget about them. It is only sometime later when faced with a reporting challenge that you may delve back and find that they are very useful and may even solve a problem that you thought you could not do with Salesforce reports. Lets review what reports with cross filters can do:… Read More

Salesforce Cross Filter Report Examples

Salesforce Email Templates

When you send an email from Salesforce, such as when you use the Send Email button or triggered from a workflow, you can select an email template. Email Templates in Salesforce come in four different types: Plain Text HTML using Letterhead HTML Custom Visualforce Plain Text Email Template This is the simplest email template to create. You can create it very quickly by entering the email text and including the… Read More

Salesforce Email Templates

Salesforce Lead Conversion

I was looking for a process flow diagram, that describes what happens when a lead is converted in Salesforce. I couldn’t find one, so I made my own. Once a lead is qualified, the next step is to convert the lead. In Salesforce, when you convert a lead, there are a number of options that are part of the process flow. The first step is to press the convert button…. Read More

Salesforce Lead Conversion

How to Display a Traffic Light Indicator in Salesforce

Visual indicators are a great addition to a Salesforce page to highlight important information or values. Instead of just displaying a value, showing an image will make a much larger impact. Depending on the situation, it may be more suitable to just display a single indicator such as a caution or stop image, or if a variable can have a range of values, display a variable image according to which… Read More

How to Display a Traffic Light Indicator in Salesforce

Salesforce Platform Overview

There are a number of features and functionality that are part of the Salesforce platform and are available to all Salesforce solutions. They offer the technology or functionality that can be used either standalone (e.g. content management) or used to build upon (e.g. force.com code). As they are common across the different Salesforce applications (e.g. Sales Cloud, Service Cloud and custom applications) they are part of the Salesforce platform. The… Read More

Salesforce Platform Overview

Salesforce Activities Tab and List View

  You may wonder where the Activities tab is in Salesforce, so you can see a list view of activities. You can see the task list and calendar on the home page but what if you would like to see all of your tasks and events in a list. Well there is a way to get to a list view, but it is easy to overlook. In the calendar section… Read More

Salesforce Activities Tab and List View

Salesforce and Email – What are the options?

When it comes to Salesforce and email, it can get confusing to understand what the options are. Read on to discover 10 ways you can work with email and Salesforce together. Sending Email from Salesforce Some people may wonder whether integration to an email client such as Outlook is even necessary. If Salesforce could send and automatically process incoming emails, then couldn’t users just live in Salesforce and use it… Read More

Salesforce and Email – What are the options?