Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
163 Widoki

Hi everyone,

We’re still struggling to find a proper way to handle our pricing workflow in Odoo:


We purchase products in EUR from suppliers, and want to sell in NOK with a fixed markup of 58% on the purchase price. Ideally, we want Odoo to automatically convert the EUR cost to NOK using the current exchange rate, and then apply our 58% markup to determine the sales price.


Right now, the only workaround we’ve found is to create a pricelist with a 2785% markup on product cost to simulate the conversion rate and profit margin. As you can imagine, this is far from ideal or sustainable.


Is there any better way to convert cost from EUR to NOK and add a fixed margin in Odoo?

Maybe a custom pricelist rule, or a module that handles currency-based markups properly?

Odoo version 18.3+e

Would appreciate any tips or real-world solutions!

Awatar
Odrzuć
What happened to my post? It vanished???

--
Best Regards,

Inge Eidem
Daglig leder

Zummit AS
Visiting address: Solvegen 16, 2213 Kongsvinger
Norway
Phone: 41409030

19. aug. 2025 kl. 12:11 skrev JB <notifications@mail.odoo.com>:

A new question Multi currency EUR -> NOK + Markup on Help has been posted. Click here to access the question : See question ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​ ͏ ​

A new question Multi currency EUR -> NOK + Markup on Help has been posted. Click here to access the question :

See question

--

--
john


Najlepsza odpowiedź

Just some extra specification to add from what cybrosys wrote.

Standard process: Set  Product costing should as FIFO or AVCO.  You set it on the product category.  Product cost will then be updated in company currency on each purchase. (On goods receipt and adjusted with the invoice).  Currency rate for goods receipt will be the date purchase order and for the invoice the date of the invoice.  You can follow the cost calculation on report Inventory->Reporting->Valuation.

I assume you have activated automatic update of currency rates.

Price lists are defined by currency. You set it default on partner, and can modify on sales order. It determines the currency on the sales order. When you sell in a different currency than company currency, the cost and price will be converted into price list currency.

In the price list set Price Type by formula. Base price = cost and Markup = 58%

The currency rate used will be the latest available of the sales order / quoation entry date. Most often you will see the rate from yesterday.

It works.  But be aware the risk with currency rate, when you purchase and sell in other currency than company currency. The currency rate on sale will be different from purchased.


Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

Odoo does not natively handle cross-currency cost-based pricing with markups, so the cleanest solution is to use the standard pricelist formula "Based on → Cost" with a 58% markup, but extend it slightly with a small custom module or community app that first converts the cost from EUR to NOK using Odoo’s daily exchange rates, then applies the markup. This way you keep your cost in EUR, let Odoo handle currency conversion automatically, and avoid hacks like 2785% markups.


Refer to the following.


App


* https://apps.odoo.com/apps/modules/18.0/exchange_currency_rate


Documentation


* https://www.cybrosys.com/blog/how-to-manage-multi-currency-and-currency-rates-in-odoo-18-accounting

* https://www.odoo.com/documentation/18.0/applications/finance/accounting/get_started/multi_currency.html#:~:text=Each%20account%20can%20have%20a,handled%20instead%20of%20just%20one.


Video


* https://www.youtube.com/watch?v=q5fAVs64Xxc


Hope it helps

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
0
maj 23
1366
1
mar 23
1936
2
sty 22
3177
0
lip 21
2903
8
maj 20
5852