This question has been flagged
6 Replies
14268 Views
Avatar
Victor Major

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.

Avatar
Discard
Luke Branch

@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.

Avatar
Victor Major
Author Best Answer

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

Avatar
Discard
Avatar
Borni DHIFI
Best Answer

Hi,

https://accounts.openerp.com/forum/Help-1/question/20358#20417

https://accounts.openerp.com/forum/Help-1/question/6258

Avatar
Discard
Victor Major
Author

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
Author

...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
Author

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?