SAP® Documentation

Single view

/CEECV/RO_SAPF100 - Foreign Currency Valuation

Vendor Master (General Section)   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Description

This program carries out the foreign currency valuation.

The following items/accounts are valuated:

  • Open items
  • Foreign currency balance sheet accounts. This means G/L accounts that are managed in a foreign currency.

You have the following options for the foreign currency valuation:

  • You can carry out the valuation in local currency or a parallel local currency (for example, group currency).
  • You can use different valuation methods (for example, HGB or US GAAP).

The result of the valuations can be stored per valuated document and posted to adjustment accounts and P&L accounts.

Valuation process

Selection

  • Open items:
The customer, vendor, and G/L account open items on the key date are read and balanced by account or group and currency.
  • G/L account balances:
Reconciliation accounts and accounts managed on an open item basis are not valuated. P&L accounts are only valuated as required: See also: "FASB 52 Translation".

Grouping

The documents or balances are balanced by currency and account (or group/valuation group). The exchange rate type for the valuation is determined from this balance.

Valuation

  • Open items:
The items that are untranslated at the key date are summarized per invoice reference or account/group.
If the result does not correspond to the method selected, for example, if a profit arises using the lowest value principle, no valuation difference is output.
  • G/L account balances:
The balance is translated per currency and account/group on the key date. The valuation difference determined is compared with the valuation method specified (for example, lowest value principle).

Posting

The valuation differences are posted compressed. The accounts are determined using the valuation area selected.

The following postings may arise from the open item valuation

  • Valuation posting
  • Reset all valuation postings if the valuation does not affect the financial statements.
  • Always applies for GR/IR accounts

  • When using alternative valuation areas

  • Reset old realized differences (open items already cleared, for example) for a valuation that affects the financial statements.
  • Post new realized differences (open items already cleared, for example) for a valuation that affects the financial statements.

The balance valuation postings can be reversed if required.

Document change

The valuation differences are saved in the documents if a valuation that affects the financial statements is being carried out.

  • For items that have already been cleared, the new realized difference determined is saved in the document.
  • The difference is not saved for GR/IR accounts, since clearing does not reset the valuation. An update is only carried out if you use alternative valuation areas here.

Requirements

Before you can carry out a foreign currency valuation, you have to make setttings in Customizing. You can find these settings in Customizing for Financial Accounting under General Ledger Accounting -> Business Transactions -> Closing -> Valuate -> Foreign Currency Valuation.

  • You should have already defined your valuation methods. To do this, choose Define Valuation Methods.
    Proceed
  • You have defined the accounts for the expense and the revenue from the valuation in the system. For receivables and payables accounts, you also have to define the numbers of the financial statement adjustment accounts. To do this, choose Prepare Automatic Postings for Foreign Currency Valuation.
    Proceed

You should also check that you have made the following settings:

  • Check whether you have defined an exchange rate for each foreign currency.
  • Check whether you have defined the posting keys for the adjustment postings.
  • If you want to use an alternative valuation area, check whether the following settings exist:
  • Check whether you have defined the alternative valuation area.

  • Check whether you have defined the account determination for the alternative valuation area.

  • When you are valuating tax accounts and then carrying out postings, you have to post using a tax key. This tax key however, should not appear in the reporting for tax on sales/purchases. To do this use the assignment "Company code -> Non-taxable transactions".

Output

The output is in three lists:

  • - List of valuated line items or G/L account balances
  • - List of postings, or postings proposed
  • - List of messages (own spool file)

Example

Example for valuation postings

An invoice for 100 USD is posted using the local currency 170 DEM.

On the key date, the item is valuated using an exchange rate of 1.50. A valuation expense of ( 150 - 170 ) 20 DEM arises. This is posted as follows:

Expense acctto FS adjustment accountat key date
23001014009920 DEM

  • Valuation that affects the financial statements
For a valuation that affects the financial statements, the valuation difference is noted in the item. The valuation difference is cleared when the invoice is cleared.
  • A valuation that does not affect the financial statements
For a valuation that does not affect the financial statements, all postings are reversed at the reverse date. You can enter a special period as the reversal period.
Expense acctto FS adjustment accountat key date
23001014009920 DEM
Reversal
14009923001020 DEM

Example: Valuation of an invoice that has already been cleared
(affects financial statements)/without alternative valuation area.

If the item was cleared after the key date, the valuation postings for these items are adjusted by the report:

  • The realized exchange rate difference is reset
  • The new difference is posted to the expense/revenue account for realized exchange rate differences.

Background

The total saved for realized and unrealized differences is required by the subsequent programs (SAPF180, SAPF181).




Invoice 100 USD 160 DEM (RDIFF = 3-DEM)
Payment 100-USD 160 DEM Customer
100 USD 157 DEM Bank
3 DEM Realized exchange rate difference

Valuation at 1.56
Valuation posting 4 DEM Valuation loss
Valuation posting 4-DEM Adjustment account
Reversal posting 3 DEM Adjustment account to
Reversal posting 3-DEM Realized exchange rate expense
Reversal posting 1 DEM Adjustment account to
Reversal posting 1-DEM Realized exchange rate revenue


The new realized difference (+1)is noted in the item in the field
RDIFF, field BDIFF displays the valuation difference (-4).

Additional notes

Carrying Out the FASB 52 Translation

Valuation in local currency
In the first step, the foreign currency items and balances are valuated and posted to P&L accounts in the local currency. In addition, the valuation difference is translated into the group currency and posted.
The parameter "Carry out translation" is selected.

Open items
The local valuation difference is saved per item, and the difference translated in the group currency is stored in an additional valuation area.

G/L account balances
Valuate all accounts (including P&L accounts) in local currency.
For depreciation accounts, only valuate the current period.

Currency translation
In the second step, the translation of the valuated local currency amount into the group currency is carried out. Define where the valuated local currency amount comes from; either from the currency type, or from a valuation area. The parameter "Translation" is selected. The translation carries out the valuation of the (valuated) local currency amount in the group currency.

Example for open items:

Three valuation areas are used.

  • RE FC valuation - currency type 10. This is used for the foreign currency valuation account determination and storing the local difference.
  • RT Difference in group currency (30). This saves the translation difference from the translation from local into group currency from the first step (foreign currency valuation).
  • TR Translation - currency type 30. This is used for account determination and can - but does not have to - contain the translation differences.

Process

1) Invoice: 1,000 FRF 290 DEM 181.25 USD (exchange rate DEM/USD 1.6)

2) Valuation of 1,000 FRF results in a valuation
difference of 10 DEM and 6.25 USD (10 DEM translated into USD)
Post in valuation area RE 10 DEM and 6.25 USD
Save 10 DEM in valuation area RE
Save 6.25 USD in valuation area RT

3) Translation: Valuation of valuated local currency amount in group
currency
Local balance: DEM 300 (290 DEM + 10 DEM from valuation area RE)
Group balance: USD 187.5 (181.25 USD + 6.25 USD from valuation area
RT)
Valuation at 0.5 results in a difference of 37.50 USD
( 150 USD - 187.50 USD = 37.5 USD)

Transaction in first local currency DEM
Receivables 290 DEM
Adjustment account 10 DEM
Exchange rate gain -6.25 USD

Transaction in second local currency, USD
Receivables 181.25 USD
Adjustment account 43.75 USD
Exchange rate gain -10 USD
Equity +37.50 USD






SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Material Data  
This documentation is copyright by SAP AG.

Length: 12062 Date: 20191024 Time: 011457     sap01-206 ( 584 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.