Loading & querying currencies

posted Apr 22, 2016, 10:54 AM by Ezra Kenigsberg
Q: "What happens to currency fields when I change a record's CurrencyIsoCode?"

A: The currency values are converted from the old currency to the new currency.

If I change a currency field in the same update() call that modifies the record's CurrencyIsoCode, the currency field is interpreted in the new CurrencyIsoCode field value, without conversion.

  • the convertCurrency() function, 
  • the syntax for filtering mixed-currency records on a single value, and
  • the currency limitations of aggregate functions.