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 number the second record as per above.