Customer experience | Sales, Customer Insights,...

Map custom fields from quotedetail entity to salesorderdetail entity

(0) Share

Report

Posted on by Samantha73

3,317

Hi All

I know how to map fields from the Quote to SalesOrder (header) but how do I map fields on the line level? From quote product to Sales Order Product? Is this something I can do from relationships mapping or need a plugin? When a quote is converted to an order it should auto populate the fields
Thanks

Categories:

Dynamics 365 Sales

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

jonasschwarzwaelder 58 on at

Like (1)

Report
Copy link

Link copied!
Hi Samantha,

You're correct that mapping fields from Quote to Sales Order at the header level is straightforward via entity relationship mappings. The same principle applies for line-level mappings between Quote Product (QuoteDetail) and Sales Order Product (SalesOrderDetail). Just make sure you keep the following things in mind.

Field Mapping: Quote Product ➝ Sales Order Product

You can map custom fields between Quote Product and Sales Order Product using standard entity mappings, provided the system relationship between the two is leveraged during the quote-to-order conversion process.

In the following the two paths for setting it up:

Use the Classic Customization UI (Legacy)

Navigate to Advanced Settings ➝ Customizations ➝ Customize the System.

Go to Entities ➝ Quote Product (QuoteDetail) ➝ 1:N Relationships

Find the relationship to Order Product (SalesOrderDetail)

Open the relationship and click Mapped Fields to define your field mappings.

Alternatively, use XrmToolBox

Use the "Your Entity Attribute Mappings" plugin for a more intuitive interface.

Just ensure that the relationship is included in your solution if you plan to transport it across environments.

Important Notes:

Field Types Must Match: The source and target fields must have identical data types (e.g., Text to Text, Option Set to Option Set) for the mapping to work correctly.

This mapping only applies when the standard quote-to-order conversion process is used. Custom processes may require plugins.

Hope this helps clarify things!

Was this reply helpful? Yes No
Samantha73 3,317 on at

Like (0)

Report
Copy link

Link copied!
followed the steps however below steps I cannot find the EIXISTING relationship to edit? It seems there is no existing relationship

Find the relationship to Order Product (SalesOrderDetail)

Was this reply helpful? Yes No

Join the conversation

Community site session details

Map custom fields from quotedetail entity to salesorderdetail entity

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Map custom fields from quotedetail entity to salesorderdetail entity

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates