Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pricingcost_price
1 Odgovori
7121 Prikazi
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
Opusti
Avatar
Martin T
Avtor 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
Opusti
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 Odgovori Prikazi Aktivnost
How to specify variant prices
pricing
Avatar
Avatar
Avatar
Avatar
4
dec. 22
4521
Odoo Pricing Solved
pricing
Avatar
Avatar
Avatar
Avatar
3
avg. 22
7392
Choose the number of Users means? Solved
pricing
Avatar
Avatar
1
jul. 22
1697
pricing of modules not listed on pricing page
pricing
Avatar
0
jul. 21
1534
Cost Price for Variants
cost_price
Avatar
Avatar
1
apr. 21
3860