Tax Calculation and Reporting PaPM Sample Content- Currency Conversion Error

[soumya_2901]

We are facing currency conversion error in PaPM sample content Tax Calculation and Reporting Environment SXT Version 8. We are using PaPM service pack 15 version 3. We are facing below 5 errors while running the conversion function:

1. currency/unit conversion error: "NXI"."Y600SXT0008CVEXL": line 1235 col 3 (at pos 314720): search table error: Conversion( "TRHSL" ), row 4: could not determine valid conversion rate for value(s) 1485000 from unit 'EUR' to unit 'USD' on date 2020-12-31 00:00:00.0000000

2. Function=CVEXL Conversion to Local Currency executed in DB in 0.051000 seconds (running total 0.681000 seconds):

3. A database error occured. The error message in the database was: "currency/unit conversion error: "NXI"."Y600SXT0008CVEXL": line 1206 col 5 (at pos 305954): currency/unit conversion error: "NXI"."Y600SXT0008CVEXL": line 1235 col 3 (at pos 314720): search table error: Conversion( "TRHSL" ), row 4: could not determine valid conversion rate for value(s) 1485000 from unit 'EUR' to unit 'USD' on date 2020-12-31 00:00:00.0000000".

4. Execution of Function=CVEXL failed

5. Process Run FS-PER Function, variant Conversion to Local Currency has status Ended with errors (instance B1P57ISYTTFA2T7ZH1LK6VPR9)

Could you please help?

[zhiyitang]

Hello Soumya,

in the function CVEXL the used conversion type already has been configured. It's MAN_CON_PL - "Global Currency Conversion P&L". When you have properly set up this conversion type at Environment level, and go back to CVEXL and reactivate it, it should return right result.

In the configuration of conversion type, the authoring schema is commonly the logical schema which maps to the ABAP schema. The exchange rates should stored in the configured Rate Table. When Rate Table is kept empty, the conversion function will use the default rate table TCURR from ERP.

Furthermore PaPM conversion function leverage HANA CONVERT_CURRENCY function. More details may be found here: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/d22d746ed2951014bb7fb0114f...

[former_member716691]

Dear Soumaya,

thank you for your question and be interested in Tax Calculation and Reporting Sample Content. Can I kindly ask you to check the settings for currency conversion in the environment configuration in your system. Let me just share with you the SAP note https://launchpad.support.sap.com/#/notes/2901604 with instructions. Please compare the settings done in your system with the provided steps.

kind regards

Katarzyna Leska

[soumya_2901]

I have followed the instructions from SAP note and activated the sample content accordingly. It is not mentioned what would be the authoring schema and exchange rate type. So I have set it as attached in the screenshot- 1.jpg. Can you please mention which authoring schema and exchange rate type to use?