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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s