Symptom
When performing the transition from Function of Expense to Nature of Expense in ByD, it's noticed that the Adjustment amount for IS by Nature of Expense on the balance sheet does not tally with the sum of the Increase in Personnel Expenses and Decrease in Personnel Expenses in report Sales Info for IS By Nature of Expense, which is a requirement for a successful transition between Function of Expense and Nature of Expense.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Reports-List view.
- Open report Financial Statements (FINGLAU04_Q0001).
- Specify Balance Sheet Type 2 and a respective Financial Reporting Structure for I/S by Nature of Expense.
- Produce the report for a set time period and note the value under Result from Ordinary Operations->Personnel Expenses->Personnel Expense - Adj. for IS by Nature Expense.
- Next, open the report Sales Info for IS By Nature of Expense (FINPRFU24_Q0004) and produce this report for the same time period as above.
- Sum up the values for Decrease in Personnel Expenses and Increase in Personnel Expenses from the respective report views Deferred Costs - Decrease and Deferred Costs - Increase.
- The sum of these values does not tally with the above value from report Financial Statements.
Cause
The report Sales Info for IS by Nature of Expense lists only deferred values, which leads to deviating amounts and can seemingly indicate inconsistencies between this report and the Balance Sheet.
Resolution
To display the deferred values which represent the actual relation between Adj. for IS by Nature Expense and Decrease/Increase in Personnel Expenses, the variable G/L Account (Origin) should be included in the Rows/Columns section of report Sales Info for IS By Nature of Expense. When the Decrease/Increase in Personnel Expenses is summed up on the newly added origin G/L Accounts, this amount tallies with the value for Adj. for IS by Nature Expense in the Balance Sheet.
Keywords
Function of Expense; Nature of Expense; Financial Statements; Sales Info for IS By Nature of Expense; FINPRFU24_Q0004; FINGLAU04_Q0001 , KBA , SRD-FIN-ACP , Payables , How To
SAP Knowledge Base Article - Public