Relationship mappings: quotedetail to salesorderdetail to invoicedetail

[DubSport]

I have CRM 4.0. How do I access the Relationship field mappings for
quotedetail -> salesorderdetail -> invoicedetail ?
I know it was possible in CRM 3.0 like this: http://support.microsoft.com/kb/914921
but this no longer works for CRM 4.0.


There has to be a way to do this in CRM 4.0!

I really just need a way to find the GUID of those particular mappings
then I should be good, but I don't know how to find that guid. Eg. I
need the guid for the mapping of "salesorderdetail->invoicedetail"
mappings.

WTF!

[DubSport]

anyone?

[Michael Höhne]

Hi Jamie,

In CRM 3.0 it was possible to modify the field mappings in the exported xml,
followed by an import. I don't recommend it though, because you may have
problems in deploying these customizations to another system. You also had
to use the correct sequence to make it work. I haven't tested in CRM 4.0 and
probably won't, because I found it too dangerous in the end.

[DubSport]

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

[Jamie Miley]

Here is how to do this in 2011 and 4.0 online also:
http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html

Post by DubSport
I have CRM 4.0. How do I access the Relationship field mappings for
quotedetail -> salesorderdetail -> invoicedetail ?
I know it was possible in CRM 3.0 like this: http://support.microsoft.com/kb/914921
but this no longer works for CRM 4.0.
There has to be a way to do this in CRM 4.0!
I really just need a way to find the GUID of those particular mappings
then I should be good, but I don't know how to find that guid. Eg. I
need the guid for the mapping of "salesorderdetail->invoicedetail"
mappings.
WTF!

Post by Michael Höhne
Hi Jamie,
In CRM 3.0 it was possible to modify the field mappings in the exported xml,
followed by an import. I don't recommend it though, because you may have
problems in deploying these customizations to another system. You also had
to use the correct sequence to make it work. I haven't tested in CRM 4.0 and
probably won't, because I found it too dangerous in the end.
--
Michael H?hne, Microsoft Dynamics CRM MVP
CRM Blog: http://www.stunnware.com/crm2
----------------------------------------------------------

Post by DubSport
anyone?

Post by DubSport
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
Submitted via EggHeadCafe
HTML5 And the Case of the Missing Browsers
http://www.eggheadcafe.com/tutorials/aspnet/f1d49041-7566-4c3a-9f4f-699513e1b66c/html5-and-the-case-of-the-missing-browsers.aspx

[Jamie Miley]

Here is how to map custom attributes between quotedetail to salesorder detail in 2011 online and 4.0 online:

http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html

Post by DubSport
I have CRM 4.0. How do I access the Relationship field mappings for
quotedetail -> salesorderdetail -> invoicedetail ?
I know it was possible in CRM 3.0 like this: http://support.microsoft.com/kb/914921
but this no longer works for CRM 4.0.
There has to be a way to do this in CRM 4.0!
I really just need a way to find the GUID of those particular mappings
then I should be good, but I don't know how to find that guid. Eg. I
need the guid for the mapping of "salesorderdetail->invoicedetail"
mappings.
WTF!

Post by Michael Höhne
Hi Jamie,
In CRM 3.0 it was possible to modify the field mappings in the exported xml,
followed by an import. I don't recommend it though, because you may have
problems in deploying these customizations to another system. You also had
to use the correct sequence to make it work. I haven't tested in CRM 4.0 and
probably won't, because I found it too dangerous in the end.
--
Michael H?hne, Microsoft Dynamics CRM MVP
CRM Blog: http://www.stunnware.com/crm2
----------------------------------------------------------

Post by DubSport
anyone?

Post by DubSport
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

Post by Jamie Miley
http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html
Submitted via EggHeadCafe
ASP.NET - Zip Selected Files and Add Files in Memory with DotNetZip
http://www.eggheadcafe.com/tutorials/aspnet/fd2b3765-624b-47ea-a461-bf3ad6dcbf7b/aspnet--zip-selected-files-and-add-files-in-memory-with-dotnetzip.aspx

[Jamie Miley]

Here is how to do this in CRM Online 2011 and 4.0

http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html

Post by DubSport
I have CRM 4.0. How do I access the Relationship field mappings for
quotedetail -> salesorderdetail -> invoicedetail ?
I know it was possible in CRM 3.0 like this: http://support.microsoft.com/kb/914921
but this no longer works for CRM 4.0.
There has to be a way to do this in CRM 4.0!
I really just need a way to find the GUID of those particular mappings
then I should be good, but I don't know how to find that guid. Eg. I
need the guid for the mapping of "salesorderdetail->invoicedetail"
mappings.
WTF!

Post by Michael Höhne
Hi Jamie,
In CRM 3.0 it was possible to modify the field mappings in the exported xml,
followed by an import. I don't recommend it though, because you may have
problems in deploying these customizations to another system. You also had
to use the correct sequence to make it work. I haven't tested in CRM 4.0 and
probably won't, because I found it too dangerous in the end.
--
Michael H?hne, Microsoft Dynamics CRM MVP
CRM Blog: http://www.stunnware.com/crm2
----------------------------------------------------------

Post by DubSport
anyone?

Post by DubSport
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

Post by Jamie Miley
http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html

Post by Jamie Miley
http://mileyja.blogspot.com/2010/12/map-custom-attributes-from-opportunity.html
Submitted via EggHeadCafe
JQuery Templates and the Topsy Otter Twitter Search API
http://www.eggheadcafe.com/tutorials/aspnet/e1431bb1-05be-4e4d-91dd-52e6d0aa6731/jquery-templates-and-the-topsy-otter-twitter-search-api.aspx

[Jamie Miley]

I also have to say that dubsport above obviously adapted my posting at the address below for his answer and posted it above. If you look at some of the broken sentences and other parts of the post you can find entire sentences copied from:

http://jamiemiley.com/wordpress/?p=11

All I wanted was a little credit :)

Submitted via EggHeadCafe
Microsoft ASP.NET For Beginners
http://www.eggheadcafe.com/training-topic-area/ASP-NET/7/ASP.aspx

[Ralf Ramackers]

What if I want to create a mapping from salesorderdetail to a custom
entity_detail? So a Order Products to Entity Products?

Is there a way to create a new EntityMapId ?

Thanks in advance!

Ralf