Setting up a forecast includes the following general steps:
1.Creating a forecast. At this step, you select the forecast entity and period, as well as group the data. Read more >>>
2.Setting up columns. Read more >>>
3.Adding data for calculation. Read more >>>
4.Setting up permissions. Read more >>>
Let’s have a look at how to set up a forecast for product bank sales. Forecast parameters are as follows:
-
Forecast entity: Product.
-
Grouping of data: by category, type, and brand.
-
Forecast period: Quarter.
-
The calculation must be based on paid invoices.
-
Sales managers and their owners should have access to the forecast.
1.In the [Sales] workplace, open the [Forecasts] section.
2.In the top left corner of the workspace, click 
.
3.In the opened window:
a.Enter the name of the new forecast. In our case, it is “By products.”
b.Select the period. In our case, it is “Quarter.”
c.Specify the forecast entity. In our case, it is “Products.”
d.Set up the hierarchy – specify the fields, whose values will be used to group the data in the forecast. In our example, these are “Category,” “Type,” and “Brand” (Fig. 1). You can modify the hierarchy later, if necessary.
Fig. 1 Setting up the forecast hierarchy
4.Save the new forecast.
Note
Some of the parameters, including the period type and forecast entity cannot be modified. To edit the forecast name and hierarchy, click 
on the forecast tab panel.
Setting up the forecast columns
Add two columns to each period: [Actual] and [Actual, %].
To set up the [Actual] column:
1.Click 
to the right of the [Expected] column.
2.In the opened window, specify the name of the new column (“Actual”) and its type (“Value from object”). The window will display a list of column parameters.
3.Populate the column parameters.
•[Section] – Creatio object that has the needed data. In our case, it is “Product in invoice.” Apply filters that would consider only the paid or partially paid invoices within the specified time when calculating the actual forecast data.
•[Function] – method of calculation. The function can be “sum,” “count,” or “average.” For this case, select “sum.”
•[Indicator] – the value that is the base for calculation. In our case, it is “Total, base currency.”
•[Forecast object binding] – a field that connects the data object (“Product in invoice”) and the forecast entity (“Product”). In our case, this is the “Product” field.
4.Click [Save].
Fig. 2 Example of setting up a column of the “Value from object” type
To set up the [Actual, %] column:
1.Click 
to the right of the [Actual] column.
2.In the opened window, specify the name of the new column (“Actual, %”) and its type (“Formula”). The window will display a field for entering the formula, available columns, and mathematical operations.
3.Set up the formula that will calculate the column value (Fig. 3).
4.Click [Save].
Fig. 3 Example of setting up a column of the “Formula” type
Note
Drag&drop the forecast columns to change their order.
To add forecast data:
1.On the forecast tab, click [Add].
2.In the opened window, select the needed records of the forecast entity. In our case, you will be selecting from the list of products. To add all available records to the forecast, click [Actions] –> [Select all].
3.Click [Select].
As a result, the list of selected records will appear on the left panel of the forecast. The records in the list will be grouped as per the pre-configured hierarchy (Fig. 4).
Fig. 4 Example of configuring a list of forecast records
To remove a specific record from the forecast, hover the mouse pointer over the record and click 
.
You can set up permissions for forecasts and separate records within them.
Setting up permissions for a forecast
To enable only bank sales managers and their superiors to access the configured forecast, assign the access permissions for the forecast tab. To set up access permissions:
1.Go to the [Forecasts] section and open the needed forecast tab.
2.Click 
–> [Set up access rights].
3.On the opened page, set access permissions to the created forecast.
a.Click [New] and select the “Read access right” option in the menu. In the opened window, select the “Sales managers” role.
b.Similarly, set the read, edit, and delete permissions for the superiors of the bank sales managers.
4.Save the changes. As a result, the forecast will be available only for bank sales department employees.
Setting up permissions for a forecast record
You can manage permissions to separate records in a forecast. For example, you can restrict specific employees from viewing or modifying forecasts for specific products or customers, giving exclusive access to specific types of employees, e.g., executives. To do this:
1.Go to the [Forecasts] section and open the needed forecast tab.
2.Select the record, whose permissions you need to set up.
3.Hover your cursor over the record and click 
(Fig. 5).
Fig. 5 Example of selecting a record to configure access permissions
4.On the page that opens, click [New] and select “Read access right”, “Edit access right”, or “Delete access right” in the drop-down menu (Fig. 6). Read more about the types of permissions in the “Managing object operation permissions” article.
Fig. 6 Example of setting up record access permissions
5.In the opened window, select the “Sales Department Managers group” role. You can also enable permissions to this record for separate users.
6.Click [Save]. As a result, only the the employees of the selected role (e.g., Sales Department Managers) will be able to view, edit, or delete the forecast record.
Calculating the forecast metrics
In the [Forecasts] section, the calculation of the actual metrics is triggered by the [Recalculate forecast columns] action (Fig. 7).
Fig. 7 Running the recalculation of forecast metrics
Click [Actions] -> [Recalculate forecast columns] to update the numbers of the currently open forecast. After the calculation is finished, you will receive a notification on the communication panel. As a result, the calculated forecast metrics – in our case these are the [Actual] and [Actual, %] columns – will be populated with values derived from the system and calculated using the specified formula.
Next
