SAP Knowledge Base Article - Public

2714981 - Reports Accounts Receivable - Open Items and Aging List for Receivables Show Different Amounts With Same Currency and Conversion Date

Symptom

While comparing reports Accounts Receivable - Open Items and Aging List for Receivables for the same day, for example 31.01.2018, the amounts are not equal when converting to Company Currency.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Find Aging List for Receivables report.
  4. Select:
    1. Customer ABC.
    2. Cut Off Date 31.01.2018.
    3. Display Currency XYZ.
    4. Display Currency 31.01.2018.

Source Document ID XXX shows amount 110 in Currency XYZ.

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Find Accounts Receivable - Open Items report.
  4. Select:
    1. Customer ABC.
    2. Key Date 31.01.2018.

Source Document ID XXX shows amount of 120 in Currency XYZ (considering the Foreign Currency Remeasurement of Receivables amount as well).

Codes used as example IDs:

Customer ID ABC.

Document ID XXX.

Currency XYZ.

Cause

The diverging amount that shows when comparing both reports is due to the different Rate Types used by the system on the Foreign Currency Remeasurement.

The amount in Accounts Receivable - Open Items shows the currency conversion from the transaction itself, the same can be checked in the Journal Entry.

The amount in Aging List for Receivables will change according to the selected Conversion Date.

Considering that the Exchange Rate was 1.3050 (for example) on the date of the Document, this is the Exchange Rate used in the report.

However, due to the configuration done for the Foreign Currency Remeasurement of Receivables to use another Rate Type the two reports will show different amounts. Accounts Receivable - Open Items will show the Amount using Exchange Rate from Foreign Currency Remeasurement of Receivables while Aging List for Receivables will convert the Amount with the Default Exchange Rate from the selected Conversion Date.

To check this configuration, follow below steps:

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Find Foreign Currency Remeasurement Methods for Payables and Receivables activity.
  4. Click Edit foreign currency remeasurement methods.

Here it shows that the Rate Type DEF was selected for Method GHI.

  1. Click Close.
  2. Click Assign remeasurement method to accounting principle.

Here it shows that Accounting Principle JKL is assigned to Method GHI, with Rate Type DEF.

Codes used as example:

Rate Type DEF.

Method GHI.

Accounting Principle JKL.

Resolution

This is the expected scenario.

Keywords

Exchange Rate, Reports, Accounts Receivable - Open Items, Aging List for Receivables, difference, Rate Type , KBA , exchange rate , accounts receivable - open items , aging list for receivables , reports , difference , rate type , SRD-FIN-ANA , Analytics Content , How To

Product

SAP Business ByDesign all versions