Foreign currency revaluation for non open item account

[former_member424291]

Hello,

we are executing F.05 foreign currency revaluation. Our company code currency is CAD. Now we have an account which having currency as CAD (company code currency) and is NOT ticked as "Balance in Local currency" and this account is NON-Open item managed

now there is a posting to this account with a foreign currency ie USD. My question is will this account be considered in Revaluation program. Currently the program is revaluating this entry but as per the client,This is a Non-OI account and its balance should be taken all as pool in CAD. Foreign currency entries in a NON-OI account denominated in CAD account cannot be cleared and should not be revalued.

Please suggest.

Regards,

Zulfikar

[former_member424291]

We are using ECC.

[former_member513101]

Hi Zulfikar,

Your client is right, This non-OI account in local currency should not be include in Forex Reval. The good example is Main bank account. You only evaluate forex for those main bank account in foreign currency.

Even though you have scenarios to make payment with CAD main bank account for USD invoice. Forex reval is not needed for main bank bank in local currency.

Thanks

[former_member424291]

Hello Lam,

Thanks for the clarification. Now I am clear on the revaluation part. I have to remove this account from the selection parameter.

I have one more query on Translation (Ie Translation of open item from company code currency to group currency).

Translation converts your local currency account balance to group currency using currency type 30 in the selection parameter

We have an account which is open item managed and have account currency as Company code currency. WE have 2 open item in this account one with foreign currency posting USD and second document posted in local currency. CAD.

When we execute translation using currency type-30 the system pick only that line item which is posted in CAD currency not the other document posted in foreign currency.

Please suggest.

Regards,

Zulfikar

[former_member513101]

Hi Zulfikar,

When you evaluate forex against company code currency, System will select those posted line item in foreign currency. whereas when you evaluation forex against group currency USD (translation), system will select posted line item other than USD.

Thanks.

[Gustavo_Vazquez]

Hi Zulfikar,

Yes, it will be revaluated as balance account. You could exclude account from the parameters in F.05.

Are you using ECC 6.0 or S/4 HANA ? This is because the tags you used.

Kind Regards