Exchange Rate Differences between INVOICE and GOODS RECEIPT

[Former Member]

Dear Experts,

Grant Management module enable us to use a different CURRENCY per each grant,

We found out, In some cases, Records originted from IV are not posted expressing the exchange rate as we expect.

Since all PO's are marked as "GR based";

The GR is REAL posted and the IV is STATISTICALLY posted.

as well as differences between IV and GR are REAL posted.

We found out that in a case that the GRANT currency is different than the GR currency, and is not a local currency,

than-

Exchange rate Differences between IV and GR are yet ATATISTICALLY posted and NOT real posted as we should expect.

For example -

PO/GR CUrrency =EURO

GRANT CURRENCY = USD DOLLAR

IV Currency = ILS (local Currency)

GR AMOUNT= 12,036.00 EURO ( GR/ PO CURRENCY)   / 52,487.79 ILS (LOCAL CURRENCY) / 13,686.52 USD (GRANT CURRENCY),

IV AMOUNT = 52,487.79 ILS (DOCUMENT CURRENCY) / 13,661.58 USD (GRANT CURRENCY)

In Grant Management balance -

IV amount is STATISTICALLY posted,

GR amount is REAL posted

The problem in the above example is that the diiference between GR and IV in GRANT CURRENCY is NOT real posted.

So that the GRANT balance is incorrect.

Anyone has an experience with this issue or has any idea for a solution?

Thank you and regards,

Orly

[sjajodia]

Hi Orly

How have you classified the exchange difference account in the Update Settings under Grantee Management> Global Settings?

Thanks

Shyam

[Former Member]

Hi Shyam,

Thank you for your answer,

I did not classify the exchange rate,

how should I classify the exchange rate differences under Grantee Management> Global Settings?

Thank you !!

Orly

[sjajodia]

Orly,

Typically this would be an expense account. The value type would be 99, grant would be derived and you can set the Real Posting indicator.

Thanks

Shyam

[Former Member]

Hi Shyam

This case is different-

That is since the EXCH.RATE difference is in GRANT CURRENCY only,

NOT company code currency,

hence--->EXH RATE is not posted to FI ------> since GM is affected by FI , it is not posted to GM as well.

I do not know how to configure this, maybe OMRW??

Thanks

Orly