CONVERT_TO_FOREIGN_CURRENCY for future exchange rate is not working

[rahul_khilari]

Hello,

I am using FM CONVERT_TO_FOREIGN_CURRENCY to send future prices valid from 01.01.2017.And maintained exchange rate as 1.2 in TCURR table valid from 01.01.2017.

But after executing its taking exchange rate as 1.25 which is valid from 01.01.2016.

After debugging what I have found out is this FM is using value DATE = sy-datum so If I am running this FM on 21.12.2016 then DATE=sy-datum=21.12.2016 and it will pick value 1.25 from TCURR table.

Why this is so?Why I can't send future prices with future exchange rate?

[raymond_giuseppi]

Which value did you pass in DATE parameter?

Regards,
Raymond

[rahul_khilari]

as DATE = sy-datum,which is current date at runtime.

Means If I am running this program today then it is taking value as 21.12.2016.And selecting exchange rate from TCURR table as per date 21.12.2016.

While my requirement is I need to send price whose validity is 01.01.2017 to 31.12.9999.So logically it should take exchange rate for year 2017.But as I earlier explained it is taking current date and selecting exchange rate.

[raymond_giuseppi]

You didn't to pass 01.01.2017 to date parameter (sy-datum is just a default value)