How to Configure Foreign Currency Valuation in Sap?

Foreign Currency Valuation: This is the process to translate and adjust foreign currency amount of monetary accounts to local amount by a current suitable exchange rate (standard exchange rate). We carry out the foreign currency valuation before we create the financial statements. The valuation includes the following accounts and items:

1), Foreign Currency balance sheet  accounts, that is , G/L accounts that we manage in a foreign currency (the balances of the G/L accounts  in  foreign currency are valuated)

2), Open items (Customers, Vendors, G/L accounts) posted in Foreign Currency( the line items are valued)

Configure Foreign Currency Valuation

Transaction Code FAGL_FC_VAL valuates open items in foreign currency as wells as the foreign currency balance sheet accounts.

In order to carry out a foreign currency Valuation, we need to make certain settings in the customizing:

  • Currency Customizing
  • Defining the Valuation Method
  • Defining the G/L account for exchange rate differences from the valuation.

We must also specify balance sheet adjustment accounts for receivable and payable accounts.

Customizing for FC Valuation in SPRO -> OB59 & OBA1.

Step1. Use Tcode OB07 to configure the Exchange rate type,

say B – Bank selling, G – Bank buying & M Average rate.

Step 2. Use Tcode OBBS to maintain a translation ratio for the 2 currency which you want to create, say USD : INR.

Here you will find direct quotation & indirect quotation according to your requirement you need to maintain.

Step 3. Use Tcode OB08 to maintain the Exchange rate, validity period of that exchange rate.

To record the profit & loss gained through the difference in exchange rate, you can do that through the following steps

1.Use Tcode OB59 to configure valuation method, in the screen check the check box valuate all the time & do the remaining settings.

2. create 2 G/L a/c 1 to record profit & other to record loss incurred through exchange rate, that should be auto posting.

3. Use Tcode OBA1 to assign those G/L to automatic posting.

Give your chart of account and 2 G/L you have created.

Step 4. Next use Tcode F.05 to execute the Forex Run.

Also See: Foreign Currency Revaluation F.05 Issue

Recommended Reading For You

  • How to Configure Foreign Currency Valuation – StepsHow to Configure Foreign Currency Valuation – StepsForeign currency valuation is to be done for preparing the financial statements at a key date.  Documents posted in foreign currencies have to be converted to company code currency for […]
  • Foreign Currency Valuation in SAPForeign Currency Valuation in SAPForeign Currency Transactions:There three types of Exchange rates defined by SAP,Bank Buying Rate Exports Purpose             – G Type Bank Selling Rate Import/Expenditure     […]
  • Foreign Currency Revaluation F.05 IssueForeign Currency Revaluation F.05 IssueAccording to FAS 52, transactions that result in a change in cash should go to the P&L account. In the case of a revaluation due to a timing difference(Monthend/yearend […]
  • SAP- AR & AP Interview QuestionsSAP- AR & AP Interview QuestionsSAP- AR & AP Interview Questions 1. At what level are the Customer & Vendor code stored in SAP?The customer and Vendor code are at the client level. That means any company […]
  • SAP Clearing in Local CurrencySAP Clearing in Local CurrencySAP Clearing in Local Currency Transaction OBY6 Effect of clearing in Local currency : Purchase USD 1000 at 1 USD = 2 SGD.The accounting entry in Local Currency […]

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: