cancel
Showing results for 
Search instead for 
Did you mean: 

Cross-currency clearing problem

Former Member
0 Kudos

Hi,

Foreign cross-currency clearing btw USD & EUR is a business requirement for us (local currency is TRY). In order to do this right we maintain exchange rate table for cross currency rates btw USD & EUR. However in clearing transaction code (F-44), system calculates line item amounts as explained below:

"You can clear open items in any currency.

The amount of all the selected open items will automatically be translated into the currency in which clearing is to take place. The translation is executed as follows:

Item currency - Local currency - Clearing currency.

You are therefore not required to make additional entries in the exchange rate table for cross-currency clearing."

In this case, when we try to clear USD & EUR documents, amounts are not matching. Is it possible to calculate amounts displayed in clearing transaction accoring to cross currency exc. rates ?

An example i have is as follows:

Invoice Amount: 25,000 USD

Invoice Date: 1st May 2011

USD to TRY rate: 1,51410

EUR to TRY rate: 2,24960

USD to EUR rate: 0,67304

Payment Amount: 16,810 EUR

Payment Date: 5th May 2011

USD to TRY rate: 1,53060

EUR to TRY rate: 2,27630

USD to EUR rate: 0,67240

According to this example, if you try to clear invoice with payment on 5th May 2011 in USD, payment amount is displayed in F-44 as 24,999,74. In fact it is 25,000 USD if you use cross currency rate of 0,67240.

Regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188028
Active Contributor
0 Kudos

Please clear in your company code currency.

Former Member
0 Kudos

Hi again,

Thank yoy for the advice but clearing in company code currency doesnt really work. Because there is difference in terms of comp. currency and this difference has to be posted to curr diff. gain/loss account. If we try to clear it remains in the vendor account.

former_member188028
Active Contributor
0 Kudos

If you clear the items in Comp code currency, then there will not be balance for Comp. code currency may be in document currency. Anyway document currency balance we can't make up to zero and also we don't check the balances in document currency.

Rgds

Former Member
0 Kudos

Hi, you can clear in local currency