SAP Knowledge Base Article - Public

2175499 - Outstanding Amount of Aging List for Payables Report Does Not Match Ending Balance Company Currency of Trial Balance Report

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

  1. Go to the General Ledger Work Center.
  2. Go to the Reports > List View.
  3. Search and open the Trial Balance Report.
  4. Enter the required details in the Selection field.
  5. Click Apply.
  6. 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

Product

SAP Business ByDesign all versions