Tuesday, July 2, 2013

Management Reporter- Subtracting Segments in Trees Yields Incorrect Results

We have had several clients recently update to  UR 5 of Management Reporter 2012.  For those of you that have applied updates to MR, you know that this is generally a uneventful process.  However, in some recent cases, after applying the update clients noticed that some of their reports were pulling incorrect balances.  I should note that we have seen this happen using both the data mart and legacy providers.

As we began to dig in to the reports, we noticed that the incorrect balances were related to specific reporting units in the tree.  And these reporting units were a little different, as they were excluding one particular value for dimension.  So, for example, the reporting unit had two values specified for the department dimension:
  • Add (+) a range of 00:99
  • Subtract (-) single value of 50
The purpose of this reporting unit was to pull all departments with the exception of 50.  And this functioned fine on earlier releases of MR.  So we redesigned the reporting unit, in this case, to include two ranges that effectively achieve the same end result:
  • Add (+) a range of 0:49
  • Add (+) range of 51:99
This, in turn, returns correct results.  And in our testing, it seemed to specifically be affected rows with a normal balance of C to reverse the sign. 

We reached out to Microsoft, and it appears that this may be a variation of quality report 708796, which deals with issues with ranges in dimensions.  Will keep you posted on any updates I get on the resolution, just thought I might save someone some time hunting around for the cause.  And, yes, I still love Management Reporter :)

Christina Phillips is a Microsoft Certified Trainer and Dynamics GP Certified Professional. She is a supervising consultant with BKD Technologies, providing training, support, and project management services to new and existing Microsoft Dynamics customers. This blog represents her views only, not those of her employer.

1 comment:

Lyn Barr said...

Thanks for this! I've seen this quite a few times and have been banging my head, trying to figure it out!