Advanced Find View with Related Entities

I came across an interesting error today when building an Advanced Find view on Service Activities with data fields added from the related Opportunity.  I received a generic error message when I ran the query so I turned Dev Errors on and ran the Advanced Find query again.  With Dev Errors on, I received a nice long error message that included, "transactionCurrencyId needs to be supplied to format a transaction money field".
I Binged the error message and found the answer.  It appears that you need to add the TransactioncurrencyID field of the related entity if you add currency fields from the related entity.  I added the currency field from the Opportunity and the Advanced Find query ran like a dream.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s