跳至内容
此问题已终结
datesexpirationlotnolotsexpiry
3 回复
18974 查看
形象
Rafael Emmanuelli

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 Techno Solutions Pvt.Ltd
最佳答案

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



形象
丢弃
Ing. Daniel Blanco

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?

Ing. Daniel Blanco

is this a bug??

Miguel Barbosa

My problem is, the Lot End of Life Date will be the Purchase Date plus the Product Life Time, instead of the Production Date.

形象
Akes Mir
最佳答案

Hey Rafael,


Dealing with expiration dates in a drug wholesale business is crucial, and I get the headache of managing lot numbers and ensuring a proper stock rotation. I've been down that road with Odoo too. Here's a workaround that might help you out.


In Odoo v.10, if you're stuck with tracking inventory by Unique Serial Number or Lots numbers, you can create a custom field to include the expiration date when receiving merchandise. Go to the developer mode, add a custom field for expiration date in your product form, and make sure it's visible during the receiving process.


Next, set up a smart FEFO rotation by regularly running a report that identifies products nearing expiration. This way, you can prioritize their sale or use before they expire.

形象
丢弃
Akes Mir

It's a bit of a workaround, but it gets the job done. I've used it successfully here: https://andersenlab.de/blueprint/AI-solutions-in-healthcare . Holler at me if you need some extra deets or hit a snag.

形象
Charles Manche (cmh)
最佳答案

Hi,

Do you know if any solution was found or development made?


形象
丢弃
Equick ERP

Hello,

Hope below module helps you to add the dates automatically and manually while received the goods.

https://apps.odoo.com/apps/modules/14.0/eq_picking_lot_expiry/

Thanks.

相关帖文 回复 查看 活动
storing expiry dates without lot numbers 已解决
lot expiration lotno expiry
形象
形象
2
12月 22
6292
Properly managing expiration dates.
products lots expiry
形象
0
3月 15
4269
When I enable Expiration Date in Odoo (v14), how do the expiration alerts behave? 已解决
trigger alerts expiration expiry reached
形象
形象
1
10月 22
7251
FIFO Strategy with expiration dates
dates expiration strategy FIFO removal
形象
形象
2
9月 20
4933
Modifying Quote Dates in Odoo for Daily Sales Averages Calculation
dates
形象
1
11月 23
2655