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 can we track changes on an opportunity?

(0) ShareShare
ReportReport
Posted on by 202

Hello,

we're having some issues with tracking changes on an opportunity. Usually the field "Changed on" displays the last time changes on an opportunity are made. The problem is, that attached activities do not affect that field. So we can not check if the opportunities are being worked on or not. 

Basically, we need a way to record times when activities are linked so we know that the opportunity is actively being worked on.

Thanks for your help!

Kind regards,
Maurice Renz

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    if you refer to the activities : Phone call, task , appointment and etc

    you can create a field in opportunity as date time, and trigger the workflow to update the field when activity is created.

  • Ruben Raposo Profile Picture
    60 on at

    Hi Maurice,

    We had a similar requirement.

    On our case the customer want's to know the last time that the sales guy interacted with the customer regarding the opportunity or vice-versa.

    To achieve that, we've created a new datetime field on the Opportunity, then we've created a Workflow, e.g. regarding the email entity where we keep the "Created On" value and put it on field created on the Opportunity.

    Please mark if this answer helps. :) 

    BR

    Rúben Raposo

  • Suggested answer
    gdas Profile Picture
    50,091 Moderator on at

    Hi Maurice ,

    I think the best way if you write a plugin which will trigger when you associate any activity or when any changes happen means update of plugin and set the Changed On datetime value.

    Hope this helps.

  • maurice.renz Profile Picture
    202 on at

    Hello,

    thanks for your replies. I already thought of a workflow but I'm kind of new to workflows. Do you have an example of a workflow that could help me with my task?

    Thank you very much.

    Kind regards,

    Maurice

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    below is my demo 

    Account and phone call

    I created a new field

    5282.8.png

    Create a workflow

    4265.2.png

    2063.3.png

    1050.4.png

    you see the field is updated.

    5852.5.png

    but if you create phone call via social panel

    64816.6.png

    2112.7.png

    nothing is updated, because the phonecall is completed as soon as you created.

    so , add one more check.

    5282.8.png

    3644.9.png

    6724.10.png

    Conclusion

    - the record's modfiedon is updated too. 

    - it is not necessary to create a custom field, you can update any unused field in opportunity .

  • maurice.renz Profile Picture
    202 on at

    Hello Wei Jie Fun,

    thank you very much! That was working. Is there also a possibility to modify the workflow, that I can also update the field, when the attached activity gets modified?

    Kind regards,

    Maurice

  • Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    you means when attach something into notes?

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