Archive for the ‘Mappings’ Category

Mapping fields between Invoice Product, Order Product, Quote Product and Opportunity Product

April 8th, 2011 DynamicsMSCRM No comments

Within CRM 4.0 and 2011 you cannot access the field mappings area for the Invoice Product, Order Product, Opportunity Product, and Quote Product entities in the Microsoft Dynamics CRM UI. To map between these entities you must query the sql database for the specific relationship GUID’s. 

In Sql run the following Query:

select SourceEntityName, TargetEntityName, EntityMapId from EntityMapBase where SourceEntityName in (‘opportunityproduct’, ‘quotedetail’, ’salesorderdetail’) and TargetEntityName in (‘quotedetail’, ’salesorderdetail’, ‘invoicedetail’);

With the appropriate result place the GUID in the following URL, setting the server:port and organiziontion appropriatly.


This will return a UI that will allow you to add the desired mappings.

  • Share/Bookmark
Categories: 4.0, Mappings Tags:

MS CRM Attribute Mapping Error When Importing Customizations

May 25th, 2010 DynamicsMSCRM No comments

Failure: Entity-Entity: This attribute map is invalid. A valid attribute map must meet these requirements:
-	The data type must match.
-	The length of the target attribute cannot be shorter than the source attribute.
-	The format should match.
-	The target attribute must not be used in another mapping.
-	The source attribute must be visible on the entity form.
-	The target attribute must be a field a user can enter data into.
-	Address ID values cannot be mapped.

This can be a number of thing however, in my case it was attributes that were mapped differently than expected. To resolve it I had to open the Customization XML file and review the mappings there were bring created, comparing then to the CRM instance. By then deleting the inconsistant ones on the tenant the XML file then imported correctly.

  • Share/Bookmark