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.

0

How to set up multi currency for purchases?

By
Victor Major
on 6/18/13, 7:47 AM 6,508 views

We are based in Taiwan. We buy from suppliers in EUR, USD and TWD, and RMB. How can I get OpenERP 7 to recognize this?

Current test setup:

  1. Base currency is TWD
  2. Purchase price lists are active in USD and TWD and are based on "Cost Price".
  3. In the currencies TWD is set to 1, USD is set to 0.033465

Test case: I have set up several products. 3 products are purchased in USD and under "Procurement" tab in the product view the Supplier is defined and assigned the USD Purchase Price List. I entered the "Cost Price" in the USD value.

One product is purchased in TWD thus under the "Procurement" tab in the product view a different Supplier is set up to use TWD Purchase Price List. I entered the "Cost Price" in TWD ie. the number I entered should be in TWD.

When I go to print the price list and select USD Purchase Price List (USD) the USD product costs incorrect. OpenERP converts all the values into USD using the conversion rate, even the USD costs.

Inversely when I print the TWD Purchase Price List (TWD) all the USD product costs are incorrect - the value correct, but the currency symbol is wrong.

My OpenERP setup regards all "Cost Price" values to have been entered in the base currency - TWD. From my understanding of the documentation and by reading the Q&A forum this does not appear to be the expected behaviour if appropriate price lists have been defined.

Thus, how can I set up multi currency support so that it actually works? How can I set up OpenERP 7 so that it performs the currency exchange rate conversions when appropriate, ie. do not convert USD to USD?

I am using OpenERP 7 on the nightly trunk.

@Victor,

Did you ever figure out a solution for this issue? I'm in almost the exact same boat. I need to purchase in multiple currencies and need to calculate cost-based pricing for all products (eg. cost + 30%).

Currently I can't figure out a way to do this in 8.0 or 9.0/Master. If you have time I would appreciate any advice or insight you can provide into working around this issue.

Luke Branch
on 4/15/15, 3:45 AM
0
Victor Major
On 4/16/15, 2:49 AM

Have a look at my second post here for a workaround that I used.

https://www.odoo.com/forum/help-1/question/how-to-purchase-in-foreign-currency-21642

0

Borni DHIFI

--Borni DHIFI--
5102
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 

http://www.linkedin.com/in/borni

Skype : dhifi.borni

Borni DHIFI
On 6/18/13, 8:05 AM

Thanks but if you read my question you'll see that I already did all this. Perhaps it is a bug that only appears during price list generation, but I am reluctant to commit product orders to the system to check if this incorrect multi currency behaviour is persistent as removing invalid orders from the system is hard to impossible.

Victor Major
on 6/18/13, 8:47 AM

...I just checked with an incomplete order and it is as I feared, the system is converting the product price that should be in USD, into USD. This makes it impossible to place an order. Surely this is a bug or I am missing something really critical somewhere.

Victor Major
on 6/18/13, 8:49 AM

I just found this Launchpad bug report. https://bugs.launchpad.net/openobject-addons/+bug/1081560?comments=all

If anyone from OpenERP looks at my question here, guys (non gender specific), this is an issue. This feature makes it needlessly complicated to conduct an international business where any products or services are billed in any currency other than the system base currency.

In the meantime can you please advise a step by step workaround so that we can in fact use multi currency for our purchasing without manually entering the prices before submitting the order?

Victor Major
on 6/18/13, 9:40 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

3 follower(s)

Stats

Asked: 6/18/13, 7:47 AM
Seen: 6508 times
Last updated: 11/19/16, 2:22 PM