Share
Report
135Hello! My company went through a re-organization and is now set up with departmental expenses being split between two companies. One of the ways we analyze cost is by comparing cost by department for the last six months. I would like to run a report that pulls the information from one company and then has a column for the new company with a total of both so the comparison can be done. I have written the report and created the tree and it works for the consolidated company but I can't get both companies to print on the same report by department.
My accounts are set up in the rows as natural
My column is restricted to the reporting unit in the tree only on the column that I want to pull from the other company
My tree is set up with a summary for all and then a summary by company with each department rolling up to the company summary:
@ANY SUMMARIZE COS SUMMARIZE COMPANIES
CO1 SUMMARY INCOME STATEMENT
CO1 100 MPT &&&-100-99
CO2 SUMMARY ARAMSO SUMMARY
CO2 100 MPT &&&-100-99
I have googled for days and re-read the manual and can't figure it out, does anyone have any tips? If it can't be done through FRx, how can I get it done?
Thanks for your help,
Leslie
*This post is locked for comments
All responses (
Answers (
