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
-
Go to the Business Analytics Workcenter.
-
Design reports view.
-
Search for the G/L account line items report.
-
Enter the required data in the parameters
-
You don't have the details of the opening and closing balances displayed
- 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