
I have a company that has been running Management Reporter with several companies they recently added a new company, and now we are getting some interesting results with our reports.
The consolidated profit and loss report will not show the new company, yet we can run a report for the profit and loss for just that company no problems. The interesting thing is I changed the default company to the new company (so logged into report designer as the new company) copied the row layout, and pasted it into a new report. Did the same with the reporting Tree. Ran the report (so would expect to see all the companies as the reporting tree is selecting all companies..) But the report only will show the new company. Changed the row and tree back to the original (that is the only change we are making. no changes to the options of the report at all) and.. now you will see all the companies except the new company.
*This post is locked for comments
I have the same question (0)If you make a tree for just the new company and re-run the report with that tree, does it work? If so, I would then copy those settings into the consolidated tree - after backing it up! - to see if there might have been something wrong - for example, the company ID column, that was not work.
(If the new one-entity tree doesn't work, something else is going on and it will most likely require diving into the MR data tables. I only work with Data Mart so I'm not familiar with any Legacy nuances.)