Archive for April 8th, 2011

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: