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 calculatie cost price in a multi-currency company with OpenERP v7?

By
Martin T
on 1/1/14, 9:56 AM 1,733 views

Dear members,

I have the following situation.

The Company is trading goods in euro's. Some products are purchased in Dollars (imported from USA) So the company is multi-currency in openerp V7

So ideally my cost price =

cost price (euro's) = base price from product form (in $) - 5% (discount) + import taxes(6%) + 2.5% (interest).

salesprice (euro's) = cost price + 40%.

Because the cost price is in euro's I need to calculate the cost price with the exchange rate of that moment. (The exchange rate is automatically fetch every day with the use of the exchange module).

How can I use the price lists for this, and how do I have setup these in this way?

0
Martin T
On 1/2/14, 4:02 AM

Ok, I'm a little further.

I have successfully edited the product.product object and the corresponding form, and extend this with an extra field (Cost in Dollars). Here I can now enter the cost price (base-price - discount+import duty) in dollars.

I have also made an extra price list (in USD) for these products. This price list is based on the "Costs in Dollars" field (which I have add to the product form).

The price list in Euro has a priority rule to check the price list in USD.

Now this seams to work :-)

I still have to test, if accounting is oke.

I'm a bit in the same situation and also looking for a solution...I want to calculate a sales price based on the supplier price on product form (which can be USD or any other currency).That minus the Discount % I get from the supplier.Then I want it to do the calculation on the conversion to euro (a). I want to calculate a margin (b) adding on this price. After that I want to add a percentage for Import (c), based on the first netto conversion price in euro, And I want to add a percentage for Transport (d) also based on the first netto conversion. My sales price must be built up by: a+b+c+d

Evelynn
on 1/9/14, 5:24 AM

@Martin T,

I'm in the same boat, I have multiple cost price currencies that I need to calculate sales price on:

TWD
USD
HKD
CNY
and preferably the option to have whatever base cost currency I need for a particular product.

If you have time i'd appreciate any insight or advice you could provide on the topic, as I am working with 8.0 and 9.0/Master and have run into a bit of a roadblock with this particular issue.

Luke Branch
on 4/15/15, 3:52 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

1 follower(s)

Stats

Asked: 1/1/14, 9:56 AM
Seen: 1733 times
Last updated: 3/16/15, 8:10 AM