Odoo Help

1

Is Foreign Exchange Inventory Valuation based on Purchase Date or Today's Rate?

By
Adam Abraham Rumjahn
on 7/26/15, 4:05 PM 1,845 views

I am deploying Odoo V9 in Colombia and am entering my inventory (purchased in USD) that I have had since the beginning of 2015. I have already enabled multi-currency and imported the USD/COP exchange rates for every day in 2015.  

Let's say I enter a retroactive Purchase Order for PRODUCT1 for June 1, 2015.  I would expect that Odoo calculates the Inventory Valuation using the exchange rate on June 1, 2015, but rather it seems to use the most recent exchange rate available (say Dec 31, 2015 in this case).  

Is this right?  Q: Is my inventory valuation for everything supposed to be based on today's exchange rate? or is it supposed to be based on the exchange rate of the purchase date?

This doesn't seem right and according to this article it should be based on the purchase or BS date:
http://www.accountingweb.co.uk/anyanswers/valuing-stock-year-end

If anyone can clarify how I can remediate this situation and retroactively enter foreign purchases with the correct exchange rate it would be very helpful.

Thanks,

Adam



I'm also looking for a solution...

Alain Vanzella
on 8/13/15, 8:42 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 7/26/15, 4:05 PM
Seen: 1845 times
Last updated: 1/14/16, 6:54 PM