Reports

hi haritha raghavan 

The advanced report method is explained here:

https://support.sugarcrm.com/knowledge_base/reports/reporting_on_records_change_log_via_advanced_reports/

or you can create the BPM method as explained here:

https://support.sugarcrm.com/knowledge_base/sugarbpm/capturing_how_long_a_record_spends_in_each_status_using_sugarbpm/

Thank you. I've created both But I was wondering if I can create a custom query where there can be custom field created to show the date when the opp came to a stage and when it left the stage? 

Thank you. I've created both But I was wondering if I can create a custom query where there can be custom field created to show the date when the opp came to a stage and when it left the stage? 

In Sell Premier, there are enhanced forecasting reports (documentation here) that keep track of how long every opportunity stays in each sales stage for you. The link I shared shows the average days opportunities are spending in that sales stage each month, but it can certainly be adjusted to show a table that displays, for example, the opportunity, the date it transitions, and the sales stage it goes from and to. 

If you are interested in learning more about this capability, reach out to your CSM or post a reply here and I'll try to help more! I'm the product manager for these reports and the technology underlying it, so I'd love to work with you to find something that works!