So, I was working with a client today, who had recently undergone training on Management Reporter. During this training the client and I built a Balance Sheet and Income Statement for their main entity. The client's homework was to do the Balance Sheet and Income Statement for a smaller entity on her own. Logically, the client copied components from the main entity, which uses the same Chart of Accounts with minor variations. Here's where things went off the rails.
When the client tried to validate the report, she ran it, and received the following error:
The report has a reference to a dimension called Natural Acct but this dimension is not available to company HXXX.
I have seen problems with Dynamics SL making the transition from Legacy to Data-mart configuration throwing an eerily similar error, though not identical. I have never seen this kind of problem with Dynamics GP.
So, I went into Dynamics GP Setup > Company > Account format for both companies and validated they matched - or so I thought...
Turns out the formats differed ever so slighting in that in the main company database, the Main Account segment was named Natural Acct, and in the other database it was simply Natural. We changed the segment descriptions to match exactly. Then in Management Reporter went to Tools > Refreshed Cached Financial Data. Viola - the report worked.
Be aware, if you are going to use Management Reporter to produce Consolidated financial statements, you want to make sure your companies' Account Formats MATCH exactly, not just constructively.