function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Saloni KhedkarSaloni Khedkar 

Data entry of each change in opportunity

Hi all,

I wanted to know where will i get detailed data of the opportunities?
For example, there is a change in the stage for that opportunity from stage 1 to stage 2 and so on till Closed won. How to get the data for each stage it passed through. A detailed report of the overall activity done on that opportunity.

Thanks in advance
Danish HodaDanish Hoda
You can check the Stage field in Field-History Tracking on Opportunity object, this will show you a detailed journey of that field in the related list.
Khan AnasKhan Anas (Salesforce Developers) 
Hi Saloni,

Greetings to you!

Field History lets you track the changes made to an opportunity, including changes to the stage, so you can quickly see who changed the opportunity and when.

There are two related lists that track changes to the fields on an opportunity record.

Opportunity Field History
Any time a user modifies any of the standard or custom opportunity fields that are set to be tracked, a new entry is added to the Opportunity Field History related list. All entries include details of the change and who made it. Your administrator can choose which fields to track.

Stage History
Any time a user changes the Amount, Probability, Stage, or Close Date fields, a new entry is added to the Stage History related list. All entries include details of the change and who made it. Your administrator can’t choose which fields to track.

You can also check the Opportunity History Report:
View information about the history of your opportunities, including stages and close date.

Please refer to the below links which might help you further with the above requirement.

http://merfantz.com/blog/how-to-create-report-for-opportunity-field-history-changes-details-in-salesforce/

https://chartio.com/learn/marketing-analytics/stage-duration-report-salesforce/

https://www.simplysfdc.com/2013/07/salesforce-opportunity-history-stage.html

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas