Foreign currency run

[former_member466848]

Hi All,

We have a situation where in we would like to valuate all documents on an account irrespective of document currency.

We have 3 currencies maintained in the system -- doc currency, company code currency and global currency.

Company code currency is CAD and global currency is USD.

The line items on the GL account receives postings both in CAD and USD as the document currency.

Say, the account has just 2 postings as given below:

Posting 1: 100 CAD (doc curr), 100 CAD (comp curr) and 95 USD (global curr)

Posting 2: 200 USD (doc curr), 210 CAD (comp curr) and 200 USD (global curr)

We want the F.05 run to valuate 310 CAD (total of comp curr) and 295 USD (total of global curr)

Is this possible?

Thanks,

Venkat

[Former Member]

Hello Venkat,

It is possible to do foreign currency valution as you expected if you are using ECC 5 or 6.

The year-end closing operations can be implemented for different legislative accounting standards, such as US GAAP or the German Commercial Code, which are based on different valuation approaches.

The different valuation approach is calculated and posted in the following programs:

Foreign currency valuation (SAPF100, RFSBEW00)

The programs can be run using an alternative valuation area. When the valuation of open items is made which affects the balance sheet, the differences are stored in a table (BSBW).

The additional valuation area must be created in Customizing for Financial Accounting. To do so, select the activity Define valuation areas in the Implementation Guide (IMG) for General Ledger Accounting.

You must then define the account determination for the alternative valuation areas in Customizing. To do so, define the account numbers for the expense or income from the valuation in the system. You do this under the activity Prepare automatic postings for foreign currency valuation in the IMG for General Ledger Accounting.

Hope this will help you.

Regards

Ravi

[former_member466848]

Unfortunately we are still on 4.7

Is there any way you can think of to find a solution for our issue.

I have used the FASB tab on F.05 and it does valuate all the documents, but when it does valuation on the USD documents, it posts a $0 to doc currency (USD) , $xx to comp currency (CAD) and $xx to global currency (USD).

In this case GL is correct since our financial statements are based on global currency but PCA is incorrect since $0 USD from doc currency is passed on PCA incase the doc currency is the same as PCA currency.

[Former Member]

Hi,

It will Valuate only items with Document Currency Different from Company code Currency.you can Tcode - F.05 if in Ecc5 above use FAGL_FC_VAl.

Surya