2490615 - Data Discrepancy in Trial Balance and G/L Accounts - Line Items Report

When comparing Trial Balance report with G/L Accounts - Line Items report, all the accounting periods are not shown in the line items report.

SAP Business ByDesign

To open Trial Balance report:

1. Go to the General Ledger work center.
2. Go to the Reports view and click the List.
3. Open the report Trial Balance.
4. Enter appropriate filter data selecting the Accounting Period/Year for one Fiscal Year.
5. Select a G/L Account (if required).
6. Click Accounting Period/Year and click Move to Rows.

To open G/L Accounts - Line Items report:

1. Go to the General Ledger work Center.
2. Go to the Reports view and click the List.
3. Open the report G/L Accounts - Line Items.
4. Enter the same filter data.
5. Click Accounting Period/Year and click Move to Rows.

• When the Trial Balance report is executed for all accounting periods within a fiscal year, it displays the trial balance for G/L accounts for one year.
• Meanwhile, the G/L Accounts - Line Items report only displays data for accounting periods in which postings exist, which can result in differences between the opening and closing balances shown in the reports.
• Another possible reason is that the Trial Balance report consider only postings with specific Closing Steps, whereas the G/L Accounts - Line Items report includes postings from all Closing Steps. Adding the Closing Step characteristic to both reports can help to identify this.

This is the expected system behavior.

periods without postings, nonposting periods excluded, zero-activity periods, opening balance mismatch, closing balance mismatch, report variance, reconciliation issue, detail versus summary, fiscal period coverage, posting existence filter, zero-balance periods, line item visibility, balance rollforward, period aggregation behavior, empty periods hidden , KBA , SRD-FIN-GL , General Ledger , How To