0% found this document useful (0 votes)
202 views

SAP FICO F 05 Foreign Currency Valuation

1) The document describes the process for performing a monthly foreign currency valuation in SAP, which includes entering an exchange rate and valuating balances, open customer and vendor items, and general ledger accounts. 2) The valuation can be done in the local or parallel currency and uses a batch input session to create postings, which are then processed to post the accounting documents. 3) The tutorial walks through the steps to perform a foreign currency valuation for the period ending January 31, 2006 for company code 9100.

Uploaded by

jxrana7457
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
202 views

SAP FICO F 05 Foreign Currency Valuation

1) The document describes the process for performing a monthly foreign currency valuation in SAP, which includes entering an exchange rate and valuating balances, open customer and vendor items, and general ledger accounts. 2) The valuation can be done in the local or parallel currency and uses a batch input session to create postings, which are then processed to post the accounting documents. 3) The tutorial walks through the steps to perform a foreign currency valuation for the period ending January 31, 2006 for company code 9100.

Uploaded by

jxrana7457
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 12

COST CENTER ACCOUNTING

GENERAL LEDGER
END USER TRAINING DOCUMENTS

F.05 -

Functionality

At month end, you have to carry out a foreign currency valuation. This process valuates all
transactions posted in foreign currency. To perform the valuation you should enter an
exchange rate for the end of the month.
This valuation covers the following accounts and items:
1. Foreign currency balance sheet accounts –
2. Open items posted in foreign currency (Vendors and customers)

You have the following options for the foreign currency valuation:
a) You can carry out the valuation in local currency, (company code
currency),
b) You can valuate in parallel currency (for example, group currency).

You can also use different valuation methods (for example, lowest value principle).

The posting of valuation is done by a batch input session. It is recommended that you run
each valuation separately, for e.g. you will create a separate batch input for customer open
items, then another one for vendors and another one for GL.

Scenario

At every month end closing (where balance sheet and profit & loss account is reported
monthly) you need to perform a foreign currency valuation for GL, customer and vendor
open items.

Requirements

GL, Customer and Vendor Master, the accounting transactions posted in foreign currencies
(different than company code currency). Configuration done for foreign currency valuation.

Menu Path Accounting → Financial Accounting → General Ledger →


Periodic Processing → Closing → Valuate → F.05 - Foreign
Currency Valuation
Transaction Code F.05

1. Double click on F.05 - Foreign Currency Valuation.

SAPTOPJOBS Page 1 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

Foreign Currency Valuation

2. Update the following fields:

Field Name Field Description Values


Company code Company code 9100
Evaluation Key Date Key date for the foreign 31.01.2006
currency valuation.
Valuation method A unique key for determining a ZDCR
foreign currency valuation
method. This key can be valid
for cross-chart of accounts.
Batch input session Code identifying the batch FCV012006
name session that is created
Document date Date the transaction occurred 31.01.2006
Posting date Date that the business 31.01.2006
transaction occurred

SAPTOPJOBS Page 2 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS
Field Name Field Description Values
Posting period Fiscal month when the 1
transaction posts to the General
Ledger
Reversal posting date Date when you want to post a 01.02.2006
reverse. Normally the 1st day of
next month

3. Now you need to select the accounts you want to valuate. Click <tab button>

SAPTOPJOBS Page 3 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS
Foreign Currency Valuation

4. Click Valuate vendor open items .

5. Click Valuate customer open items Button .

You can select only particular vendor / customer accounts to be valuated. If you leave the selection
fields empty (like in our example), all the accounts will be selected for valuation.

6. Click Execute Button to perform valuation. Note that the system does not create
the postings immediately but creates a batch input session instead.

SAPTOPJOBS Page 4 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS
Foreign Currency Valuation

Note: The system displayed a report presenting valuated vendor and customer
open items. Press POSTINGS Button to display the accounting
documents that were created. These documents have not been posted yet; they’re
stored in a batch input session:

SAPTOPJOBS Page 5 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS
Foreign Currency Valuation

7. Click Back Button .

8. To post the valuation, you need to process the Batch Input Session that you’ve just
created. You can open another SAP session. From the main menu choose System
 Services  Batch input  Sessions

SAPTOPJOBS Page 6 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

SAPTOPJOBS Page 7 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

Batch Input: Session Overview

9. Select the session you want to process. (Select the row which contains your Batch
input session, e.g. FCV012006)

10. Click Process .

SAPTOPJOBS Page 8 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

11. Click <radio button>

12. Click Process Button to begin posting of documents.

13. As a result of valuation some accounting documents were posted. To display them
use the transaction FB03 (Document Display):

SAPTOPJOBS Page 9 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

Display Document: Initial Screen

14. Update the following fields:

Field Name Field Description Values


Document number Number of the SAP R/3 100000020
document that is internally
assigned by SAP R/3 when
certain transactions are
completed
Company code Enter here company code 9100
number
Fiscal year Fiscal year number 2006

15. Click Enter Button to confirm your entries.

SAPTOPJOBS Page 10 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

Display Document: Overview

Note: The above document shows zero balance because is displayed in Document
currency.

16. To display your document in local currency Click Display currency Button
.

SAPTOPJOBS Page 11 of 12
COST CENTER ACCOUNTING
GENERAL LEDGER
END USER TRAINING DOCUMENTS

17. Click Enter Button.

Display Document: Overview

18. Click Back Button .

SAPTOPJOBS Page 12 of 12

You might also like