Consolidated Budget from Multiple GP Companies in Management Reporter

(0) Share

Report

Posted on by Community Member

I have been tasked with creating a consolidated income statement actual to budget. However, when looking through the book code in the column section, only the budgets from our parent company show, not the subsidiary. The parent company and subsidiary company are separate companies in GP.

Does anybody know how to add budgets from separate GP companies in Management Reporter.

My backup option is to upload the subsidiary budget as an external worksheet. I would prefer not to use this method since the subsidiary budget has been uploaded into GP.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

MattPaulen 6,912 on at

Like (0)

Report
Copy link

Link copied!

You'll only see the Budget ID's from the company you are currently logged in to in Management Reporter (Company ID shown at the bottom of the application). Ideally, you'd want to name your budget ID's the same in all companies. That way if you select BUDGET2016 in the one company and then you run a report with a tree, the budget ID will be picked up for all units of the tree.

Was this reply helpful? Yes No
Verified answer

Ian Grieve 22,784 on at

Like (0)

Report
Copy link

Link copied!

Matt's answer is sport on; the lookups are only against the default company so you can't do a look up for budgets in the other companies.

You can type the names in directly (you'll get warnings that you can ignore if the budget doesn't exist with the same name in the default company.

It is better if possible to keep budgets with the same name in all databases (e.g. 2017MASTER in all databases instead of 2017MAIN and 2017SUBSIDIARY)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help guys, very appreciated.

Was this reply helpful? Yes No