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.

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 set up a schedule for creating revenue forecasts:

  1. Do one of the following:
    • From the Revenue Forecast Setup tab, open the active revenue forecast setup record. If one does not already exist, you must create one.
    • From the PSA Administration tab, scroll down to the Revenue Forecasting section.
  2. Click Schedule Forecast.
  3. Enter a name for the scheduled job. This name must be unique.
  4. Select the batch job frequency. The options are:
    • Weekly: Select the day or days of the week.
    • Monthly: Specify the day of the month, 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.
  5. Enter a start time for the job. We recommend you set this to a time outside business hours. The job uses your time zone.
  6. [Optional] Select Filter by Region, Practice, or Group, then search for and select the relevant RPGClosed Abbreviation of region, practice, group. if you want the scheduled job to only include projects and opportunities matching a selected RPG. Projects or opportunities with an RPG that is below the selected one in the RPG hierarchy are also included. If you do not select this option, all valid projects and opportunities are included when the scheduled job is run. For more information on what is a valid project or opportunity, see Prerequisites.
  7. Click Create Scheduled Job.
Note:

If you subsequently create a new active revenue forecast setup record, you do not need to reschedule the batch job.

To view or delete the RevenueForecastScheduler job, from Setup, enter Jobs in the Quick Find box and 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, go 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.