Converting a Forecast item to On-the-Fly

You can convert Forecast items that have been created using the Forecast Formula or Monthly Growth methods to On-the-Fly using the Convert to On-the-Fly option. This allows you to quickly create forecasts using any forecasting method and then convert the results to On-the-Fly in order to easily make adjustments. Please note, converting to On-the-Fly is permanent and cannot be undone.

Written by Ross MacLeod

About

You can convert Forecast items that have been created using the Forecast Formula or Monthly Growth methods to On-the-Fly using the Convert to On-the-Fly option. This allows you to quickly create Forecasts using any forecasting method and then convert the results to On-the-Fly in order to easily make adjustments. Please note, converting to On-the-Fly is permanent and cannot be undone.

How to convert Forecast items to On-the-Fly

Navigating to the line you wish to convert

In our example below, we’ve used the Formula Forecast method to forecast our Cost of Sales as 30% of our Sales. We now want to convert this item to On-the-Fly in order to factor in some of the deviations from this general trend we expect to see. To do so, we first need to navigate to where our Forecast item appears in our Chart of Accounts on the Workings Tab:

Screen Shot 2017-01-17 at 15.08.00

Toggling additional options

We can select the Convert to On-the-Fly option by clicking the Cog adjacent to the Forecast item in question. This will reveal additional options for the Forecast item. From these select Convert to On-the-Fly:

Screen Shot 2017-01-17 at 15.10.57

Previewing the Results

After selecting Convert to On-the-Fly, a preview of the values which will be stored against each month will be displayed. These can be edited or altered as you wish:

Screen Shot 2017-01-17 at 15.12.36

Saving your Changes

Once happy, simply select the Save Changes button to save your changes. Remember, this change will be permanent and cannot be undone:

Save Changes