Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Possible Reasons of the /Huge/ Exchange rate differences during clearing

Purpose

The purpose of this page is to give an overview of possible causes which could lead to exchange rate differences during the clearing process.  

Overview

You are clearing a document using an FI transaction, and you use different document currency from your local currency during clearing.

There are different cases, when you get exchange rate differences after this process:

1.     When the maintained exchange rate (TA OB08) is different between the date of the clearing and the date of the posting or you manually enter a different exchange rate (BKPF-KURSF) during clearing;

 2.     When the additional local currency amount is entered manually via FB05;

 3.     When a foreign currency valuation was done with active 'Bal.sheet preparation valuatn' flag before clearing.

Case 1. ) Different exchange rates between posting and clearing

You post a document in an FI transaction in foreign currency (USD). The exchange rate is 1,24 USD/EUR at the time of the posting, and the local currency is EUR.

The amount in LC (DMBTR) is calculated from the entered amount (WRBTR = 100 USD) during the posting, and the actual exchange rate.

 

BSEG table for the posted document:

                                                           

In a different date you clear this document in foreign currency USD. The exchange rate maintained in OB08 on this day is 1,37002 USD/EUR, thus exchange rate difference is created in a new line item with transaction (BSEG-KTOSL) KDF.

As the balance is zero in document currency (USD) but the balance is <> 0 (here the difference is 7,66 EUR) in local currency (EUR), the system creates an additional line item as exchange rate difference, so that the balance = 0 in local currency, too.

 

Document currency view (USD) after simulation the clearing document:

                                                     

 

And in Local currency view (EUR):

                                                     

 

BSEG table for the clearing document: 

                                                         

 

Case 2. )   Clearing with manually entered LC amount

 You use transaction FB05 to clear a document in foreign currency (USD). The local currency is EUR. 
During clearing the hard currency amount is entered manually (here 50 USD) in the bank line item.

                                                             

 

Change hard currency amount from 100 USD to 50 USD.

                                                             

A warning message will appear:
„Calculated rate     0,68503 deviates from document header rate /1,37002 by       50,00 %
Message no. F5216”

But you can continue the clearing procedure with Process open items and finish the procedure.

The field BSEG-HWMET is filled in the clearing document:

Basically the field BSEG-HWMET (Method with Which the Local Currency Amount Was Determined „E”) indicates whether the current rate was used or whether the amounts in second or third local currency were entered manually or determined by entering an asterisk. Using the 'asterix' have some 'side effects', see further notes 316176 and 320783.

So if you enter the local currency amount manually in a line item (BSEG-HWMET = E) as a result, the balances are calculated for each currency and the amount fields are filled accordingly.
The effective rate that results from the document currency and local currency may then vary significantly from the original rates.

The reason for the exchange rate difference is outlined in note 1224960.

To prevent the system using an incorrect rate for amounts in first local currency or an alternative amount in first local currency, work with the customizable messages:

 - F5 212: Exchange rate & deviates from table rate & by & %
 - F5 216: Calculated rate & deviates from document header rate & by & %,

and define these messages as error messages, if required - as described in the Note 1224960.

 

+ In case of HUGE differences:

During clearing open items for example in transaction F-32 the large exchange rate difference is due to the effective rate calculated through the system when entering an asterix ('*') in the amount field of the difference line item.

By entering the difference amount manually the exchange rate differences are less high.
The situation is described in note 1224960 see part 'further causes'.

If the calculated effective rate consequently differs from the header rate and the group currency amount for the difference line items is much higher than by using the header exchange rate, this consequently leads to a much higher amount for the realized gain/loss line items.

If you want to prevent these high amounts please just input the difference amount manually and press enter. The system then uses the actual exchange rates.

 

Case 3. )   Valuation differences (BSEG-BDIFF)

 

If there is a value in BSEG-BDIFF, meaning you have performed a foreign currency valuation with the indicator 'Bal.sheet preparation valuatn' (via valuation report SAPF100, transaction F.05), the valuation difference is noted in the item (BSEG-BDIFF or BSEG-BDIF2).

                                                              

 

If you performed a foreign currency valuation with the indicator 'Bal.sheet preparation valuatn', field BSEG-BDIFF is filled in the document you can see it in FB03 in Environment/Valuation/Display Values too.

 

                                                           

 

                                                        

If you want to clear an open item after valuation run with active 'Bal.sheet preparation valuatn', the balance sheet adj. account (defined in OB09) should be cleared as well.

The realized gain (based on the previous valuation) is posted as an exchange rate difference line to the account with internal transaction KDF and the balance sheet adjustment account has to be cleared (with internal transaction KDB).

 

                                         

 

Related SAP Notes/KBAs:

546997 - FAQ Exchange rate difference when clearing in local currency
1703480 - Inconceivable large exchange rate difference happens during clearing in T-code F-53
1224960 - FB05: Large exchange rate differences due to effective rate
1143378 - FB05: Exchange rate difference lines cannot be explained


Related child pages:

Exchange Rate Customizing
Manually entering Exchange Rate at Document Level

Calculation of currency conversion

 

 

  • No labels