Calculated validation accounts for NetIncome on Income Statement Hierarchies.
I am attempting to create a calculated validation accounts for NetIncome in two Income Statement Hierarchies. When consoidations is run millions of lines are created and consolidations hangs. I would appreciate suggestion on how to validate account balances in different account hierarchies. I'm considering using an offset account for the two the problem is there are 3 different Income Statement Hierarchies. I have attached a view of the three hierarchies.