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

What's the difference between quants, lots and products?

Subscribe

Get notified when there's activity on this post

This question has been flagged
stockwarehousev8quant
2 Replies
20960 Views
Avatar
Els Van Vossel (evv)

I want to know the difference between quants, lots and products. Is there a relationship between them ?

2
Avatar
Discard
Avatar
Els Van Vossel (evv)
Author Best Answer


Quant indicates a specific stock quantity of the same product that entered your warehouse at a specific moment in time in one specific operation; in a single lot (batch) if lot tracking is enabled. 

Let's give an example. You purchased 10 pieces a week ago, you received 6 pieces yesterday and today the remaining 4 pieces arrive. In this case, two quants will be created: 1 with 6 pieces, another one with 4 pieces. Should the batch with 4 pieces be linked to individual Lot (serial) numbers, the result will be 4 separate quants.

The Quants table stores the current state of stock (per location). It is updated each time a stock move is set to done and has 3 main impacts:

  • A quant optimizes the computation (e.g. quantity available), because a quant only contains information about the current stock (not the past or the future). The volume is smaller and doesn’t grow in time;
  • A quant  will be used in FIFO, LIFO and FEFO costing, as we need to match the incoming and outgoing moves for a correct stock valuation;
  • A quant can also be used for upstream/downstream traceability and lot management; a quant contains the information about lots. Quant history displays a list of stock moves indicating the current stock level.

In case a quant has been reserved,  you can see the related stock move in the Reserved for Move field. Quants can be split in order to reserve only the quantities needed.

To display quants, make sure to activate Technical Features for your user.

A lot number (also called serial number in Odoo) can be considered as a serial number for a single product, or a batch containing quantities of a certain product. Lots are typically used to identify a serial number (for a computer, printer, ...), or as production lots to indicate for instance quality grades or delivery lots. You can make it mandatory to enter a lot number according to the incoming/outgoing/full traceability options ticked in the Product Variant form. 

A Product form contains information about articles you buy, sell, produce, store and deliver. The product form has several tab pages, allowing you to enter in one place required information for various apps of your Odoo, such as accounting, sales, purchases and stock management. Thanks to this integration of the various apps, your product information is stored in one place and can easily be updated. A product is composed of a product template, which data always apply, and one or more product variants, each of which can have specific settings for a number of data.

One of the main characteristics of a product, is the product type, i.e. stockable product, consumable or service.

The following table summarizes the differences between the products types:

For consumables, this means:

  • Follow push and pull rules;
  • No putaway/removal strategies;
  • No inventory valuation possible.

Let's give a concrete example on how quants are used with Lot Management combined with a 2 step goods receipt. Tick the option Track lots or serial numbers and Manage advanced routes from Settings > Configuration > Warehouse.

Open the Warehouse form from the menu Warehouse > Configuration > Warehouses. On the tab page Warehouse Configuration, next to Incoming Shipments, tick Unload in input location then go to stock (2 steps).

We decided to receive our goods in two steps (first to Input, then to Stock) and to assign lot numbering. Now let's see the impact of lot numbers on quants. 

I receive products from my supplier for the given lot numbers:

Stock Move ID 1

  • 5 pieces from Supplier location → Input location, lot #1

Stock Move ID 2

  • 3 pieces, from Supplier location → Input location, lot #2

In the Quants table, we have:

  • 5 pieces in Input, lot #1 (quant history: ID1)
  • 3 pieces in Input, lot #2 (history: ID2)


Now we proceed with our internal transfer from Input to Stock and we confirm the Internal Transfer through the menu Warehouse > Operations > All Operations:  

  • Stock Move ID3: 6 pieces, from Input location → Stock location

We get the following Quants, since the 6 pieces will be assigned according to the quants available:

  • 5 pieces in Stock, lot #1 (history: ID1, ID3)
  • 1 piece in Stock, lot #2 (history: ID2, ID3)
  • 2 pieces in Input, lot #2 (history: ID2)

The related Quant history shows the related stock moves:

11
Avatar
Discard
jeffery

but as we have tested. the consumable product have create quant and stock valuation too. is this is a bug ? or not have been implemented. see reported issue ref: https://github.com/odoo/odoo/issues/3394

gunnar
@Els can Vossel 1: Fan Chen (thi commentor from above) is actually right. So it seems your essay (and with it the official documentation) contains false information at the moment in this matter. Would you mind to update that?

@Els van Vossel 2: there is nothing in your essay in regards to Owner on stock functionality (which works through quants). It would be great whether you could add a sentence on what that is and how it works

@Els 1)

Avatar
Alfonso D'Antuono
Best Answer

Thanks to your clear and complete explanation of Quants, I was able to show lot/seral number stock quantity in a WH for each Product using the standard report. That menu should be avaiable in the Inventory menus by default.



0
Avatar
Discard
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
How to get available stock / last stock of production lot from quants?
stock warehouse v8 available quant
Avatar
0
Mar 15
5177
How to split products in Odoo v8
stock warehouse v8 serial_numbers
Avatar
0
Apr 15
5482
How do you specify the stock location for a warehouse in Odoo 8?
stock warehouse v8 locations
Avatar
Avatar
1
Mar 15
14015
Fraccionar lotes en / Splitting Lots in Odoo 18
stock warehouse
Avatar
Avatar
Avatar
2
Aug 25
1195
Inventory - How can I see stock levels at a specific date? How can I track product movements over time? Solved
stock warehouse
Avatar
Avatar
2
Aug 25
9052
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