AndrewCrouse
Member
I have been given the task of making some changes to the Balance sheet R10111B.
The problem I am having is with the data selection for this report. The Business View for this Report is V8300001, which is a join between F0901/F0902/F0006.
This seems straight forward, I Modified the data selection to select the account range we needed and ran the report. After running the report we had discovered that it was missing some accounts. After doing some digging we found that the report would only display accounts that were attached to Business Units that were flagged as "BS" (Balance Sheet). We have some accounts attached to Business Unit types "IS" (Income Statement) but we still wanted them on the Balance Sheet report. Even though the accounts we wanted to see were within our data selection they would not appear, because they were not of type “BS”.
The report makes no reference to the Business Unit Type (MCSTYL), yet it seems to be hard coded somewhere as part of the data selection.
Is there some other way of modifying the data selection of the report other than the data selection and event rules (SetUserSelection) ?
Any help would be appreciated.
Thanks
Andrew
The problem I am having is with the data selection for this report. The Business View for this Report is V8300001, which is a join between F0901/F0902/F0006.
This seems straight forward, I Modified the data selection to select the account range we needed and ran the report. After running the report we had discovered that it was missing some accounts. After doing some digging we found that the report would only display accounts that were attached to Business Units that were flagged as "BS" (Balance Sheet). We have some accounts attached to Business Unit types "IS" (Income Statement) but we still wanted them on the Balance Sheet report. Even though the accounts we wanted to see were within our data selection they would not appear, because they were not of type “BS”.
The report makes no reference to the Business Unit Type (MCSTYL), yet it seems to be hard coded somewhere as part of the data selection.
Is there some other way of modifying the data selection of the report other than the data selection and event rules (SetUserSelection) ?
Any help would be appreciated.
Thanks
Andrew