Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Rounding qty_delivered in sale.order.line not consistent

Subscribe

Get notified when there's activity on this post

This question has been flagged
sale.order.lineroundingreturndeliveredodoo11
1 Reply
4570 Views
Avatar
rehan

hello guys i want to ask, in sale.order we have sale.order.line with qty_delivered, after i deliver the product the rounding is right it's always going up, but when i return the stock picking later in my total qty_delivered sometimes the rounding is going up and sometimes is going down,

like example: 

in sale.order i have a quotation for 1 cardboard of a product, in that cardboard, i have 24 bottles, but the quantity picked only 16 bottles so it will 16/24 = 0.6666 -> it will be rounded 0.667 (this is the right rounding) but later if i do return for 2 bottles the rounding is wrong, 16-2/24 = 0.583333 -> it should rounded to 0.584 but it always 0.583.. 

but if the quantity picked is 17 (it means 17/24) then i do return 3 of them it will make 14/24 then the result is what i expected, it's 0.584, why rounding isnt consistent?

please help me why it happened and how to make it consistent to always round "UP", thanks for the answer

0
Avatar
Discard
Avatar
Jake Robinson
Best Answer

I don't have access to code at this moment but I'd assume the rounding up is done per delivery line, not in total.

16/24 = 0.667

2/24 = 0.084

So (16-2)/24 = 0.667 - 0.084 = 0.583

Whereas 

17/24 = 0.709

3 / 24 = 0.125

So (17-3)/24 = 0.709 - 0.125 = 0.584

0
Avatar
Discard
rehan
Author

well, i guess you're right.. but how can i make it rounding for the total? i see the flow but it confusing me, since on stock.picking the calculation of qty_delivered when we click button validate (call button_validate method) when i track it I can't get the total of delivered value, im kind new of odoo

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

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

Sign up
Related Posts Replies Views Activity
Delivered Qty not updating
sale.order.line quantities delivered odoo11 odoo11community
Avatar
Avatar
Avatar
2
May 24
5002
[v8]How to show delivered quantity of products in sale order lines
sale.order.line delivered
Avatar
Avatar
1
Mar 15
4929
Sales Order Quantity Delivered Not Updating for Booked Timesheet Time
timesheet sale.order.line delivered
Avatar
0
Aug 23
2199
Why rounding in UoM always "UP"
rounding float UOM odoo11
Avatar
1
Dec 19
4345
How to make a single query instead of multiple query?
orm sale.order.line sale.order odoo11
Avatar
0
Feb 18
5157
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 ภาษาไทย 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