Personal Insights
Things to remember in Foreign Currency Valuation
Hello Everyone!! This is my first blog post on SAP community. I would highly appreciate feedback and recommendation in comment box.
Introduction:
This blog post will not take you through the customizing of foreign currency valuation; instead you will learn one or two things differently. I will be explaining features and functions of FCV in SAP.
Below are the key points we will be looking at:
- Brief introduction of FCV
- Scope of FCV
- How GLs are valuated based on Master data setup?
- What are the use of KDB and KDF account key?
- Basics of FAGL_FC_VAL transaction
So let’s get started foreign currency valuation:
When a foreign currency valuation is done in SAP, all open items and balances in a foreign currency will be converted to local currency using the current exchange rate maintained in the system.
After taking FCV run SAP creates two postings. One for actual valuation at the month-end and the other for reversal on the next day i.e. first day of next month (depends on configuration), but sometimes next period is not open for the reversal postings, so SAP only creates one posting. Now if you have taken the valuation run via batch input then you can open the period and continue with the batch run.
If no batch run were selected then have to manually reverse the postings on the next day with the only transaction code FBB1. This transaction does not post balance in other currencies than the local one.
Scope of Foreign Currency Valuation
Generally, currency valuations cover the following:-
- Customer open items, Vendor open items, and General Ledger Open Line items, Managed in foreign currency. (Each document is evaluated separately and the valuation posted with gain/loss)
- Other General Ledger Balance Sheet Accounts Managed in Foreign Currency, but not flagged as open item management accounts. (Only the balance of G/L account is valuated and gain/loss is posted)
Foreign currency valuation is only done for Balance sheet G/L accounts
We need to determine G/L accounts for open item managed G/Ls and for G/Ls which are not managed as open item basis:
Figure 1: Snapshot from SAP ECC
The above set up is must if you want to valuate any G/L account.
Exch. Rate Diff. using Exch. Rate Key – KDB :- Here we set G/L account for the G/L accounts which is not managed as open items
Exchange Rate Dif.: Open Items/GL Acct – KDF :- Here G/L account is set for open item managed G/Ls
Let’s see the account determination for KDB account key:
Now if we double click on the KDB account key, the system will ask you to enter the chart of account – so the account is determined on chart of account level, correct?
But in below screenshot you can see, we have option to choose valuation area (highlighted field)
So we can set G/L account on Valuation area + chart of account level (Note: Valuation area is optional and mostly G/Ls are not set per valuation area)
Figure 2: Snapshot from SAP ECC
Figure 3: Snapshot from SAP ECC
In above screenshot the G/L accounts for realize exchange rate gain and loss are maintained with exchange rate difference key.
As said earlier this setting is used for the G/L accounts which are not managed as open items, so now let’s link this customizing to the G/L account:
Figure 4: Snapshot from SAP ECC
Here in the control data tab of G/L account, we can assign the exchange rate difference key. Based on this key; G/L accounts for loss/gain will be determined.
The above G/L account does not have an open item management tick. But even if this account has that tick, the system will not restrict you to assign this key in G/L and neither considers it in valuation.
Account determination for account key KDF
This setup is required for open item managed G/L accounts
Figure 5: Snapshot from SAP ECC
From the above snapshot, it can be considered that each and every G/L account needs to be configured, when its managed as an open item basis; unlike the previous one, where we just create exchange rate keys and then assign it in G/L master data.
Account key KDF can also be maintained on valuation area level.
Figure 6: Snapshot from SAP ECC
The highlighted area in the above figure explains how/on what basis G/L accounts can be determined.
We have below possibilities to set the G/L account:
- For the G.L account
- For G/L and currency combination
- For G/L and currency type combination
There are two options for assigning Loss and Gain G/L accounts:
Figure 7: Snapshot from SAP ECC
The G/L accounts which are managed on open item basis, needs a clearing.
For e.g. vendor invoice is booked on 01.01.2020 it is stored as open item and cleared when payments made against the invoice.
Let’s say the payment against the invoice is made after two months on 04.03.2020
Now when the valuation run is taken on the 31.03.2020 system calculates the difference between the exchange rate of Invoice booking date and the rate of clearing date
And the difference is posted to exchange rate difference realized account (Highlighted in above screenshot)
But what about the valuation runs comes between the invoice booking date and clearing date:
Figure 8: Snapshot from SAP ECC
In the above example invoice was booked on 01.01.2020 and not cleared till 31.01.2020
But still we need to evaluate the balance of vendor in the month end, in order to have correct financial reporting to local tax authorities.
So this time system calculates the exchange rate difference of invoice date and the date on which valuation run is taken
And the difference is posted to valuation G/L accounts (highlighted above)
We have one more option to set Balance sheet adjustment account
In most of the cases, we know the valuation difference is calculated and reversed in the next month, so there might be a requirement to not book these differences on the same G/L account, instead, post to the separate G/L account.
In that case we will assign different Balance sheet adjustment account otherwise the same G/L Account should be maintained.
And now the last section: Translation –
Figure 9: Snapshot from SAP ECC
This field is used to translate the balances into group currency. We will discuss this in separate blog.
Transaction FAGL_FC_VAL
Figure 10: Snapshot from SAP ECC
If the create posting is not ticked then transaction will be executed in test mode
Executing the transaction with batch input session helps many times, several times error does not appear in a test run and comes at the time of direct posting
In those cases system stores the data in batch input which is not posted and you can rectify the error and run the session
Figure 11: Snapshot from SAP ECC
Variant configured here impacts on the displayed output after executing the transaction. We can configure user-friendly variant, easily as per the requirement.
If the save log button is not ticked, then it’s almost impossible to track the valuation runs, so make sure the end-user is applying this check-in each evaluation.
Conclusion
This brings us to an end of this blog post. We will quickly recap the points covered here:
- FAGL_FC_VAL valuates the Balance sheet GL items and the valuation difference is posted to different accounts based on Master data setup and configuration
- Valuation run ended with errors can be processed further from batch input
- Save the logs of each valuation run to identify/revisit the errors
Hope you like reading this blog, do mention your suggestions in comment section.
Stay Tuned.. If you would like to get notified upon any update related to this topic or this blog post then follow tag FIN General Ledger or Follow Shubham Chavan.
Hi Shubham Chavan
I wonder why are you showing usage of Tcode FAGL_FC_VAL, when it is set as obsolete and replaced many years ago by FAGL_FCV which has more capabilities?
Regards,
Marek
Hi Marek Turczynski
Thanks for your feedback/concern. I have written this blog post referring to SAP ECC and what I know about FAGL_FCV is that, if in any given client the valuation run is updated with FAGL_FCV then afterwards system will redirect the FAGL_FC_VAL to FAGL_FCV. And if in given client FAGL_FCV is not updated any valuation document then old program with transaction FAGL_FC_VAL works as it is.
So technically, in both cases using FAGL_FC_VAL will not be incorrect.
Please correct me if this is not the case.
Regards,
Shubham
Hi,
Yes, I agree it redirects to FAGL_FCV but the screens you are showing from FAGL_FC_VAL are totally different in FAGL_FCV. That is kind of missleading and could confue the reader.
Regards,
Marek
Very nicely written and helpful to understand the concept. Thanks !!
Excellent article !!
I face a peculiar issue, in FAGL_FCV (S/4 Hana) pick for valuation the retained earning account (ex. 4900000000) with foreign currency, without find such transactions in FI reports:
Have you seen again such a case ? In this company there are PnL accounts posted in foreign currency, but the amounts are not matched.
Thanks in advance
George Radicopoulos
Thanks very helpful.
This field is used to translate the balances into group currency. We will discuss this in separate blog.
--> Looking forward to more blogs on this topic.
Usually this part is not set up in the company.
Very useful article. Thanks a lot. Siva
Hi Shubham,
Useful article. I have a doubt. If FAGL_FCV calculates two different values between two Ledgers (Leading Ledger and Local Ledger), how to rectify the variance? I would think that's the result expected when running this task in fact, but, business is questioning why there is a difference in FCV between two different Ledgers?
Any thoughts?
Cheers, Siva
Hi
First of all very well written article.
We were using it to revalue with only one GL account so we maintained blank exchange rate difference key and GL accounts for gain and loss in P&L and it is working fine.
my new requirement is that we want revaluation of some GL accounts to post to different FX GL account. so I added another line in KDB for exchange rate difference and named it ABC and added GL accounts for it.
I then updated my BS GL account with this exchange rate difference key and I run the revaluation, it is still posting to the one we maintained earlier with blank. I did try to remove the blank line and named that one as well but still revaluation is posting to the same GL account. you can help please what could be I am missing?
Further to my comment, i completely removed the line KDB for the other GL account and revaluation is still posting to that GL account so that means that GL account is maintained somewhere else, can you please help where else it is getting that GL account to post revaluation to?