Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Artificial Intelligence
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Property Management
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

Pricelist Rules - Round off

Odoberať

Get notified when there's activity on this post

This question has been flagged
roundingrulespricelists
2 Replies
423 Zobrazenia
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
Zrušiť
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
Zrušiť
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
Zrušiť
Enjoying the discussion? Don't just read, join in!

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

Registrácia
Related Posts Replies Zobrazenia Aktivita
Odoo not creating child mo's
rules
Avatar
0
dec 25
24
Tiered discounts Solved
pricelists
Avatar
Avatar
1
apr 25
3202
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
5160
Charge % in pricelist based on Cost
pricelists
Avatar
Avatar
2
apr 21
5675
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة 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 je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

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