Scheduling Revenue Forecasts

Revenue Forecasting enables you to run forecasts on demand or schedule them to run at set intervals, such as daily. These forecasts use snapshots of live data in your org to provide you with up-to-date information.

Tip:

To run a forecast on demand, click Recalculate Revenue Forecast on the Services Revenue Forecasting workspace. For more information, see Services Revenue Forecasting Workspace.

Prerequisites

You can only schedule Revenue Forecasting on the following projects and opportunities:

  • Active projects that have a start date and an end date and the Include In Forecasting checkbox selected.
  • Opportunities that do not have an active project associated with them, do not have a type of Closed/Lost in the Stage field, and have the Is Services Opportunity checkbox selected.
Note:

To be included in a revenue forecast schedule, a project must be active. Inactive projects are, however, included in revenue forecasts that are run manually. For more information on running a forecast manually, see Running Project Revenue Forecasts.

Setup

To exclude opportunities from revenue forecast scheduled jobs, select Exclude Opportunities under Forecast Batch Settings on the active revenue forecast setup record.

To exclude opportunity probability from revenue forecast scheduled jobs, select Exclude Probability on Opportunities under Opportunity Settings on the active revenue forecast setup record.

For more information on the settings available for running and scheduling revenue forecasts, see Revenue Forecast Setup Fields and "Scheduling Revenue Forecasts" in Setting up Forecasting.

Permissions

To set or change the settings on the revenue forecast setup record, you must have been granted permission to configure the setup.

To schedule a revenue forecast, you must have been granted the following:

  • Salesforce permission to schedule an Apex job
  • Permission to run a revenue forecast

For more information, see Revenue Forecasting Permissions.

Scheduling a Revenue Forecast

To schedule a revenue forecast:

  1. From Setup, enter Apex in the Quick Find box, then select Apex Classes.
  2. Click Schedule Apex.
  3. Enter a job name, such as "Revenue Forecast"
  4. Use the lookup to search for and select the RevenueForecastScheduler Apex class.
  5. Choose the frequency at which you want to schedule the revenue forecast. The options are:
    • Weekly: Pick the day (or days) of the week.
    • Monthly: Specify the day of the month you want the job to run, either as a fixed date such as day 17 of every month, or as a relative date such as the third Tuesday of every month.
      If you specify a fixed date, select Run on Nearest Weekday if you want calculations that fall on a Saturday or Sunday to be scheduled for the next working day (the following Monday).
      If you specify a relative date of First, Second, Third or Fourth Weekday and the first, second, third or fourth day of the month falls on a Saturday or Sunday, the forecast calculation job will be automatically scheduled for the next working day (the following Monday).
  6. Enter a start and end date for the scheduled job.
  7. Enter your preferred start time for the scheduled job.
  8. Click Save.

To view or delete the RevenueForecastScheduler job, from Setup, enter Jobs in the Quick Find box, then select Scheduled Jobs.

Troubleshooting

To find out whether any projects or opportunities in a scheduled job have failed:

  • For projects, create a list view on the Project tab that includes the Revenue Forecast Processing Status field. For information on creating a list view, see the Salesforce Help.
  • For opportunities, create a tab for the Revenue Forecast Batch Status object, then create a list view on the tab that includes the Revenue Forecast Processing Status field. For information on creating a custom object tab, see the Salesforce Help. For information on the Revenue Forecast Batch Status object, see Revenue Forecast Batch Status Fields.

You can then sort the entries in the Revenue Forecast Processing Status column on the list view to make it easy to identify projects or opportunities with Error in that field.

To view details of an error, navigate to the relevant project or opportunity and check the Revenue Forecast Batch Logs related list.

Tip:

The RFP_EnqueuerBatch and the RFO_EnqueuerBatch scheduled jobs find suitable projects and opportunities and mark them as Pending for Revenue Forecasting. If your scheduled jobs are failing, an administrator can reduce the batch size by changing the value in the Project Scheduler Batch Size and Opportunity Scheduler Batch Size fields on the active revenue forecast setup record. For more information, see Revenue Forecast Setup Fields.