Cause
In OBA1 or OB09, the KDF - Exchange Rate Dif.: Open Items/GL Acct is not fully maintained.
Possible Transaction
In OBA1 or OB09, the KDF - Exchange Rate Dif.: Open Items/GL Acct is not fully maintained.
Possible Transaction
Clearing Posting such as F-03, F-32, F-44, F-28, F-53, etc.
Check and Test
Transaction Code ; OBA1
IMG> Financial Accounting (New)> General Ledger (New)> Periodic Processing> Valuate> Foreign Currency Valuation> Prepare Automatic Postings for Foreign Currency Valuation
Or directly go to OB09
Select KDF - Exchange Rate Dif.: Open Items/GL Acct and if asked, enter your COA
Check and Test
Transaction Code ; OBA1
IMG> Financial Accounting (New)> General Ledger (New)> Periodic Processing> Valuate> Foreign Currency Valuation> Prepare Automatic Postings for Foreign Currency Valuation
Or directly go to OB09
Select KDF - Exchange Rate Dif.: Open Items/GL Acct and if asked, enter your COA
First, check whether the GL account that in the error message have already maintained or not. If yes, then check the currency type.
You can see from the above picture, it filled with the currency type 10 (Company code currency). Now, let's do some testing.
In this testing scenario, I posted an invoice from vendor with FB60 and later will be cleared by F-53.
Exchange rate in the invoice 1 USD = 11.000 IDR and at the time of clearing 1 USD = 10.000 (based on OB08).
In this testing scenario, I posted an invoice from vendor with FB60 and later will be cleared by F-53.
Exchange rate in the invoice 1 USD = 11.000 IDR and at the time of clearing 1 USD = 10.000 (based on OB08).
Invoice in Foreign Currency and Local Currency
At the time of clearing with F-53 Outgoing Payment, the error message F5062 arises. If I choose the Proceed link, it will be directed to OBXZ settings, DSA - Differences arising on G/L acct clearing.
Even though it have already maintained, the error still there. So, I don't think this is the right place to look up.
Then I changed the KDF settings by deleting the IDR and USD, then re-enter again. At this time I only maintain the IDR and delete the currency type.
Even though it have already maintained, the error still there. So, I don't think this is the right place to look up.
Then I changed the KDF settings by deleting the IDR and USD, then re-enter again. At this time I only maintain the IDR and delete the currency type.
This time, the error message changed to F5063. Ex.rate diff.accts are incomplete for account & currency usd
So, I entered the same GL account in KDF for USD without currency type.
Voila, the error disappears.
The GL account is taken from the KDF
Solution
In OBA1 or OB09 for KDF, do not maintain the currency type field or leave it blank.
Solution
In OBA1 or OB09 for KDF, do not maintain the currency type field or leave it blank.
Awesome article! I like it. Hats off to you for such a wonderful sharing.
ReplyDeleteCurrency Exchanger
very good explination.
ReplyDeleteReally awesome . Thanks to knowledge contributor
ReplyDeletevery useful and correct way to resolve the issue
ReplyDeleteThank you so much,indeed helpful
ReplyDeleteThank you so much.
ReplyDeleteThaaaaaaaaaaaaaaaanks finally solved this dumb error thank you for this well documented solution
ReplyDeletewhat is 211001 GL Account ?
ReplyDeleteI am very confusing about that GL account?
could you please clarify me that ?
Great and I have a swell proposal: How Long Does House Renovation Take complete house renovation
ReplyDelete