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.

Any solutions?

Views: 125

Replies to This Discussion


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.

Thanks again.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service