locked
Stored procedure that will set Opportunity status to CLOSE-WON RRS feed

  • Question

  • Hi,

    I would like ask help on how to create a stored procedure that will set opportunity status to CLOSE-WON based on the following conditions. If there is a related invoice record and Estimated Revenue amount is 0.

    Appreciate any prompt response. Thank you in advance.

    Regards,

    Honey

    Wednesday, February 19, 2014 7:31 AM

All replies

  • Hi

    Did you try to implement your scenario in CRM workflow feature (Under process group) ?

    It is possible to create stored procedures, but microsoft does not categorize them as supported.

    If OOB workflow does not meet your need, I will suggest, writing a Custom Workflow Activity or a Plugin, whichever suits your need better.

    Thanks

    • Proposed as answer by Kiran Madhav Wednesday, February 19, 2014 9:48 AM
    Wednesday, February 19, 2014 8:24 AM
  • Hi,

    I have written a Plug-in for this already, unfortunately it doesn't work. I will try creating CRM workflow. Thanks for the recommendation. I'll get back to you after testing. :)

    Thank you so much!

    Regards,

    Honey

    Wednesday, February 19, 2014 8:51 AM