Odoo Help

Welcome!

This community 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.

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,278 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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