I have a unit set setup where I am specifying start and ending accounts and subaccounts. If you run the report and click on each individual unit set, the data shows correctly, but the high-level rollup shows additional accounts that should not be there. This is a screenshot of the example of how the unit sets look.
If you view 18CompEV, 19Family, 20Prem and 21AGED the correct accounts shows, but if you look at the DEPT or the Root level there are additional accounts that are showing. In the first 3 groups they report all income and expense accounts in specific subaccount, the last group only includes two specific accounts in a specific subaccount, but when you look at the upper level DEPT rollup it includes additional accounts from the sub account starting with ‘21’ even though the 21AGED shows just the two accounts specified and the start and end accounts are just those individual accounts not a range. Both the start and end accounts and subaccounts are specified on each of the groups in order to get the drill down to work. We don’t want to use a value to calculate the upper level total as that would prevent them from being able to drill down from the upper level.
Has anyone experienced this issue and if so were you able to fix it?