Exchange rate problem

[Former Member]

Dear Gurus,

Can any one tell me why the exchange rate is always picking up frm the currency table (even though we gave the exchange rate manually while booking and payment) while doing Bank Reconciliation statement.

Scenario.

Currency table(OB08) rate is 1 USD = INR 45

Booked the invoice at 45.11

Cleared the inv at 45.11

After generating the BRS(upto batch processing everything is fine) and while doing batch processing (SM35) we are getting struck at the FB05 screen as it says difference is too large to clear - ie is because system picks up the table rate(45).

We do not want the system to pickup the table rate(invoice is already cleared with a different rate)

Please help me solve the issue.

Thanks

Deepak

[JozsefSzikszai]

hi Deepak,

you have to clear the postings in foreign currency, than it will work.

hope this helps

ec

[Former Member]

I have cleared the outstanding payment in foreign currency.

Are you mentioning some other clearing. Please advise.

Deepak

[JozsefSzikszai]

can you clarify the process?

1. Post invoice in foreign currency

2. Pay invoice and clear the two items on the vendor at the same time

What is happening after that?

thanks

[Former Member]

I am experiencing a different problem actually.

I tested the same scenario manually rather than doing it through batch processing.

<b>2.</b> When we make payment - F-53

Dr. Vendor - USD 1000 @ 45 INR 4500

Cr. Ougoing Bank Account - USD 1000 @ 45 INR 4500

<b>2.</b> Then doing a post with clearing - FB05

Dr. Ougoing Bank Account - INR 4600

Cr. Bank Account - INR 4600 -

Here you can see that it is picked up the rate from currency table (1usd = inr 46)

I am surprised why at post with clearing I am getting an open item which is converted @ 46 from currency table rather than 1000 @ 45.

Please help me as I need to solve it immediately.

Thanks

Deepak

[JozsefSzikszai]

thanks for info, but I don't understand... In FB05 you have the possibility to add the the currency USD and the exchange rate (which I believe you do), so this should work properly.

[JozsefSzikszai]

what you could try is that do both postings separately without the clearing (in transaction FB01) and as third step do the clearing in F-03 (in USD). I am curiuos what is happening.

Message was edited by:

Eric Cartman