Mapping fields between Invoice Product, Order Product, Quote Product and Opportunity Product
http://support.microsoft.com/kb/914921
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.
