There are two options to make the report work correctly. These options are found in the report definition, on the Settings tab. Click Other and then click the Additional Options tab.
NoteThe default company is considered the company that is specified in the report definition. If @ANY is used, then the default company is the company that you are currently logged into.
Option 1
“Rollup by using default company period number”
The period that is specified in the column definition is used for all companies that are defined in the tree.
For example, 6/30/2012 is Period 12 for the default company and is Period 6 for the second company. If the report was run for period 12, the default company would pull data from June, whereas the second company would pull data from December.
In order to retrieve data for June for both companies, you would have to set one column to period 12 and a second column to period 6. Each column would then have to be restricted to its respective company in the tree, by using the Reporting Unit.
This option is the default setting.
Option 2
“Rollup by using default company period end date”
The period that is specified in the column definition is used to find the date from default company.
If the default company’s Period 12 has end date of 6/30/2012 then this date will be used against all companies regardless of period numbers. Using this example, the second company would pull data from period 6.