We seem to have encountered a bug in the CRM 2011 Chart tool.
Due to the nature of our business we have orders with what are essentially duplicate lines with all of the money and number fields being the same except the lineitemnumber which of course is unique to each line.
We have also added some custom fields to the SalesOrderDetail entity which we want to chart and total on.
When we pull up a chart, it is as if the chart is eliminating the duplicate numbers. So with 3 lines for $331.46 the chart shows 331.46. If I were to change one of the numbers to $331.47 the chart would show 662.93. If I were to set the
chart to group by lineitemnumber it shows each line properly.
One truly weird thing though is that this bug does not exist for users with Organization Read permissions on the SalesOrder entity. If they are parent/child or below the bug exists.
As part of trying to resolve this bug we have upgraded to RU18 and the bug still exists.
Does anyone have any ideas on this? Please ????