cyberscout
Active Member
Hello,
We have developed different reports for financials based on the business view V8300001 (Financial Reporting (F0901/F0902/F0006). Beside the existing columns we added a new column "Group reporting code" to show the fields Alternate Object Account and Alternate Subsidiary from account master.
In a first version I tried to add this column to the view, but this did not work because each account has been added several times (once per cost center).
Then I created Report variables (RV) and added code ^(see attachement) on the "Before Level Brake" trigger with a simple F0901.Fetch Single. This works for standard accounts but the Group Reporting codes are also shown on account balances (account level of detail <= 6).
Does anyone have an idea about how I could reset this Report Variable in order to have it only on posting accounts (account level of detail = 7, 8)? Maybe that does not work at all because it is a financial reporting repot?
Best regards
We have developed different reports for financials based on the business view V8300001 (Financial Reporting (F0901/F0902/F0006). Beside the existing columns we added a new column "Group reporting code" to show the fields Alternate Object Account and Alternate Subsidiary from account master.
In a first version I tried to add this column to the view, but this did not work because each account has been added several times (once per cost center).
Then I created Report variables (RV) and added code ^(see attachement) on the "Before Level Brake" trigger with a simple F0901.Fetch Single. This works for standard accounts but the Group Reporting codes are also shown on account balances (account level of detail <= 6).
Does anyone have an idea about how I could reset this Report Variable in order to have it only on posting accounts (account level of detail = 7, 8)? Maybe that does not work at all because it is a financial reporting repot?
Best regards