Odoo Help


Need to track expiration dates in products lot numbers

Rafael Emmanuelli
on 11/9/16, 12:06 PM 2,851 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 4
Calicut, India
--Cybrosys Technologies--

Cybrosys is a well known and highly flourished software development company in India, which provides various services in the IT industry. We are mainly dealing with ERP implementation in both Odoo and .Net, Source Code sale offer for various products and Employee Staffing solutions.

Odoo is the Key service of our company and we have cultivated many potential partners and clients in Europe, Asia, Middle East and Africa within a short span of time. We are really glad to be a part of Odoo and to provide the quality services without any compromise. You can manage the entire project by choosing our experienced and talented developers whenever required. You can feel free to have direct communication with our experts and can assign tasks according to your project plan, the developer will be yours till the end of the work.

Hold your hand with cybrosians to make your Odoo dreams comes true.

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: 2851 times
Last updated: 4/18/18, 10:25 PM