Skip to Content

Calculation Logic for Purchase Price and Exchange Rate Variance during Invoice

Mar 22, 2017 at 03:10 PM


avatar image

Hello Friends,

I need your kind help in understanding purchase price and exchange rate variance postings getting generated at the time of Invoice Receipt for Purchase Order.

Here is the scenario:

PO is created in foreign currency EUR and the local currency is JPY.

PO Quantity 60,000 GR/IR Quantity 60,480 EUR/JPY 121.799 GR Date EUR/JPY 119.717 IR Date Std Price 73.061 JPY PO Price 0.517 EUR

Here in the screenshot 1, I am trying to understand the amounts derived during Invoice Receipt (highlighted fields 6 and 7)

I have included basic information which would be needed for some one to guide me.

Please let me know if you would need any further inputs.

Prompt responses would be very much helpful and appreciated.

Thank you!

Warm Regards,


1.png (25.1 kB)
2.png (24.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mehul Mandge Mar 28, 2017 at 04:07 AM

Hello Friends,

No responses received yet, any pointers will be helpful.

Thank you!

10 |10000 characters needed characters left characters exceeded