Map data from opportunity product custom field to quote details custom field

(0) Share

Report

Posted on by Hilde Verhoeven

Issue:

I want to map custom fields to quote details from Opportunity product, when I create a quote.

Relationship mapping: https://archive.codeplex.com/?p=crm2011entitymaps this looked to be exactly what I need but the solutions isn't available anymore.

I checked also: https://www.inogic.com/blog/2012/12/add-mapping-for-custom-attribute-of-order-product-to-invoice-product/

But I can't found the ID's with the URL for D365 version 9.0
SourceEntityName = ‘opportunityproduct’ and TargetEntityName = ‘QuoteDetail’

So could someone help me to create the URL? Or maybe have an other solution for mapping the custom fields

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Michel van den Brink 4,697 on at

Like (7)

Report
Hello Hilde,

Take a look at the XrmToolBox ( https://www.xrmtoolbox.com ) a great multi tool for all things Dynamics 365.

This tool has a plug-in called 'Your Entity Attribute Mappings - Customized', which allows you to do what the 'crm2011entitymaps' solution used to do.

Open the XrmToolBox

Click 'Connect' and connect to Dynamics 365

Open the plug-in called 'Your Entity Attribute Mappings - Customized'

If it's not visible you can install it via the 'Plugins store' in the 'Tools' menu

Once you're in the 'Your Entity Attribute Mappings - Customized' panel:

From the column on the left ('Source'), choose 'Opportunity Product'

From the second column ('Target') choose 'Quote Product'

Click the green (+) icon to add a mapping

In the pop-up, select your custom field on 'Opportunity Product' from the list on the left ('Source Entity Fields')

Then select your custom field on 'Quote Product' from the list on the right ('Target Entity Fields')
Make sure that these fields are exactly the same type and size!

Click 'OK'

Hope this helps you get started. If you have any other questions, please let me know!

If you found my answer helpful, please help the community by marking it as verified :-)

Was this reply helpful? Yes No
Hilde Verhoeven 50 on at

Like (0)

Report

Thanks, it works fine!

Was this reply helpful? Yes No
Michel van den Brink 4,697 on at

Like (2)

Report

Great to hear everything works, Hilde!

If you could, please help the community by marking my answer as verified. This will help people with the same question find the answer even faster :-)

Was this reply helpful? Yes No
Suggested answer

Tobias Almada 5 on at

Like (0)

Report

thank you very much, it helped me a lot

Was this reply helpful? Yes No
Dan365 37 on at

Like (0)

Report

Hello, I've just found this post which is very helpful. I was wondering what happens if my field does not show up after clicking the green plus button?

Was this reply helpful? Yes No
DynamicsNik 75 on at

Like (0)

Report

Hello Michel,

I have solved the problem discussed in this thread with your help using the xrm toolbox.

At this point I would like to thank you!

But I have another question. If I use the crm toolbox for a mapping in the dev stage, how can I include the mapping in a patch to transfer it to QA/Prod?

Many thanks!

Best regards Niklas

Was this reply helpful? Yes No
Amy B 5 on at

Like (0)

Report

For anyone following these instructions, we used this solution and the new mappings were included in the solution XML when we deployed to a different environment. I think you would need to publish the customisations first (after adding the mappings) and include both entities in the solution for the mappings to be included.

Was this reply helpful? Yes No