You have created your reporting structure for Income Statement and assigned Functional Area to your G/L Accounts. However, when running the Financial Statement with your reporting structure, the system either displays unexpected amounts to some Functional Areas or shows some G/L Accounts as Not Assigned Balance Sheet And In (s).
SAP Business ByDesign.
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports view.
- Open Financial Statements.
- Select relevant company, set of books, fiscal year, periods and your income statement reporting structure.
- Run the report.
You'll either see unexpected amounts to some functional areas and/or G/L Accounts as Not Assigned Balance Sheet And In (s).
The reporting structure is based on Functional Areas that are assigned to this structure. The report then clubs together the amounts based on the corresponding Functional Area assigned to each G/L Account Posting in the Journal Entries of the corresponding selection period.
The Functional Area determination in the Journal Entries happens based on the setup made in fine-tune activity "Settings for Income Statements by Function of Expense and Earned Profit Analysis" -> "Functional Area Determination". Hence, at the time of the journal entry posting the Functional Area is determined accordingly.
In this case, the G/L Account has been assigned to different functional areas and postings occurred in the meantime. Hence, for different journal entries the same G/L Account has different functional area assignment. Therefore, there are different G/L postings for this G/L Account with different Functional Area assignments in the selected period.
Depending on each posting it then gets assigned to a different Functional Area in the Financial Statement report. If the corresponding Functional Area is not assigned to the report, the amount in that G/L Account assigned to this specific functional area shows as Not Assigned Balance Sheet And In (s).
This is the expected system behavior. In the Financial Statement report, you can change the View option (dropdown at the reports top bar) from "Financial Statement" to "G/L Accounts - Interactive List". This view option shows the concerning amounts per G/L Accounts for the selected period as well as to which Functional Area the G/L Account/Amounts were assigned upon posting. You can also further drill-down to other reports, using the navigation targets, to analyze the corresponding journal entries.
The Functional Area determination change log can be analyzed via Business Configuration work center, Reports View via report "Configuration Change History" for the Fine-Tuning Settings.
For the Functional Areas that are not assigned to the reporting structure yet, you can use the activity "Charts of Accounts, Financial Reporting Structures, Account Determination" to make the assignment.
Income Statement. Reporting Structure. , KBA , SRD-FIN-GL , General Ledger , How To