Hello, I am new here and trying to customise a product sheet on Odoo online, however I am running into an issue to extract the price without tax as my main price is tax included.
I am unable to find a way to extract either the price without tax, either the tax rate (taxes_id) as it is not a float but a many2many field, anyone could help me ?
The idea behind is that I added a extra field with ooo studio and need to calculate the value of the field using the price without tax.
Thanks
Hello Ingrid,
This is expected behavior in Odoo Online, especially when working with tax-included prices and Odoo Studio.
In Odoo, product taxes are stored in the taxes_id field, which is a many2many field because multiple taxes can apply to a single product. The actual tax computation (including extracting price without tax) is handled by Odoo’s internal tax engine using server-side Python logic (compute_all).
However, Odoo Studio formulas do not support iterating over many2many fields or applying tax engine logic. Because of this limitation:
You cannot reliably calculate price excluding tax in Studio when the product price is tax-included.
Accessing the tax rate directly from taxes_id for calculation is not possible in Studio.
Use Odoo’s standard untaxed values
Odoo already calculates untaxed amounts correctly on documents like quotations, sales orders, and reports.
Single fixed tax workaround (limited use case)
If only one fixed tax is always applied, you may use a manual formula (e.g. price / 1.18).
Please note this is only an approximation and not recommended for flexible or multi-tax scenarios.
Recommended (accurate) solution
A proper and scalable solution requires a small server-side Python customization using Odoo’s tax computation methods. This is only possible on Odoo.sh or On-Premise, not on Odoo Online.
So this is not a bug, but a functional limitation of Odoo Studio in Odoo Online.
If you would like help implementing a robust solution or exploring alternative approaches, CandidRoot would be happy to assist.
If this solution helped you, kindly upvote this answer.
Email: info@candidroot.com
Web: https://www.candidroot.com
Thanks, do you know how I can have the untaxed value as you mentioned in option 1 ? As my product price is tax included, I cannot find a field without tax on the product page. Thanks in advance
Maybe I'm missing something here, but you can extract the tax percentage from the sales tax (and the tax string)
Use the unit price field (price_unit) to obtain the sales price without added taxes.
Hi,
Hope it helps
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
What is the best practice of using Odoo Studio?
Diselesaikan
|
|
2
Okt 25
|
2449 | |
|
2
Mar 25
|
2635 | ||
|
3
Jul 24
|
5923 | ||
|
Copy Many2Many from Parent to Child Many2Many field
Diselesaikan
|
|
1
Jul 23
|
8462 | |
|
How to use self.env.cr.execute get my data?
Diselesaikan
|
|
2
Des 23
|
33804 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
In Odoo Online, the product form does not store a “price without tax”.
Even if your sale price is tax-included, Odoo calculates the untaxed value only on documents like Quotations, Sales Orders, and Invoices (Subtotal / Untaxed Amount).
That’s why you won’t find an untaxed price field on the product page.
Showing it there would require backend customization, which is not possible on Odoo Online (SAAS) But Yes, this requirement can be handled on Odoo.sh or On-Premise.
We can add a small backend customization that uses Odoo’s tax engine to calculate the price without tax correctly, even when the product price is tax-included and multiple taxes are applied.
Thank you for your answer, I am not looking to have multiple tax id, I am only looking for a way to extract the tax % of the product, so I can use it for a calculation. Do you know how I could extract the tax % out of the product page ?
Thank you in advance