SAP Knowledge Base Article - Public

2581778 - Currency Conversion in Report Not Working

Symptom

When executing a report the value in the report is displayed in different currencies (Example - USD, GPR, INR).

Or you might get the error message "Exchange rate not found from currency ABC to display currency DEF." (ABC and DEF represent currencies).

Environment

SAP Cloud For Customer

Reproducing the Issue

Here we are taking example of the Opportunity Analysis report.

  1. Open the Business Analytics Work Center.
  2. Select Design Report.
  3. Search for the report Opportunity Analysis.
  4. Run the report for any specified selection, such as Display Currency = USD (if the required results are needed to be shown in USD).
  5. Results in the report under key figures (Expected Value) will be seen in different currencies. 

Cause

There are no currency conversions maintained in the system.

Resolution

To solve the issue, maintain currency conversions.

  1. Go to the Administration work centre.
  2. Go to the Common Tasks view.
  3. Select Exchange Rate For Foreign Currencies.

See Also

Blog:

C4C currency exchange rates – good to know

SAP Help Centre:

Keywords

currency, currency in report, key figure , KBA , LOD-CRM-OPP , Opportunity Management , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Sales Cloud all versions