SAP Knowledge Base Article - Public

2603568 - Unable To Find The Opening And Closing Balances In G/L Account Line Items Report

Symptom

You are unable to find the opening and closing balances in the G/L Account line items report and this is the same behavior with the Accounts Receivable - Line Items, Accounts Payable - Line Items reports as well.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics Workcenter.
  2. Design reports view.
  3. Search for the G/L account line items report.
  4. Enter the required data in the parameters
  5. You don't have the details of the opening and closing balances displayed
  6. This is the same behavior with the Accounts Receivable - Line Items, Accounts Payable - Line Items reports as well.

Cause

There are no opening/ending balances options in the line items reports directly.

Resolution

You could find the Opening Balances and Closing balances details in the Accounts Payable - Balance Audit Trail, Accounts Receivable - Balance Audit Trail and Balance Audit Trail have reports for the same. All balance audit trail reports are a combination of line item and trial balance. They will have opening/ending balances as well as Journal entry details for the given period

Keywords

Opening and closing balances in G/L account line items report, Cannot see openin and closing balance fields in G/L account line items report , KBA , SRD-FIN-GL , General Ledger , Problem

Product

SAP Business ByDesign all versions