Forums - Thread Details
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Subscribers 322 subscribers
  • Views 672 views
  • Users 0 members are here
Forum Actions
Related

Forecast set up

Ada Napierala

Hello, 

I just updated SugarCRM to 12.1 version and now I am trying to set-up Forecasts. 

I understand that the Forecast fields that are the summary of opportunities, so Forecast, Included Pipeline, Excluded Pipeline and so on are pulling from the Total Value field on revenue line item - is that correct?

Is there a way to change it? In our organisation, we are forecasting ARR, not total contract value, so now all numbers are incorrect.

I think an alteration like that will go beyond Forecast Configuration, I was not able to find anything on what I want to do here: support.sugarcrm.com/.../

Best, 

Ada

  • 0

    Hi Ada,

    Great question! 

    The metric tabs on the 12.1 forecasting page sum fields from the Opportunities module - "Likely", "Forecasted Likely", and "Lost". Those Opportunity fields are rollup conditional sums from the revenue line items' "Likely" and "Forecasted Likely" fields. 

    I'd recommend using studio to adjust these calculations so that you can forecast on ARR rather than total contract value. For example, you could add a "Likely ARR" field to revenue line items which divides Likely by the line item's duration in years, then change the Opportunity's Likely field calculation to sum Likely ARR from the line items. Doing the same for "Forecasted Likely" should then make the metric tabs display ARR values.

    I hope that's helpful!

    Ellen

  • 0 in reply to Ellen True

    Hi Ellen!

    Thank you for your reply :) 

    Do you know which fields on Forecast match fields from Opportunity / Revenue Line Item?

    Is it:

    Forecast = Likely (?)

    Included Pipeline = Likely (?) + filtered depending on our ranges

    Excluded Pipeline =  Likely (?) + filtered depending on our ranges

    What's the difference between Likely and Forecasted Likely?

    Best, 

    Ada