Issue:

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"




Solution:

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 - 1.


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