Discussion:
CRM 4.0 Opportunity Product, Quote Product ... attribute mapping
(too old to reply)
MScott
2008-05-02 19:35:00 UTC
Permalink
The Opportunity Product, Quote Product, Order Product, and Invoice Product
entities cannot have attributes mapped through the sales pipeline. There
appears to have been a fix for this for CRM 3.0 see

http://support.microsoft.com/kb/914921

I have tried using the Metadata Web Service (GetAppMetadataForEntity) to get
more information ...

http://[CRM_Instance_Name]/MSCRMServices/Metadata.asmx

... but the app fails when you provide an objectTypeCode with an internal
server error 500 message

A related problem exists with the inability to map Product information to
the Opportunity Product entity. The Product Description and Description
attributes can be added to the Opportunity Product views but there is not a
way to populate these fields.

There are key custom attributes which must be able to be mapped through the
sales pipeline in our implementation which is a migration off of Siebel.

Is anyone aware if MS is working on a fix or a workaround? I looked at the
Workflow engine as well and there is no access to these entities.
--
CRM Architect
MScott
2008-05-02 23:35:00 UTC
Permalink
DubSport posted the answer in a different post. Thanks.

Here is the solution:

In SQL Server 2005 Management Studio,

Run The query:
Select * from entitymapbase where targetentityname =
'salesorderdetail'

Returns 3 items, I look at the row with SourceEntityName "quotedetail"
and copy the GUID value of the EntityMapId of that row.

Then I use this URL and at the end of it I paste the GUID that I just
copied:

http://yourservernamehere/Tools/SystemCustomization/Relationships/Mappings/mappingList.aspx?mappingId=

This gives me the secret hidden mappings that I was after, between
"Quote Product" to "Order Product".


And if I run this query:
Select * from entitymapbase where targetentityname = 'invoicedetail'

I can find the GUID of "Order Product to Invoice Product" secret
hidden entity mappings. This is exactly what I was after.


Now I can map my custom attributes from Quote Detail > Order Detail >
Invoice Detail
--
CRM Architect
Post by MScott
The Opportunity Product, Quote Product, Order Product, and Invoice Product
entities cannot have attributes mapped through the sales pipeline. There
appears to have been a fix for this for CRM 3.0 see
http://support.microsoft.com/kb/914921
I have tried using the Metadata Web Service (GetAppMetadataForEntity) to get
more information ...
http://[CRM_Instance_Name]/MSCRMServices/Metadata.asmx
... but the app fails when you provide an objectTypeCode with an internal
server error 500 message
A related problem exists with the inability to map Product information to
the Opportunity Product entity. The Product Description and Description
attributes can be added to the Opportunity Product views but there is not a
way to populate these fields.
There are key custom attributes which must be able to be mapped through the
sales pipeline in our implementation which is a migration off of Siebel.
Is anyone aware if MS is working on a fix or a workaround? I looked at the
Workflow engine as well and there is no access to these entities.
--
CRM Architect
Kona
2008-07-23 22:46:02 UTC
Permalink
How anyone have an idea as to how to implement the same in a CRM 4.0 Online
environment? I am working on CRM 4.0 Online and cannot map attributes from
Quote Product -> Order Product->Invoice Product.

Please help....
thanks
Kona
Post by MScott
DubSport posted the answer in a different post. Thanks.
In SQL Server 2005 Management Studio,
Select * from entitymapbase where targetentityname =
'salesorderdetail'
Returns 3 items, I look at the row with SourceEntityName "quotedetail"
and copy the GUID value of the EntityMapId of that row.
Then I use this URL and at the end of it I paste the GUID that I just
http://yourservernamehere/Tools/SystemCustomization/Relationships/Mappings/mappingList.aspx?mappingId=
This gives me the secret hidden mappings that I was after, between
"Quote Product" to "Order Product".
Select * from entitymapbase where targetentityname = 'invoicedetail'
I can find the GUID of "Order Product to Invoice Product" secret
hidden entity mappings. This is exactly what I was after.
Now I can map my custom attributes from Quote Detail > Order Detail >
Invoice Detail
--
CRM Architect
Post by MScott
The Opportunity Product, Quote Product, Order Product, and Invoice Product
entities cannot have attributes mapped through the sales pipeline. There
appears to have been a fix for this for CRM 3.0 see
http://support.microsoft.com/kb/914921
I have tried using the Metadata Web Service (GetAppMetadataForEntity) to get
more information ...
http://[CRM_Instance_Name]/MSCRMServices/Metadata.asmx
... but the app fails when you provide an objectTypeCode with an internal
server error 500 message
A related problem exists with the inability to map Product information to
the Opportunity Product entity. The Product Description and Description
attributes can be added to the Opportunity Product views but there is not a
way to populate these fields.
There are key custom attributes which must be able to be mapped through the
sales pipeline in our implementation which is a migration off of Siebel.
Is anyone aware if MS is working on a fix or a workaround? I looked at the
Workflow engine as well and there is no access to these entities.
--
CRM Architect
Jamie Miley
2010-12-04 02:17:15 UTC
Permalink
Why yes I do, in 4.0 Online or 2011 Online

http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html
Post by MScott
The Opportunity Product, Quote Product, Order Product, and Invoice Product
entities cannot have attributes mapped through the sales pipeline. There
appears to have been a fix for this for CRM 3.0 see
http://support.microsoft.com/kb/914921
I have tried using the Metadata Web Service (GetAppMetadataForEntity) to get
more information ...
http://[CRM_Instance_Name]/MSCRMServices/Metadata.asmx
... but the app fails when you provide an objectTypeCode with an internal
server error 500 message
A related problem exists with the inability to map Product information to
the Opportunity Product entity. The Product Description and Description
attributes can be added to the Opportunity Product views but there is not a
way to populate these fields.
There are key custom attributes which must be able to be mapped through the
sales pipeline in our implementation which is a migration off of Siebel.
Is anyone aware if MS is working on a fix or a workaround? I looked at the
Workflow engine as well and there is no access to these entities.
--
CRM Architect
Post by MScott
DubSport posted the answer in a different post. Thanks.
In SQL Server 2005 Management Studio,
Select * from entitymapbase where targetentityname =
'salesorderdetail'
Returns 3 items, I look at the row with SourceEntityName "quotedetail"
and copy the GUID value of the EntityMapId of that row.
Then I use this URL and at the end of it I paste the GUID that I just
http://yourservernamehere/Tools/SystemCustomization/Relationships/Mappings/mappingList.aspx?mappingId=
This gives me the secret hidden mappings that I was after, between
"Quote Product" to "Order Product".
Select * from entitymapbase where targetentityname = 'invoicedetail'
I can find the GUID of "Order Product to Invoice Product" secret
hidden entity mappings. This is exactly what I was after.
Now I can map my custom attributes from Quote Detail > Order Detail >
Invoice Detail
--
CRM Architect
Post by Kona
How anyone have an idea as to how to implement the same in a CRM 4.0 Online
environment? I am working on CRM 4.0 Online and cannot map attributes from
Quote Product -> Order Product->Invoice Product.
Please help....
thanks
Kona
Submitted via EggHeadCafe
Microsoft LINQ Query Samples For Beginners
http://www.eggheadcafe.com/training-topic-area/LINQ-Standard-Query-Operators/33/LINQ-Standard-Query-Operators.aspx
Loading...