Symptom
Outstanding Amount of Aging List for Payables report does not match with the Ending Balance Company Currency of Trial Balance report
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger Work Center.
- Go to the Reports > List View.
- Search and open the Trial Balance Report.
- Enter the required details in the Selection field.
- Click Apply.
- The amount in the Ending Balance Company Currency is not equal to the Outstanding Amount in the Aging List for Payables report based on the same selection criteria.
Cause
The Ending Balance Company Currency field in the Trial Balance report does not consider the Display Currency / Conversion Date parameter. Changing the date in this parameter does not affect the values in this field, as it reflects amounts based on the exchange rate applicable on the posting date of the documents.
Resolution
To view the values based on the Display Currency / Conversion Date parameter, the Ending Balance Line Item Currency key figure must be added to the report.
This can be done by navigating to View Selection -> Cloumn Fields, selecting the Ending Balance Line Item Currency Key Figure.
Now, executing the Trial Balance report will display the expected amounts.
Keywords
Aging List for Payables, Trial Balance, Report, Outstanding Amount, Ending Balance Company Currency , KBA , SRD-FIN-ANA , Analytics Content , How To