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:
- Base currency is TWD
- Purchase price lists are active in USD and TWD and are based on "Cost Price".
- 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.