At times, a company only owns a percentage of another company. In this situation, when producing a consolidated report, it is important to only account for the percentage of ownership you own. Management Reporter uses the Rollup % in the Reporting Tree Definition, and setting this up is outlined in this blog post (the last in a series of blogs on consolidations).
In the Reporting Tree Definition, enter the % of ownership in column K, Rollup %, and when the report is generated, that percentage will be used to calculate the consolidated amount. In this example, Contoso only owns 80% of Contoso Denmark. The user can enter 80 in the column, or .8 and 80% will roll up to the consolidated level.
NOTE: You can apply this ownership percentage to any reporting unit, not just at the company level. This is helpful when ownership is at a business unit or division level, not just a legal entity.
At report generation, Contoso Denmark shows its full amount in the report for Contoso Denmark, and only 80% of it is allocated to the consolidated node. In the following example, at the consolidated level for Sales, you can see only 80% shows.
NOTE: For the month of June, Contoso Entertainment did not have any Sales, so Sales only reflects Contoso Denmark in this case.
If you own less than 1% of a company, select “Allow rollup less than 1%” in the Additional Options tab of the Report Settings form, and then the rollup % in the reporting tree will be treated as less than 1%. For example, if the setting is selected, then .8 would .8%, not 80%. Alternatively, you can also enter .008 and leave the setting cleared.
The series of blogs has covered the many different consolidation scenarios that a company faces during the reporting process. From multiple Dynamics ERPs, to different charts of accounts, to ownership percentage, Management Reporter is designed to fit your consolidation reporting needs.