AnsweredAssumed Answered

How to set the Currency for a Record conditionally?

Question asked by Greg Mackey on Jun 29, 2016
Latest reply on Jul 1, 2016 by Greg Mackey

If you have several currency fields on a Record, and you edit one of these fields to show $ instead of £, all the currency fields on the record Change, using the conversion rate. Changing the currency in the UI sets the Currency ID for the record and all values recalc - This is fine.


What I am wondering.. is there a way  conditionally set the currency of the record conditionally.

Our records have a "region" field, that we could use to determine the currency to display.


So if the record is for a client with a "US" region, we would want any currency fields to display $USD values and format.


I don't see the currency ID as a field that we can set in Process Author.


I can see the currency ID in the data table but changing tat dosn't convert the values, just changes their format.


Or is it better to let the currency be selected based on logged  user settings or something?

(using SugarCRM 7.7 Enterprise)