Foreign currency valuation

How to Configure Foreign Currency Valuation – Steps

Foreign 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 preparing the company financial statements.  Your company financial statement can include only those transactions which are posted in company code currency.

Hence all the postings which are open items and items which are posted in GL accounts with foreign currency have to be evaluated in company code currency.  Valuation is performed at the exchange rate on the valuation date.  In that way gain or loss is calculated and posted to exchange rate gain/loss accounts.

Configure Foreign Currency Valuation

Relevant Customizing for Foreign currency valuation in SPRO -> OB59 & OBA1.

1. Use Tcode OB07 to configure the Exchange rate type,
say B – Bank selling, G – Bank buying & M Average rate.

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.

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 boxvaluate 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.

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

Also See: What is General Ledger Planning in SAP?

Online Training Tutorials

  • Foreign currencyForeign 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     […]
  • Material Ledger ClosingHow 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 […]
  • foreign currency revaluationForeign 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 […]
  • DTD Interview QuestionsDTD Interview Questions and AnswersWe have listed of DTD Interview Questions and Answers that have been designed for DTD professionals who are preparing interviews on DTD.  The document type definition (DTD) is a set of […]
  • Benefits of New General LedgerList out the Benefits of New General Ledger in SAP?The new General Ledger in mySAP ERP has the following advantages over the classic General Ledger in R/3 Enterprise: Benefits of New General Ledger a) In the new General Ledger, you can […]
  • Python functionsPython functionsWe are able to create our own Python functions. Use the interpreter, generally, if you only need to do a calculation once. However, when you or others need to make a specific type of […]
  • SAP ECC 6.0Difference between SAP 4.7EE and SAP ECC 6.0 interms of Functional & TechnicalSAP 4.7EE and SAP ECC 6.0 : ECC means Enterprise Central component. SAP R/3 4.7 is based on the 3-tier architecture. SAP is continuously upgrading the software, which is called as release […]