Displaying Money Field from Related Entity in a View Error – Need to Add Currency Field From the Related Entity to the View

One of our Microsoft CRM Online customers asked us how come a money field from a related entity doesn’t display the value within a view he had created (via Advanced Find).
To illustrate this issue – We would like to display the "Credit Limit" from the Account’s Primary Contact in an Account View.
To prepare for this, we setup an Account’s Primary Contact "Test Contact One" with a "Credit Limit" value of "100.00":
We then created an Advanced Find on the Account entity to display both the "Credit Limit" fields (Currency and Base) of the Account’s Primary Contact:

When we run this Advanced Find on Microsoft CRM v4.0 On-Premise – we received this error:
An if we run this Advanced Find setup on Microsoft CRM Online – we didn’t get an error, but the "Credit Limit" (Currency) value is blank!

The cause of this issue was due to the "Currency" field not present in the view.  Our Advanced Find views above for both Microsoft CRM v4.0 On-Premise and CRM Online are working properly after adding the "Currency" field from the Primary Contact!

Contact us if you need help with your Microsoft CRM.  Free Estimate.
Workopia, Inc.
Microsoft Dynamics CRM MVP

Follow Workopia on Twitter

FREE 30-Day Trial, Setup & Training – Microsoft CRM Online
 Sign up for a FREE 30-Day Trial, Setup & Training

About Frank Lee

Microsoft Dynamics 365 CRM/xRM consultant in San Francisco, USA.  Awarded the Microsoft MVP (Dynamics 365/CRM) 12 consecutive years from 2006 to 2018. Actively involved with Microsoft Dynamics CRM implementations since Microsoft CRM v1.0 beta (2002). Super passionate about everything CRM, especially in the areas of Cloud Computing, A.I., Digital Transformation and Automation.
This entry was posted in Microsoft Dynamics CRM. Bookmark the permalink.

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 )

Connecting to %s