Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Kevin O’Bold]

I have two different databases with separate Chart of Accounts and separate Fiscal Calendars. I have budgets uploaded in Great Plains but don’t know how to fun a Report Definition where I can link multiple budgets between multiple databases/companies in the same report. I keep getting errors that either the fiscal date doesn’t work or the budget I link the column definition to doesn’t exist in that company.

Has anyone had success combining budgets across multiple companies like this in MR?

——————————
Kevin O’Bold
Contoller
Ultra Steak
Fishers IN
——————————

[Steve Erbach]

Hi, Kevin,

Well, “Ultra Steak” get’s my vote for the coolest company name I’ve heard in a month of Sundays!

I can only suggest reading the blog series “Creating Consolidated Financial Statements using Management Reporter” by April Olson of Microsoft for a start. I’ve linked to each of seven parts. The navigation within the MSDN blog site appears busted:

• Part 1 – Consolidating data across one or multiple Dynamics ERPs with the same chart of accounts and same fiscal periods
• Part 2 – Consolidating data across one or multiple Dynamics ERPs with different chart of accounts
• Part 3 – Consolidating data across one or multiple Dynamics ERPs with different fiscal periods
• Part 4 – Consolidating with multiple Dynamics AX 2009 instances (AOS)
• Part 5 – Consolidating with data in a non-Dynamics ERP
• Part 6 – using Management Reporter for eliminations
• Part 7 – owning less than 100% of a subsidiary

I personally have not had to do any cosoliidation reporting in MR since all of our corporate entities (dozens of them) are set up as, essentially, different departments under one company.

Good luck!

Sincerely,

——————————
“Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
WOW Logistics – Appleton, WI
+-VP for Communication, GPUG WI (Milwaukee) Chapter
| Co-Chair, GPUG WI (Green Bay) Chapter
| GP 2013 R2 (12.00.1801)…go-live on GP 2016: 19-Dec-2016!
+-MR 2012 CU15 (found — and reported — my very own bug!)
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: @serbach
————————————————————————-

[Noah Moseley]

Hey Kevin.

You will need a reporting tree pulling from the two companies. In the column definition, you will have a separate column for the two companies if they have different budget book code names. Relate each column to the reporting tree and their part of the tree. Your row definition may have column J and column K if your chart of accounts are different. It does sound very tricky, but it is doable. Email me if you need help beyond this. I’ve been doing MR work since I was with Microsoft on the Management Reporter consulting team.

noah.moseley@msxgroup.com

——————————
Noah Moseley, Senior Consultant at the MSX Group
Noah.Moseley@MSXGroup.com
Email me if you need training or consulting services for Management Reporter, Forecaster or FRx.

Also, see our new Prospero offering for GP – Your new replacement for Management Reporter and Forecaster – Financial Reporting and Budgeting, all in one application.
http://www.msxgroup.com/ProsperoGP
————————————————————————-