Ex. rate diff accts are incomplete for account XXXXXX currency USD

[Former Member]

Experts,

I am getting this error when i am trying to clear some open items of a vendor of a particular co cd.

The Co Cd currency is CAD and the Group Currency is in USD - The open items which i am clearing are all in CAD and the clearing currency is also in CAD.

The Account currency of XXXXXX as well as for the account with which i am clearing it is CAD

So i am not sure why i need to mention any acct for ex rate diff.

Anyways, i did go to OB09 and entered the g/l acct XXXXXX and USD as currency and currency type as 10 , but that didn't help either.

Any ideas how i can over this error ?? All answers would be duly rewarded with points.

Thanks,

Nandita

Message was edited by:

Nandita

[Former Member · Accepted solution]

Hi,

If the Compant Code currency, Vendor invoices posted and clearing are all in CAD - there should not be any foreign exchange gain / loss. Hence, no need to maintain any foreign exchange gain / loss accounts.

However, if the Vendor invoices are posted in a different currency (transaction currency is different Eg. GBP), you need to main accounts to post foreign exchange gain / loss.

Thanks

Murali.

[Former Member · Accepted solution]

Murali,

I just checked the docs of the open items and it says that the doc currency is USD - so i guess i have to maintain accounts for foreign exchange gain/loss account.

I went to OB09 and defined this:

Acct : XXXXXX

Currency : USD

Currency Type : 10 ( Co Cd Currency - CAD)

But i still get the error - Any idea??

Thanks,

Nandita

[Former Member · Accepted solution]

Whats the error message ??

Kalyan

[Former Member · Accepted solution]

Kalyan,

The error is Ex rate diff. accts are incomplete for account XXXXXXX (Vendor Recon Account) currency USD ( Group Currency)

Thanks,

Nandita

[Former Member · Accepted solution]

Murali,

As the document currency is USD, i thought of clearing it in USD , but i still got the error.

Of course the Co Cd currency is CAD and Account Currency is CAD - Do i need to still mention the exchange rate diff account ?

Thanks,

Nandita

[Former Member · Accepted solution]

Hi,

You need to maintain the accounts to post the exchange rate gain or loss.

Thanks

Murali.

[Former Member · Accepted solution]

Murali,

This is what i did to configure the account for exchange rate difference :

Went to OB09 and then clicked on a new entry and entered the vendor recon account XXXX in the G/L account field and entered USD in the currency field and entered currency type 10 ( Co Cd currency - CAD) and

entered a diff account in the Loss/Gain fields of Exchange Rate Diff realized.

However i am still getting the error.

Are my settings correct - Do i need to enter CAD in the currency field instead of USD ??

Can you please let me know.

Thanks,

Nandita

[Former Member · Accepted solution]

Hi,

In OB09, please leave currency and currency type blank.

Thanks

Murali.

[Former Member · Accepted solution]

Murali,

Thank you - that worked out.

However i have one question - Is there anyway to clear accounts like the way we clear vendors with f-44 ?

Once again, thanks for your help.

Nandita

[Former Member · Accepted solution]

Hi,

You can use transaction code F-03 to clear open item managed GL Accounts. You can also use transaction code F-04 post with clearing.

Thanks

Murali

[Former Member]

In clearing open items, the system posts any realized gains or losses (realized exchange rate differences). You therefore need to define gain and loss accounts.

To automatically post exchange rate differences when clearing open items, you have to specify the reconciliation accounts for customers and vendors in the "G/L account" field. If, for example, you want to clear a foreign currency open item on the debit side, you have to enter a receivables account in the "G/L account" field.

What is most important in this activity is that you define accounts for realized exchange rate differences. Otherwise, you cannot post items in foreign currency.

You can define accounts for each type of currency. The system will then post exchange rate gains or losses from each currency to separate accounts.

Please also check out the foloowing link:

http://help.sap.com/saphelp_47x200/helpdata/en/01/a9b9a6455711d182b40000e829fbfe/frameset.htm

Hope this helps.

Please assign points as a way to say thanks.

Regards,

[Former Member]

Hi Nandita,

Check Exchage rate table (TCURR)

I think Exchage Conversion rates are not specified.

Go to SM30, enter v_tcurr to change / update the table.

I think check in the table if the currency conversion rates are specified for clearing date which you are posting to.

Else please let us know the exact error message. So that we can help you out.

Kalyan