Do You know Hidden Risks of Poor ERP Implementation? Download Free E-Book

Product Expiry Feature in Odoo

Stay Ahead of Expirations: Track Product Expiry Feature in Odoo
October 23, 2013 by
Product Expiry Feature in Odoo

Odoo provides a feature through the “Products Expiration Date” module to track the product by its expiration dates and with the lot and Serial Number of the product.

Here we are talking about tracking different dates on products and production lots.

We need to enable “Lots & Serial Numbers” and “Expiration Dates”  from Main Inventory > Settings Menu.

 

After Enabling the Feature from Inventory Settings we can see the Lots and Expiration dates Option in Product Master Form.

In Product Form under the inventory information, we can enable the Product “Tracking” Option.


There are three options to Track the Product.

  • By Unique Serial Number
  • By Lots
  • No Tracking

If we set/configure Product “Tracking”  by "By Unique Serial Number"  or ‘By Lots’  then we can see the “Expiration Date” option enabled.
Once we enable the “Expiration Date” checkbox, we can see the dates options to configure the  Expiration Days and based on that system will automatically calculate the Expiration dates.

Odoo Provide Four Types of Expiration Days Configuration to Calculate the Expiration dates.

  • Expiration Date
  • Best Before Date
  • Removal Date
  • Alert Date

 

Expiration Date:

The number of days after the receipt of the products (from the vendor or in stock after production) after which the goods may become dangerous and must not be consumed. The date is getting computed on basis of the Serial/Lot Number.

Best Before Date:

Number of days before the Expiration Date after which the goods start deteriorating, without being dangerous yet. This date is getting computed on basis of the Serial/Lot Number.

Removal Date:

This date is getting computed on basis of the Serial/Lot Number.

This date indicates that whichever Goods exceed the removal date should be removed from the stock.

Alert Date:

This date is also getting computed on the Lot/Serial Number and it is used to give alerts before the Expiration Date.
Let's see the Real calculation with the Purchase order and Incoming Shipment.
We created a Purchase order with the Product “Good Dates” to buy 10 KG.

After Confirming the Purchase order, automatically Incoming Shipment will generate.

You can see product details and demand quantity with the Unit of measure and Schedule date.

You can see the Schedule date is 23rd-Feb-2023 in Incoming Shipment.

Now we are going to add the Lot Number and Received / Done Quantity by clicking on the button shown in the above screenshot.

Once we click on the button to add the details Automatically  “Expiration Date” will calculate based on configured Expiration Days in the Product form.

We can update the Expiration Date if we want otherwise we can fill in the Lot / Serial Number Details and Done Quantity details and confirm it.

We configured “Expiration days” = 60 In product Form based on it it will calculate the Expiration date automatically in incoming Shipment.

Expiration Date = Schedule date from Incoming Shipment + Product expiration days In product form

Result :

24-April-2023 = 23-Feb-2023 + 60 days

After confirming and Validating the Shipment inventory will manage automatically with a defined Lot / Serial number wise. If we want to see the traceability we have to click on the button to see the Stock movement.

Let us check the Expiration date And Other Dates calculation In Lot / Serial Numbers.


Go to Inventory => Products => Lots / Serial Numbers

In Lots / Serial Numbers Expiration dates and Other dates are updated automatically.

Expiration Date:

The expiration date is used to showcase that the Goods containing this Serial Number is expired and harmful to consume.

Expiration Date = Schedule date from Incoming Shipment + Product expiration days In product form

Result : 24-April-2023 = 23-Feb-2023 + 60 days
 

Best Before Date:

This date specifies the serial numbered Goods containing this date are starting to deteriorate but are not yet dangerous to consume.Best Before Date = Expiration Date - Product Best Before days In product form

Result : 14-April-2023 = 24-April-2023 - 10 days
 

Removal Date:

This is the date on which the goods with this Serial Number should be removed from the stock. This date will be used in the FEFO removal strategy.

Removal Date = Expiration Date - Product Removal days In product form

Result : 14-April-2023 = 24-April-2023 - 10 days
 

Alert Date:

The alert date helps to determine the expired lots and serial numbers using the filter "Expiration Alerts".

Alert Date = Expiration Date - Product Alert days In product form
Result : 14-April-2023 = 24-April-2023 - 10 days

 

 Connect with us & Explore More about SerpentCS 

Web www.serpentcs.com
Solutions www.serpentcs.in
Apps https://bit.ly/SCS_AppsStore
YouTube https://bit.ly/SCS_YTChannel
LinkedIn https://bit.ly/SCS_LinkedIN
Email contact@serpentcs.com