web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

How can we bring a column from Product Table to Quote Product Table?

(0) ShareShare
ReportReport
Posted on by 10

Hello all,

I am trying to use a custom column from our Product table in the Quote Product Table, in order to be able to use it in a quote template.

On the Product table, we have a custom column called Offering type. However, from Quote Product Table, I have not been able to get that Offering type relation, so I can use it in a quote template.

Does someone knows how we can do that?

Have a lovely day,

I have the same question (0)
  • Verified answer
    Leah Ju Profile Picture
    Microsoft Employee on at

    Hi HugoS,

    The Product table and the Quote Product(also named Quote Line) Table is 1:N relationship.

    2783.pastedimage1675393671300v1.png

    So you can create another custom field on the Quote Product Table, then try to get value from Product Table to populate the new custom field automatically.

    Please refer to the following link to use calculated field to get value from parent entity:

    https://dyn365pros.com/2018/04/18/display-parent-entity-fields-using-calculated-fields-in-dynamics-365/ 

    Or you can use worklfow/flow to populate field automatically if you don't want to use calculated field.

  • Leah Ju Profile Picture
    Microsoft Employee on at

    Hi,

    Have any updates?

    Please feel free to contact me if you have any questions!

  • HugoS Profile Picture
    10 on at

    Hi Leah,

    Yes your post resolved my issue, will mark it as verified (if I can figure out how)!

    Thank you for your help!

  • Suggested answer
    HugoS Profile Picture
    10 on at

    Thank you for your help, this is the answer I was looking for

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 156

#2
ManoVerse Profile Picture

ManoVerse 153 Super User 2026 Season 1

#3
Zhilan Profile Picture

Zhilan 49

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans