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

Product Unit of Measure Ratio Issue. Odoo creates unnecessary Backorder

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventorybomUnit of Measure
3 Replies
6498 Views
Avatar
Nihat Demir

Hi

I create Bottle of Drink 750ml product with UOM Bottle 750ml (see below). Then created Glass of 250ml product which will be using Bottle of Drink 750ml in the BOM (see below). Issue is if I make sale of Glass 250ml and check SALES ORDER and Delivery Order RESERVED Quantity doesnt not match with Initial Demanded Quantity. (see below) I think Bottle 750ml Unit of Measure ratio is the issue here. Therefore, Odoo ask to create BACKORDER because of not matched quantities. (see below). question is 

HOW CAN I MAKE RESERVED QTY (997.50ml) SAME AS ORDERED QTY (1000ml) AND NO BACKORDER CREATED?





HERE IS THE SALES ORDER and DELIVERY ORDER LOOK LIKE.







0
Avatar
Discard
Avatar
Nihat Demir
Author Best Answer

I configured the UOMs as you mentioned. ml is reference and 250ml, 750ml bigger than Reference UOM. Created new products and applied new UOMs to the products. Created BOM for Glass 250ml. Used Bottle products and 1x 250ml UOM. I made purchase of 750ml Bottles everything is fine.  Then made a sale of Glass 250ml. see below.










0
Avatar
Discard
Ray Carnes (ray)

4 Bottles of Wine is 12 glasses. An order for 3 glasses needs only two Bottles. In this example, what happens to the 2/3 of the second Bottle that is left after pouring three glasses? Can it be used for the next order of Wine?

Nihat Demir
Author

Hi Ray, 3 Glass of 250ml = 1x Bottle of 750ml. Yes 2/3 opened Bottle can be used for future Glass 250ml Orders. Why doesnt Odoo RESERVE 4x 250ml but reserves 3.99x 250ml? In this example, Why is Reserved Qty never be same to Initial Qty?

Nihat Demir
Author

I have just tested, ordered 3x 250ml, Delivery Order is correct this time, Initial qty and reserved qty 3x 250ml are same. BUT when ordered 1x Glass, Initial qty 1x 250ml and RESERVED qty is 0.99x Glass. Again some how not matching.

Avatar
Ray Carnes (ray)
Best Answer

You will get what you expect if you define the Reference Unit of Measure as milliliters instead of using Liters. 

Deactivate Liters (as well as the other Volume Units of Measure) and define the following Units of Measure:


0
Avatar
Discard
Nihat Demir
Author

Thanks Ray. I tried what you said. See below screenshots. I think there is bug in Odoo.

Nihat Demir
Author

By the way, I have latest build of Odoo 12 as of today

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
Odoo 11 Inventory, Unit of Measure and BOM for Restaurants & Bars Solved
inventory bom Unit of Measure odoo11
Avatar
Avatar
Avatar
4
Nov 24
8741
How to display the correct UOM in delivery order ?
bom Unit of Measure
Avatar
0
Jul 24
1959
How do you link the material items from the BOM to there respective product page?
inventory bom
Avatar
0
Mar 15
4488
How to Dropship Kits
inventory bom kit
Avatar
Avatar
1
Jul 25
1105
Multiple veriants of the same component.
inventory bom component
Avatar
0
Dec 24
1884
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