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
- Add (+) a range of 0:49
- Add (+) range of 51:99
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.