Currency Conversion in Bex Report

[Former Member]

Hi,

My report is based on Procurement GR data. The requirement is based on currency conversions in selection screen

There are 2 columns in report which are planned exchange rate and applied exchange rate.

Logic:

“Applied exchange rate” should be exchange rate between document currency to selected target currency based on Posting date of the GR issue date from M type exchange

“Planned exchange rate” should be based on year (YYYY) from posting date of the GR issue 31.12.YYYY, should be exchange rate between document currency to selected target currency and M type exchange

Can you please update me how it can be done?

Thanks

[former_member182470]

Please search for below documents :--

1) Currency Conversion using Variables in SAP BI -Reporting

2) How to…Use Variables for Currency Conversion

You need to apply variables locally to two Columns but not in the Filter pane.

Create a Dummy KF and restrict it with GR Issue Date Variable. This is to enable to selection screen while running report. Hide this KF.

Applied Exchange rate can be easily achieved by above two Documents which I proposed.

For Planned Exchange rate, you must create a Calyear variable which replaces with GR Issue Date Variable-->External Value Key-->Offset Length as 4.

Restrict this variable for Planned exchange Rate KF

Hope I have given you some ideas to go ahead.

Regards,

Suman

[Former Member]

Please update

[Former Member]

Hi Experts,

Please update...i need to calculate Forex Impact in my BI report.

Thanks in advance