Odoo Help


Need to track expiration dates in products lot numbers

Rafael Emmanuelli
on 11/9/16, 12:06 PM 3,244 views

We are a drug wholesaler. We need to track lot numbers and expiration dates in our inventory. We also need to maintain a system to ensure first-expiry/first-out (FEFO) stock rotation.

I am using the odoo online v.10 and need to include the different expiration dates for each lot number in the same product.  If you track the inventory by Unique Serial Number or by Lots numbers there is no way to include the expiration date when receiving the merchandise. ¿Any help?


Cybrosys Technologies

--Cybrosys Technologies--
| 2 2 5
Calicut, India
--Cybrosys Technologies--

Cybrosys Technologies is a private limited ISO certified company in Technology and Software Engineering sector. We serve as one of the best and trusted Odoo official partner, providing ultimate Customization and Implementation services in Odoo ERP. A frequent contributor to Odoo Apps, our customized free apps are downloaded by more than one lakh users. Most of our apps augment the potentialities of Odoo and are trending in the Odoo app store.

Cybrosys keeps privilege to be one among the finest Odoo Official Partners with 200+ free apps contribution towards the Odoo community. Cybrosys also stands number one in Odoo-social Media Integration empowering every kind of business solutions.

We are also enriched with highly skilled UI/UX technical experts for Developing, Implementing and Designing, thereby providing ultimate benefit to our customer base.

Today Cybrosys has reached par excellent in Odoo Implementation and allied services, proving its credibility and reliability. Our proven services are used by customers sprawling across 160+ countries including Middle East, African continents, UK, Germany, Spain, Thailand, Hong Kong, New Zealand, Australia, Malaysia, Singapore, Egypt etc.

We are rapidly expanding our base with robust quality management and business process re-engineering to meet the ultimate customer desire.

To know more about Cybrosys Technologies and our Odoo Apps, Kindly visit:

Cybrosys Technologies 

Odoo Apps 

And inbox us your queries to odoo@cybrosys.com

Cybrosys Technologies
On 11/10/16, 12:19 AM

Step 1: You have to enable them first
     Go to 'Inventory' >Configuration >Settings > Under 'Traceability' > Select 'Track lots or serial numbers' in 'Lots and Serial Numbers'
     This will enable another option below called 'Expiration Dates' . Select 'Define Expiration Date on serial numbers'
Step 2: Configure your product  
     Under 'Inventory' tab  

         Product Life Time:  

         Product Use Time:  

         Product Removal Time: 

         Product Alert Time:

     provide values for these fields.

Step 3: If you have done step 1 & 2 Successfully
     when you try to validate an incoming shipment you will get a warning

        "Some products require lots/serial numbers, so you need to specify those first! "

     You can give a lot/serial number by clicking the button "Lot Split" (marked on the image)

You can see these Lot/Serial Numbers under  Inventory> Inventory Control> Lot/Serial Numbers

The problem is that even if I set life_time and etc. in product, the date in the lot is not automatically set.. so, what are those numbers in the product for if you must set the date by hand?

Blanco Martín & Asociados, Ing. Daniel Blanco
on 12/5/17, 9:41 AM

is this a bug??

Blanco Martín & Asociados, Ing. Daniel Blanco
on 12/5/17, 9:42 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 11/9/16, 12:06 PM
Seen: 3244 times
Last updated: 4/18/18, 10:25 PM