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. You can 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 you fetch the Trial Balance report, for all accounting periods in a year it shows the trial balance for G/L accounts for one year.

And when you fetch the G/L Accounts - Line Items report, you only see the information for the accounting periods for which the postings are made (reflecting a difference in the opening and ending balances of the company).

Another reason might be that Trial Balance report only considers postings with a certain closing step, while G/L Accounts - Line Items considers all closing steps. If you add the characteristic Closing Step to both reports you'll be able to identify this.

The system works as expected.

Trial Balance, G/L Account Line Items, 试算表，结账步骤 , KBA , SRD-FIN-GL , General Ledger , Product Enhancement