Skip to Content
This question has been flagged
pricingcost_price
1 Reply
7898 Views
Avatar
Martin T

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?

Avatar
Discard
Avatar
Martin T
Author Best Answer

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.

Avatar
Discard
Evelynn

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

Luke Branch

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

Related Posts Replies Views Activity
Is there a difference between minimum quantity of 1 and a minimum quantity of 0? Solved
pricing
Avatar
Avatar
Avatar
2
Jul 25
1594
How to specify variant prices
pricing
Avatar
Avatar
Avatar
Avatar
4
Dec 22
6499
Odoo Pricing Solved
pricing
Avatar
Avatar
Avatar
Avatar
3
Aug 22
9576
Choose the number of Users means? Solved
pricing
Avatar
Avatar
1
Jul 22
2792
pricing of modules not listed on pricing page
pricing
Avatar
0
Jul 21
1735