I am creating a consolidated income statement. The problem is that company ABC and XYZ have a few accounts numbers that are the same but fall in different account groups. (Account 60100-00). In company ABC this account represents Sales and in XYZ this account represents Payroll Expense.
Even if I have multiple columns with the Chart of accounts for each company, the company XYZ is pulling the payroll expense number for the sales account for ABC company rather than the Payroll Expense for XYZ.
Are you creating it using Report Designer Add-In or just normal Excel?
Either case, you should be able to retrieve the value base on Account Group as long as the Account Group have the same name.
Hi. Thanks for your help. Problem solved. I didn't realize that I needed to identify the company within the GL formula.