We need some help with setting up OpenERP to handle purchases in a foreign currency. I searched through all the answers and the documentation and I see no way to achieve what we have to be able to achieve, except for manually editing the product prices before we place the order to the supplier.
- Our base currency is TWD
- Supplier quotes us in USD
- We need to place a purchase order with the EXACT product prices in USD as quoted by the supplier, not approximate prices as generated through OpenERP currency conversion at a time.
How can we accomplish this without manual intervention and external price list lookup during each purchase order creation?
If there is a solution to this I will need exact step-by-step instructions as I believe that I have tried everything that is described in the documentation, old forum and this new Q&A platform and my current understanding is that it is not possible for OpenERP 7 to handle purchasing in foreign currency based on exact, supplier agreed prices, but only using approximate prices depending on the present base to foreign currency exchange rate. I am still expecting that this is not true as being unable to automatically generate valid purchase orders in a foreign currency would be a monumental oversight for any ERP system.
Here is a workable answer. I hope it helps everyone specifically looking for a solution to purchasing in a foreign currency using a fixed, pre-agreed price list.
Problem: OpenERP does not support purchasing in a foreign currency without involving exchange rate calculations. This results in invalid purchase orders as the prices on the purchase order are not what the supplier agreed to supply at. In addition there is no "elegant" solution for creating a fixed price price list as a workaround, however I found an inelegant but effective way to do it. Original solution can be found by searching for "How to set a fixed product selling price for a customer?" I cannot post a link to it since I am not worthy.
- Create a price list for the particular supplier in the currency of your choice
- Create a price list version to hold your individual product prices
Click on "Add item" and individually add each of the products you need to have a fixed foreign currency price and do this:
- Product = a product that you need to purchase at a preagreed foreign currency price
- Category = All products or anything that includes your product
- Based on = Cost Price
- New price = Base Price * ( 1 + -1 ) + YOUR FIXED PRODUCT COST IN THE FOREIGN CURRENCY AMOUNT
This pricing solution takes the "Cost Price" from the product page, sets it to zero and then adds your actual fixed product cost price in the foreign currency without exposing it to exchange rates or any other processing, allowing you to place valid purchase orders and print valid product cost lists.
Hello, I'm also looking for a solution how to manage purchasing in a foreign currency using a fixed, pre-agreed price list. I have tried Base Price * ( 1 + -1 ) + YOUR FIXED PRODUCT COST IN THE FOREIGN CURRENCY AMOUNT. It works but not convenient for large amount of items. I just found a possible solution which looks better.
- Setup a Purchase price list in required currency
- For this price list create a price list version
For price list version create a Rule. In this Rule you should choice a product category containing products with purchase price in required currency and choice Partner section of the product from Based on: .
For each product you should specify a supplier under Suppliers tab.
- In the Supplier information window click on "Add item" and add Quantity and Purchase Price in required currency.
Please check this solution and inform is it really OK for you.
It is possible to insert Supplier and Supplier price for each product via csv import or Kettle ETL. But currently I have no ready solution for that.
This is also one one my needs in openerp. I will test both proposed solutions and see which will be better for me to use.
Any of you have an additional solution/fix for this problem? Perhaps the multicurrency is arising additional problems. Any other you have noticed?
Thank you very much
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
|Asked: 6/18/13, 9:31 PM|
|Seen: 6074 times|
|Last updated: 9/15/15, 8:24 AM|