Lot and Batch Traceability Across Production
Full upstream and downstream traceability from raw ingredient supplier lots to finished goods customer deliveries.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Lot and Batch Traceability Across Production within SmartERP.


Full upstream and downstream traceability from raw ingredient supplier lots to finished goods customer deliveries.
2. Prerequisites & Security Access Groups#
- Required Modules:
mrp, quality_control, smarterp_manufacturing_costing - Security Groups:
Manufacturing User(Technical ID:mrp.group_mrp_user)Manufacturing Administrator(Technical ID:mrp.group_mrp_manager)Quality Inspector(Technical ID:quality.group_quality_user)
- Master Data Dependencies: Bills of Materials (BoM), routing operations, work centers with machine/labor hourly rates, raw material stock, and inspection checkpoints.
3. Step-by-Step Configuration & Execution#
Step 1: Navigating to the Interface#
- Log into your SmartERP instance at
https://smarterp.et/odoo. - Open the main App Switcher (grid icon in the top-left corner).
- Navigate to Operations.

Step 2: Operational Data Parameters & Controls#
Ensure all mandatory parameters comply with enterprise operational standards:
- Authorized Operator: Action executed under assigned RBAC permissions (Authorized Operator).
- Relational Integrity: Linked to upstream customer, product, inventory lot, or manufacturing order.
- Statutory & Quality Controls: Verified against Ethiopian commercial and tax regulations or technical engineering specifications.
Step 3: Operational Execution & State Progression#
- State Progression Gate: Advance record from Draft through Confirmed to Completed / Posted.
- Integrated System Impact: Automatically updates inventory stock quants, customer receivables, or work-in-progress cost accounting ledgers.
- Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.
Upstream and Downstream Traceability#
For pharmaceutical, food and beverage, and construction steel manufacturing, full traceability is a mandatory requirement of the Ethiopian Food and Drug Authority (EFDA) and the Ethiopian Conformity Assessment Enterprise (ECAE).
SmartERP provides bidirectional traceability:
- Downstream Traceability: Given a raw material supplier lot number, identify every finished goods batch, warehouse location, and customer invoice that consumed it.
- Upstream Traceability: Given a customer complaint on a finished goods serial number, trace back to the exact work order, machine operator, shift timestamp, and raw material supplier receipt.
Procedure: Running a Traceability Report#
- Navigate to Inventory > Products > Lots/Serial Numbers.
- Open the lot record (e.g.,
LOT/2026/HP-8812). - Click the Traceability smart button.
- The system displays the complete visual pedigree tree:
- Supplier PO receipt -> Model 19 GRN -> Raw Material Bin -> MO Component Consumption -> Work Center Welding -> Finished Goods GRN -> Customer Delivery Note.
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
MRP: Recalculate BoM standard costs(mrp.ir_cron_bom_cost_roll): Runs weekly to update standard costing from latest procurement purchase pricesQuality: Trigger periodic inspection alerts(quality.ir_cron_inspection_check): Runs daily to flag mandatory quality testing queuesWorkcenter: Update OEE statistics(mrp.ir_cron_workcenter_oee): Runs hourly to compute Overall Equipment Effectiveness metrics
- Custom Print Templates & Reports:
- Production Order Traveler & Pick List
- Shop Floor Work Order Execution Slip
- Quality Inspection Certificate & Non-Conformance Report
- Manufacturing Cost Analysis & Variance Ledger
- Multi-Company Rules: Record-level security isolation under Company 1 (
Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.
5. Comprehensive Troubleshooting Matrix#
| Error Symptom / Exception | Probable Root Cause | Corrective Action / Resolution |
|---|---|---|
BoM Missing Error: No active Bill of Materials found | Product variant lacks a verified and confirmed BoM in the system. | Create and confirm an active BoM under Manufacturing → Products → Bills of Materials. |
Component Shortage Block: Insufficient stock | Raw material components have not been transferred to the shop floor location. | Execute an internal transfer from main warehouse to production staging location. |
Quality Gate Blocked: Mandatory test failed | Work order failed critical quality tolerance threshold. | Perform required corrective rework or request authorized Quality Manager override. |
Workcenter Capacity Overload | Scheduled production duration exceeds available work center shift capacity. | Adjust scheduled start dates or distribute load across alternative work centers. |