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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How data reflects from opportunity product to quote product in MSCRM 2016.

(0) ShareShare
ReportReport
Posted on by 6

Hello All.

1. How the subgrid of products on the opportunity form reflects the same data on the subgrid of products on quote entity.

2. what is relationship between these two.

3. how to achieve , if  i want to add custom fields on subgrid of products on opportunity form and which will reflect on the quote form.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello again,

    I'm sorry but I'm not sure why previous thread is not closed yet and you are asking the same question - community.dynamics.com/.../207721

    I will answer again:

    1. Subgrid of products in opportunity form doesn't reflect the same data - quote details on quote entity form.

    2. I already provided article that describes how to find mentioned relationship - dynamicslollipops.blogspot.com.au/.../mscrm-2011-mapping-opportunity-product.html

    3. To add custom fields you have to add mentioned fields to both opportunityproduct and quotedetail entities and then using approach from article mentioned in previous step - configure mapping between entities.

  • EmployeeOcta Profile Picture
    6 on at

    Hello Andrii,

    I was not able to type anything in previous thread , it was showing some error there.

    so i have made new thread.

    As per the link you provided i didn't find anything called as oportunityproduct or quotedetail , when i have hit the rest service url in the browser (XRMServices/2011/OrganizationData.svc/EntityMapSet() )

    The url is displaying the data but as mentioned in the thread it's not showing the entities as mentioned by you.

    i tried to search with the name

    1.OpportunityLine

    2.Quoteline

    as the quoteline and opportunityline are the entities for quote and opportunity subgrid respectively.

    is there any easiest way to achieve the functionality.

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    I believe you have issues because you were looking for wrong entities. Exact names are opportunity product and quotedetail.

    I opened one of current organizations I am working with and... I was able to find what I needed during one minute. Here are screenshots:

    3343.Mapping2.png

    From this part I took mapping id - f6d0d464-e91e-e411-80b5-00155d012802

    After that I created url like following:

    http[s]://server/tools/systemcustomization/relationships/mappings/mappingList.aspx?mappingId=<Mapping Id found on previous step>

    Once I entered created url to browser I was able to work on mapping:

    3343.Mapping2.png

    So it worked for me and that means it should work for you. What kind of issues do you have?

  • EmployeeOcta Profile Picture
    6 on at

    i am using MSCRM online 2016.

    i have not find anything called quotedetail or opportunityproduct.

    which version you are using.

  • a33ik Profile Picture
    84,331 Most Valuable Professional on at

    It works for both online and on-premise. That means that you are looking in wrong place. It could be that your online doesn't contain mentioned entities.

  • EmployeeOcta Profile Picture
    6 on at

    If MSCMR 2016 online doesn't contain these entities then what will be th ealternate for this.

  • a33ik Profile Picture
    84,331 Most Valuable Professional on at

    It just can't be because it just can't be.

    Please provide a screenshot of list of entities from Default Solution.

  • EmployeeOcta Profile Picture
    6 on at

    [quote user="Andrii Butenko"]

    It just can't be because it just can't be.

    Please provide a screenshot of list of entities from Default Solution.

    [/quote]

    EntityList.PNG

    This is the snapshot of the default solution for entities.

    It is showing some entities on a single page out of 209 entities total.

  • a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Please provide a screenshot that shows entities that start from O and Q letters (opportunity and quote).

  • EmployeeOcta Profile Picture
    6 on at

    [quote user="Andrii Butenko"]

    Please provide a screenshot that shows entities that start from O and Q letters (opportunity and quote).

    [/quote]

    OpportunitySecondScreen.PNG

    OpportunitySecondScreen.PNG

    Quotescreenfirst.PNG

    All the entities with O and Q letter.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans