+ Start a Discussion
SFDC0539SFDC0539 

Different currencies for rollup field and detial object

Hi ,

 

Is it possbile to have different currencies for the detail object and the rollup field of that detail on the master object. If so can you please guide me on how to achive it.

 

 

 

Thanks...................

Best Answer chosen by Admin (Salesforce Developers) 
sfdcfoxsfdcfox

The rollup total will show the value in terms of the parent record's currency. You can have multiple details in multiple currencies, and the sum will be calculated using the organization's default currency, then translated to the currency for the record.

All Answers

sfdcfoxsfdcfox

The rollup total will show the value in terms of the parent record's currency. You can have multiple details in multiple currencies, and the sum will be calculated using the organization's default currency, then translated to the currency for the record.

This was selected as the best answer
craigmhcraigmh

Yeah, it's horrible. I ran into that issue this week:

 

"If a query includes a GROUP BY or HAVING clause, any currency data returned by using an aggregate function, such as SUM() or MAX(), is in the organization's default currency. You cannot convert the result of an aggregate function into the user's currency by calling theconvertCurrency() function."

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_querying_currency_fields.htm

 

 

http://success.salesforce.com/ideaView?id=08730000000b1lLAAQ