Thursday, September 11, 2014

Management Reporter - The report has a reference to a dimension called % but this dimension is not available to company %

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.

6 comments:

  1. This was very, very helpful. Thanks!

    ReplyDelete
  2. Helpful, thanks. However, I still received report failures until I logged out of MR and back in (even though I had refreshed cached financial data).

    ReplyDelete
  3. Interesting - thanks for letting folks know that additional steps may be necessary.

    ReplyDelete
  4. Glad to find this, defined what the issue was for my client.

    ReplyDelete
  5. Thank you! Thank you! I missed "Management Reporter went to Tools > Refreshed Cached Financial Data"

    ReplyDelete