Consolidations: An error has occurred while creating/opening the forecast.

Consolidations: An error has occurred while creating/opening the forecast.


When trying to complete a consolidation, you are receiving the following error:

"An error has occured while creating/opening the forecast. If this is a consolidation, please check that all records are named correctly to avoid duplicate record names in the consolidations"


This is usually caused by records with the same name and a number in both forecasts that are different record types, e.g. Forecast 1 = Sales 1 - Separately Invoiced Income. Forecast 2 = Sales 1 - Income.

To resolve this, rename one of the records to something slightly different, e.g. Sales - A.

The preference would be to remove the numbers from the end of the record name.

While the consolidation will appear to complete, there will be no figures within the consolidation.

Alternative solution*:
Sometimes you may be able to complete a group of consolidations where one may not agree with the rest (e.g. you can consolidation 3 out of the 4 but when you try to consolidate all 4, you get the above error).

You may be able to try the work around below:
1. Consolidate the forecasts that work.
2. Once that has finished calculating, open the consolidation and click Options.

3. This will bring up your forecast selection screen. Select the next forecast you wish to consolidate.
4. Once it has loaded, close the consolidation and reopen.

*This is not a guaranteed process. You will need to ensure the first solution has been rectified.
    • Related Articles

    • Consolidation Rules for Forecast 5

      In order to successfully create a consolidation in Forecast 5, there are some rules and tips to be followed: Rules The forecasts must all have the same start date and number of years. The forecasts must be in the same state e.g. budget, actuals or ...
    • Consolidation: Why are there two records with the same name?

      Question: Why are there two records with the same name in my consolidation? Answer: If you have two records of the same name in two different forecasts but they are different record types, they will not be able to be consolidated and Forecast 5 will ...
    • Forecast 5 Quick Start Guide

      Contents Introduction to Forecast 5 ..................................................................................................................... 3 Creating a new Forecast ...
    • TypeInitializationException: "System.Array.Empty" when opening Forecast 5

      Issue: After an upgrade, you are receiving the following error when opening Forecast 5: TypeInitializationException The type initializer for 'Forecast5.Model.Node' threw an exception. TargetInvocationException Exception has been thrown by the target ...
    • TypeInitializationException: A network-related or instance-specific error... [Error: 26]

      Issue: You receive the following error when trying to login to Forecast 5. Forecast 5 cannot continue because of an exception occurred. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Cause: This error indicates that ...