Factory Tooling & Asset Tracking with QR Barcodes in Odoo: Preventive Calibration, Die/Mold Lifecycle & Location Moves

1. The Chaos of Missing Tools and Expired Calibration

In large 20-acre chemical or engineering facilities across Dahej and Hazira, valuable portable equipment - such as ultrasonic thickness gauges, calibrated torque wrenches, welding rectifiers, and specialized cutting jigs - moves continuously between maintenance shops and production bays.

When technicians cannot locate a critical alignment tool, work orders sit idle for hours while workers wander the plant searching for it. Worse, in ISO 9001 and IATF 16949 audits, discovery of an expired calibration sticker on a pressure gauge or vernier caliper triggers immediate audit non-conformance penalties.

2. Industrial Metallic QR Code & Mobile Identification Topology

The asset tracking architecture is built for demanding plant environments:

• Laser-Etched Stainless Steel QR Plates: Durable metallic 2D DataMatrix plates resist extreme heat, cutting oil, chemical washdowns, and industrial grime.
• Handheld Mobile Scanners: Rugged Android barcode devices and mobile cameras running the Arihant AI mobile app allow operators to verify tool calibration in under 200 milliseconds.
• Shop Floor Bay Tracking: Moving high-value dies or measuring instruments across departments automatically updates the asset's active bay location in Odoo.

3. Production Odoo 19 Python ORM Asset Calibration Blueprint

Below is the Odoo model tracking asset movements and statutory calibration expiration:

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

class MaintenanceEquipmentAsset(models.Model):
    _inherit = 'maintenance.equipment'

    asset_qr_tag = fields.Char(string="Laser QR / Barcode Identifier", required=True, index=True)
    current_bay_location = fields.Char(string="Active Shop Floor Bay", default="Central Toolroom")
    last_calibration_date = fields.Date(string="Last Calibration Certificate Date")
    calibration_validity_months = fields.Integer(string="Calibration Cycle (Months)", default=12)
    next_calibration_due = fields.Date(string="Next Calibration Due Date", compute="_compute_next_calibration", store=True)
    calibration_status = fields.Selection([
        ('valid', 'Certified & In Service'),
        ('due_soon', 'Calibration Due in 15 Days'),
        ('expired', 'EXPIRED - Tag Out of Service')
    ], compute="_compute_calibration_status", store=True)

    @api.depends('last_calibration_date', 'calibration_validity_months')
    def _compute_next_calibration(self):
        for eq in self:
            if eq.last_calibration_date:
                eq.next_calibration_due = fields.Date.add(eq.last_calibration_date, months=eq.calibration_validity_months)
            else:
                eq.next_calibration_due = False

    @api.depends('next_calibration_due')
    def _compute_calibration_status(self):
        for eq in self:
            if not eq.next_calibration_due:
                eq.calibration_status = 'expired'
                continue
            days_left = (eq.next_calibration_due - fields.Date.today()).days
            if days_left < 0:
                eq.calibration_status = 'expired'
            elif days_left <= 15:
                eq.calibration_status = 'due_soon'
            else:
                eq.calibration_status = 'valid' 

4. Automated Maintenance Lockout Protocol

If a measurement instrument passes its calibration expiration date, Odoo automatically changes its status to Expired - Locked, preventing operators from selecting that tool in active manufacturing quality checks.

5. Implementation & Audit Readiness

Deploying QR asset tracking provides complete operational custody, prevents asset misplacement, and ensures 100% flawless scores in statutory quality audits.