Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Convert Opportunity to Quote

Posted on by Microsoft Employee

Does anyone know if it is possible to convert a opportunity (won) into a quote without using code?

*This post is locked for comments

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Convert Opportunity to Quote

    if I get a chance to get around to checking that, I will report back.  (in the mean time I just let my price calculation recompute those values every time)

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Convert Opportunity to Quote

    I would enable auditing and see what fields are getting value set On Create.   The Audit History would confirm for sure if the values are being set at all or if they are overridden or cleared by any other process. Even if the platform modules like CS/Sales Hub changes this, you should be able to see in the history anyway.

    it might also be worth enabling plugin trace to see whats being triggered and see if there is any step thats you do not expect to be there.

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Convert Opportunity to Quote

    Genius, I say, genius!

    So, back to the main topic.  I have verified mappings for both Oppty=>Quote and Opptyproduct=>Quotedetail.  However, several fields don't migrate.

    Quote: {totallineitemamount, totalamountlessfreight, totalamount, discountamount}

    Quotedetail: {baseamount, volumediscountamount, extendedamount} -- I would say the Money fields but that priceperunit makes it over.

    Again, I have the autopricing feature turned off and I'm the only one who has created any plugins for this org.  So, no process should be touching them.  UNLESS there is something in one of the "extension" apps -- Customer Service, Customer Service Hub, Sales and Sales Hub.

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Convert Opportunity to Quote

    Hi

    Run the following query in FetchXML builder plugin on XrmToolBox to get the mapping id

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
    <entity name="entitymap" >
    <attribute name="entitymapid" />
    <filter type="and" >
    <condition attribute="sourceentityname" operator="eq" value="opportunityproduct" />
    <condition attribute="targetentityname" operator="eq" value="quotedetail" />
    </filter>
    </entity>
    </fetch>

    0844.ScreenClip-_5B00_75_5D00_.png

    From the results, copy the mapping id and replace the the mappingid placeholder in the the URL below and also set the URL of your ORG.

    https://[CRM Org URL ]/Tools/SystemCustomization/Relationships/Mappings/mappingList.aspx?mappingId=[mappingid]

    Once you built the url, you will get a page like the following

    0844.ScreenClip-_5B00_75_5D00_.png

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Convert Opportunity to Quote

    Yes.  I got no results so I dropped the $select and scanned all of them.  There are 50 entries and none of them are for oProduct/oqDetail.

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Convert Opportunity to Quote

    Hi

    As explained in the links, you will be building the URL to open only the mapping between oProduct and qProduct. Once you got the URL, it will  should display all the mapping between the two.

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Convert Opportunity to Quote

    what if there's 50 entries and none of them are for salesorderdetail, quotedetail or opportunityproduct?

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Convert Opportunity to Quote

    Hi

    Please refer to the link below if you would like to check or update  OProduct to qProduct mapping which is not exposed by default

    www.inogic.com/.../add-mapping-for-custom-attribute-of-order-product-to-invoice-product

    crmconsultancy.wordpress.com/.../productcataloguemapping-mscrm-fields-from-opportunity-product-to-quote-product

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Convert Opportunity to Quote

    In 365 all you have to do is mash the + sign on the opportunity Quotes grid to get a populated quote.  But why doesn't it move all columns from oProduct to qProduct?  I have system pricing turned off and I expect the Extended Amount to copy and it doesn't.  Is there a mapping somewhere I can configure or is this something I have to accomplish in my custom pricing code?

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: Convert Opportunity to Quote

    There are many ways this can be achieved. One of them is using an on-demand workflow to transfer the desired data from the Opportunity to the Quote.

    If you are also looking to transport the products from the Opportunity to the Quote, there is at least one tool that will allow you to copy them over in the same Workflow

    github.com/.../wiki

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans