Cross Currency Receipts

[Former Member]

If we book a Invoice on 29th Dec for 500 USD @ 131 = 65500 LKR.

On 29th Dec the USD - LKR rate in OB08 is 130 .57895.

Now when I make F-28 on 30th Dec for 30896.62  INR @ 2.12  = 65500.83 LKR

While doing F-28 system propose the open invoices in equivalent INR.

At that time System propose 500 USD value as 30796.92 INR. This is calculated by cross Currency rate which is calculated as 130.57895 / 2.12 = 61.59384. i.e OB08 rate of Invoice Date divided by Transaction rate of receipt entry

As per our requirement system should propose USD value as 30896.62 INR which will be calculated by cross Currency rate which is calculated as 131 / 2.12 = 61.79245. i.e transaction  rate of Invoice Date divided by Transaction rate of receipt entry

What is the method by which we can do the settings of calculating cross currency rate for proposed Open Items with reference to Transaction rate of Invoice & not OB08 rate of Invoice date

regards,

Gauri Ranade

[former_member198650]

Hi Gouri,

System will convert the invoice value as per rate available on posting date in OB08 while doing F-28. If you want the invoice amount converts as per exchange rate of receipt. Then you have to maintain the currency settings in OB08 for USD as 131.

Regards,

Mukthar

[Former Member]

Hi Mukthar,

I want that while proposing open items system should calculate cross currency rate with refernce ti Invoice transaction rate & not OB08. we cannot change the Ob08 rate each time while invoicing. There will be multiple invoices with different rates

regards,

Gauri Ranade

[former_member198650]

Hi Gauri,

It is not possible to derive the currency automatically if you posting it in local currency.

Regards,

Mukthar