Symptom
Run a Report and add Key Figure Actual YTD but the result is not as expected.
Environment
Business ByDesign
Reproducing the Issue
- Go to the Business Analytics Work Center.
- Select Design Reports.
- For example, Search and open FINGLAU04_Q0004 Financial Statements - Plan/Actual.
- Regarding Selection Criteria , Put Company XXX(XXX Represents the ID of the Company).
- For Financial Reporting Structure, Put YYY(YYY Represents the ID of the Reporting Structure).
- In the View tab, Remove Key Figures "Plan" "Variance" and "Variance %".
- Then Add Key Figure "Actual YTD".
- In column add field "Accounting Period/Year".
Result and Expectation:
The expectation is that the results should be accumulated for example in the month February (February should be Actual YTD January+Actual YTD February). However, the system is not accumulating the amounts from the previous period.
Cause
Key figure 'Actual(…)':
Calculation = opening balance + debit - credit .
Actual is the balance of an item for that period range. The opening balance is already as the ending balance of the previous period and hence the data coming is already cumulative. Actual gives balances for the selected period in the fiscal year.
Key figure 'Actual YTD(…)':
Actual YTD gives the balances from the first period to the current date in that fiscal year.
Resolution
This is a standard system behaviour.
Keywords
Actual YTD in Reporting, Report, Financial Statements - Plan/Actual , KBA , SRD-FIN-ANA-GL , General Ledger (Reporting) , Problem