Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Dynamics CRM Online: Quote to SalesOrder clone N:N relation

Posted on by Microsoft Employee

Case 

We have an entity called EANcode which has a N:N relation with Quote and SalesOrder. When a potential customer signs a Quote we will create a Sales Order based on its quote. Is it possible to add the related "EANcodes", which are connected to the quote, to the new Sales Order without programming?

I thought there was a solution in msdyncmrworkflootools with clone childs but I couldn't figure it out.

2018_2D00_03_2D00_01-08_5F00_39_5F00_42_2D00_Contract_5F00_-New-Contract.png

*This post is locked for comments

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hello,

    Here is article that I just wrote that describes case that is pretty similar to yours - butenko.pro/.../copying-of-n-n-related-records-with-no-code-using-uwt

  • a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hello Geert,

    Just keep an eye on my blog (you can subscribe to get updates).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hi Andrew,

    That sounds great! Where can I get an update about your Workflow Toolkit?

    Kind regards,

    Geert

  • Sander Daudey Profile Picture
    Sander Daudey 370 on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hi Andrew, that's great. Using an action will provide a lot of flexibility.

    So it will also work with the CRM out-of-box multiple-to-multiple relationships?

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hello Geert,

    In the next release of my Workflow Toolkit I will have "Distribute Action" step that will allow distribution of actions - the same way as it was possible for On-Demand workflows so you will have possibility to implement your requirement without custom coding. I expect it to be available middle of March.

  • Sander Daudey Profile Picture
    Sander Daudey 370 on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hi Geert,

    No, unfortunately this is not possible using the existing workflow extensions.

    You could also consider creating a new entity to store the EANcode records details for quotes/orders which relates to both quote and Salesorder. This will provide you more options like cloning records or just filling the relationship to the Salesorder on the existing records.

    The downside is usability for entering the EANcodes on the Quote, as your sales people will have to create new records for each EANcode and cannot use the functionality to add multiple EANcodes in one time.

    Cheers, Sander.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hi Sander,

    Thnx for your quick reply. It isn't possible with the msdyncmrWorkflowtools plugin?

    Greetings Geert

  • Sander Daudey Profile Picture
    Sander Daudey 370 on at
    RE: Dynamics CRM Online: Quote to SalesOrder clone N:N relation

    Hi Geert,

    Unfortunately you cannot run workflows on the N:N relationship record. So you cannot use distributed workflows.

    The only way to solve this is custom coding, like a custom workflow activity or plugin.

    BR, Sander Daudey

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