Dynamics Community Forum Thread Details

I am trying to create a report that consolidates expenses by restaurant where expenses are reported in two GP companies. Payroll is processed in one company, and Sales and A/P are processed in the other company.

The companies use the same chart of accounts. The third segment is what identifies each restaurant.

I have created a reporting tree that looks like this:

The report will not consolidate. When you click on Food and Beverage Admin it only includes the $$ from whichever company you have set as the default company in MR. The Children lines display the correct $$. It just doesn't consolidate correctly. Does anyone have any recommendations please?