Batch Expiry & Shelf-Life Management in Process ERP: FEFO Stock Reservation for Chemical, Pharma & Food Manufacturing

1. The Spoilage Trap of Traditional FIFO in Process Manufacturing

In chemical synthesis, pharmaceutical processing, and perishable food manufacturing across Gujarat, standard First-In-First-Out (FIFO) picking is inadequate. If a newer shipment of catalyst, active pharmaceutical ingredient (API), or edible additive arrives with a shorter manufacturer expiry date than older warehouse stock, traditional FIFO ships the older lot while the shorter-life material quietly expires on the shelf.

The resulting write-offs severely impact gross margins. Implementing automated First-Expired-First-Out (FEFO) stock reservation in Odoo ERP completely prevents stock aging write-offs.

2. Algorithmic FEFO & Remaining Shelf-Life Reservation

Under Odoo 19 FEFO removal strategies, warehouse picking orders sort available lot quants dynamically by expiry date. Furthermore, automated customer guardrails ensure that strict institutional buyers (who mandate at least 70% to 80% remaining shelf-life upon receipt) are never allocated borderline lots.

3. Production Odoo 19 Python ORM FEFO Allocation Blueprint

Below is the Odoo model verifying customer shelf-life constraints prior to delivery order validation:

# -*- coding: utf-8 -*-
from odoo import models, fields, api, _
from odoo.exceptions import UserError

class StockMoveLine(models.Model):
    _inherit = 'stock.move.line'

    def _action_done(self):
        """Validates that lot assigned to outgoing delivery meets minimum customer shelf-life terms."""
        for ml in self:
            if ml.picking_id.picking_type_code == 'outgoing' and ml.lot_id and ml.lot_id.expiration_date:
                total_days = (ml.lot_id.expiration_date.date() - ml.lot_id.create_date.date()).days
                remaining_days = (ml.lot_id.expiration_date.date() - fields.Date.today()).days

                if total_days > 0:
                    shelf_life_ratio = (remaining_days / total_days) * 100.0
                    min_allowed = ml.picking_id.partner_id.min_shelf_life_percentage or 70.0
                    if shelf_life_ratio < min_allowed:
                        raise UserError(_(
                            "FEFO Compliance Violation: Lot %s has only %.1f%% remaining shelf life, but customer requires at least %.1f%%."
                        ) % (ml.lot_id.name, shelf_life_ratio, min_allowed))
        return super()._action_done()

4. Automated Quarantine Gates & Expiry Alerts

Automated scheduled jobs evaluate lot expiration dates daily. Batches crossing alert thresholds automatically move to a virtual Quarantine location, triggering quality review notifications before stock expires.

5. Implementation & Compliance Readiness

Enforcing automated FEFO picking and shelf-life tracking provides 100% regulatory traceability, eliminates expired customer returns, and protects operating cash flow.