F.05 foreign currency revaluation

[Former Member]

Hi All,

Please any body suggest me how the foreign currency revaluation works.

Once we run F.05 transaction means what it will do and which items it will pick and where it will post, and what is the realised gain and unrealised gain vice versa loss.

And why the tcode fb1s and what it will do.

I have one item there is no value in document currency and there is value in local currency2. due to this item there is a inconsistancy balance in F.08 GL balances, how can i correct it.

For knowing the above things please any body explain the process of foreign currency revaluation f.05. And appreciate if suggest the answer for the above issue.

Thanks in advance

Nandha

[former_member765905]

Hi Expert,

 Please any body suggest me how the foreign currency revaluation works.

This link will explain foreign currency revaluation works.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/91/5ac4402418742ae10000000a155106/content.htm

http://help.sap.com/saphelp_dimp50/helpdata/en/a6/004940f0030272e10000000a155106/content.htm

Once we run F.05 transaction means what it will do and which items it will pick and where it will post, and what is the realised gain and unrealised gain vice versa loss.

http://help.sap.com/saphelp_46c/helpdata/en/a1/61b60c142b11d3a6710060087d1f3b/content.htm

 And why the tcode fb1s and what it will do.

u2022 This transaction is used to clear open item managed general ledger accounts.

A similar transaction exists for customer and vendor account clearing.

u2022 If you have numerous items to clear, and prefer to deselect those that should not be included in the clearing document,

click and deselect Selected items initially inactive checkbox.

The transaction will then start with all items active (i.e. selected for clearing).

u2022 You can clear multiple items in one posting. The only requirement is that the sum of debits and credits equals zero, meaning the clearing document is balanced.

Field Description Tables

The R/O/C column of each Field Description table indicates whether the field usage is:

R - Required in SAP.

O - Optional in SAP.

C - Conditional in SAP.

Procedure

1. Double-click on Clear Open Items to go to the Clear G/L Account: Header Data screen.

2. Complete/review the following fields:

u2022 Account

u2022 Clearing date

3. Perform one of the following:

If Go To

You wish to specify a selection value range by selecting the options in the Additonal selections panel.

For example, you may only wish to review items which have posted in the previous month.

4. Select the radio button for the option for the open item filter you wish to enter, in our example Posting date.

Clear G/L Account: Enter selection criteria

5. As required, complete the following fields:

u2022 Posting date from

u2022 Posting date to

6. Click to go to the Clear G/L Account: Process open items screen.

7. Double click on the amount of the first open item in the GBP Gross column that you wish to clear.

The system will activate the line you have chosen, and the amount in the Assigned field in the Editing status panel will reflect all activated items. If the system shows a balance in the Not assigned field, then your clearing document is not in balance.

8. Select an offsetting item by clicking on the amount in the appropriate line.

Both items will now display as active, and the Not assigned field will show zero, indicating your clearing document is in balance and can be posted.

9. Click to post your document.

The system displays the message, "Document xxxx was posted in company code xxxx".

 I have one item there is no value in document currency and there is value in local currency2.  due to this item there is a in-consistency balance in F.08 GL balances, how can i correct it.

In the below link, Burak Uygur explained about the Foreign Currency Valuation

For knowing the above things please any body explain the process of foreign currency revaluation f.05.  And appreciate if suggest the answer for the above issue.

This link will explain the process of foreign currency revaluation..

http://help.sap.com/saphelp_erp60_sp/helpdata/en/91/5ac4402418742ae10000000a155106/content.htm

Regards,

GK

SAP

[Former Member]

Hi Nandha,

Find attached documentation and thread on this topic. This is would help you to have basic idea.

http://help.sap.com/saphelp_dimp50/helpdata/en/a6/004940f0030272e10000000a155106/content.htm

And about realised gain/loss and unrealised gain/loss; Unrealised gain/loss means gain/loss recorded temporarity due to the currency fluctuation.These are to reflect the currency fluctution temporarily in the Financial statements and usually reversed in the following month. Realised gain/loss are permanent entries posted for the currency fluctuation.

FB1S is to clear the gl accounts which are open item managed. Refer attached link for more info.

http://e-mory.blogspot.com/2007/05/sap-clear-gl-oi-fb1s.html

About the balance it local currency2, please check whether it is group currency balance.

Warm regards,

Murukan Arunachalam

Edited by: Murukan_A on Jan 10, 2012 8:11 AM