Question Status

Verified
abessen asked a question on 5 Feb 2014 9:01 AM

I have a client who was using Account Categories in FRX and would still like to use them with MR.  However, some of the Account Categories (e.g. Property, Plant, Equipment) show as an error when added to a row definition, even though there are accounts with this account category.  The report then shows no data for that row.  Has anyone else come accross this?  Also, the client would like to have one line called net income, but their GL COA isn't seqeuential, and they have unit accounts mixed in.  Any suggestions on howt o handle this?  Thanks!

Reply
Ian Stewart responded on 14 Feb 2014 3:13 PM

Hi - there was a change in how account categories are used in MR. In FRx the category number was used, in MR its the category description. Was this a migration from FRx? If so, account Category dimensions don't migrate. you will need to re-do those reports that previously used category values.

To get one line for revenue - you either need to add each account individually to the dimension set, or use account categories - and restrict that line on the report to where account category = 'XXXXX' [Sales?]

Ian.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Verified Answer
abessen responded on 18 Feb 2014 2:29 PM

Thanks Ian.  It turns out that there were 2 issues here.  One is that account categories was a known bug that was fixed in Management Reporter RU8.  Additionally, the client had an & in some categories (e.g. Property Plant & Equipment).  By changing any categories with an & and moving to the latest version, the issue was resolved.

Reply
Richard Wheeler responded on 26 Mar 2014 4:41 AM

When you say there was a know bug with account categories that was fixed in RU8 what was the bug and how was it fixed? We are using RU8 and none of our reports correctly migrated so we have a least a week's worth of week correcting all of these very sophisticated reports. We will continue to run the FRx version of these reports until they are all corrected.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
abessen responded on 26 Mar 2014 10:21 AM

According to Microsoft, the fix in MR version 8 was to migrate over the categories.  However, I found that I still had to rewrite the reports to utilize the categories.  It didn't cleanly migrate over.

Reply
Verified Answer
abessen responded on 18 Feb 2014 2:29 PM

Thanks Ian.  It turns out that there were 2 issues here.  One is that account categories was a known bug that was fixed in Management Reporter RU8.  Additionally, the client had an & in some categories (e.g. Property Plant & Equipment).  By changing any categories with an & and moving to the latest version, the issue was resolved.

Reply