Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Artificial Intelligence
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Property Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč
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
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
Pomoč

Pricelist Rules - Round off

Naroči se

Get notified when there's activity on this post

This question has been flagged
roundingrulespricelists
2 Odgovori
427 Prikazi
Avatar
Luc Bernard

Hi!

Is there a way to apply the Pricelist Rules' 'Round off to'-rule to the price including VAT when the system is set to manage prices excluding VAT?

With Standard user, so without Studio.

Thanks.

0
Avatar
Opusti
Avatar
Zack B
Best Answer

Hi Luc,

Agree with Sandeep — standard pricelist “Round off to” runs on the tax-excluded amount when prices are managed excl. VAT, so you can’t get “always .99 incl. VAT” from the UI alone.

If you need gross rounding without Studio, it has to be custom logic, roughly:

  1. Compute the price the customer should see incl. VAT (from your rule / base price).
  2. Round that gross amount the way you want (.99, whole euro, etc.).
  3. Back-calculate the tax-excluded unit price: net = gross / (1 + tax_rate) — watch fixed/percent taxes and fiscal positions if rates change per partner or product.
  4. Store/use that net on the line so Odoo’s normal tax engine still runs consistently.

Where to hook it depends on scope:

  • Sales orders: override or extend how the line unit price is computed from the pricelist (after pricelist rules, before or inside tax computation — be careful not to fight _compute_price_unit / pricelist application twice).
  • POS: separate path — POS has its own price/tax flow, so don’t assume SO logic carries over.
  • Website: if eCommerce uses pricelist, same issue — shop may show excl. or incl. per config; rounding intent should match what the customer sees.

Edge cases to plan for:

  • Multiple taxes on one product
  • B2B partners with different fiscal positions
  • Discounts / formula rules applied before vs after rounding (define order of operations in writing)
  • Rounding per line vs per order total (Belgium/retail often cares about display price incl. VAT per unit)

So: not supported standard, Studio won’t fix the math, small custom module or inherited model method is the realistic route.

If you share Odoo version (14/15/16+) and whether this is SO, POS, or website, someone can point to the exact method to inherit — the pattern is the same, the hook differs.

0
Avatar
Opusti
Avatar
Sandeep Paulraj R
Best Answer

No, this is not supported by Odoo's standard Pricelist configuration.

The "Round off to" option in Pricelist Rules is applied to the computed price before taxes are added. When your company is configured to manage prices tax excluded, the rounding logic operates on the tax-excluded amount and does not take the VAT-inclusive price into account.

For example:

  • Base price: 99.17

  • VAT: 21%

  • Price with VAT: 120.00

If you apply a round-off rule, Odoo rounds the 99.17 amount first, then computes VAT on the rounded result. It does not round the final VAT-inclusive price.

To round the VAT-inclusive price (e.g., always ending with .99 including VAT), you would need a customization that:

  1. Calculates the tax-inclusive price.

  2. Applies the desired rounding.

  3. Recalculates the tax-excluded price accordingly.

This cannot be achieved through standard Pricelist Rules alone, and Studio would not be sufficient for this type of pricing logic either. A custom module would be required.

0
Avatar
Opusti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
Odoo not creating child mo's
rules
Avatar
0
dec. 25
24
Tiered discounts Solved
pricelists
Avatar
Avatar
1
apr. 25
3205
Missing Advanced & Multiple Pricelist functions Solved
pricelists
Avatar
Avatar
1
nov. 24
3568
Assign pricelists to a group of customers Solved
pricelists
Avatar
Avatar
1
mar. 24
5161
Charge % in pricelist based on Cost
pricelists
Avatar
Avatar
2
apr. 21
5676
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now