Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / How can we bring a col...
Sales forum
Answered

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

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,

  • Suggested answer
    HugoS Profile Picture
    HugoS 10 on at
    RE: How can we bring a column from Product Table to Quote Product Table?

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

  • HugoS Profile Picture
    HugoS 10 on at
    RE: How can we bring a column from Product Table to Quote Product Table?

    Hi Leah,

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

    Thank you for your help!

  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How can we bring a column from Product Table to Quote Product Table?

    Hi,

    Have any updates?

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

  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How can we bring a column from Product Table to Quote Product Table?

    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.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans