3650063 - G/L Account ABC Shows Different Amounts Between Reports: Financial Statements And G/L Accounts - Line Items

When comparing reports, the amount shown in Financial Statements for a specific G/L Account differs from the Balance Company Currency in G/L Accounts - Line Items.

SAP Business ByDesign

1. Go to Business Analytics work center.
2. Open Design Reports view.
3. Search and open Financial Statements report.
4. Add all the required fields and run the report.
5. Go to the entry of the G/L Account ABC. Notice that in field: Amount Company Currency it shows an amount (for explanatory purposes of this document, suppose that it shows 10.000,00 EUR)
6. Left-click on the G/L Account and on "Go to" > G/L Accounts - Line Items.
7. By navigating through the report it is found that in the Balance Company Currency field there is 0,00 EUR.

(ABC represents the G/L Account ID).

This difference occurs because of the way on how each report is designed to collect and display data.

The Report Financial Statements does not fetch entries for Closing Step: 990 - Closing Balance, while in G/L Accounts - Line Items all transactions regardless of closing steps are shown.

In the Report for G/L Accounts - Line Items, for G/L Account ABC, if you filter for the Closing Steps and remove the entry for Closing Step: 990 - Closing Balance, you will get the same results as of the Financial Statements Report.

This is the designed system behavior for both reports.

financial statements, g/l accounts, differences , KBA , SRD-FIN-ANA , Analytics Content , How To