SmartERP Documentation An Ashewa Technology Solutions Platform

Manufacturing Technical Architecture and Data Model

Database schema, relational entities, core Python models (mrp.production, mrp.bom, mrp.workcenter), and ORM hooks.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Manufacturing Technical Architecture and Data Model within SmartERP.

Swimlane production lifecycle diagram across Planner, Supervisor, Operator, Quality Inspector, and Storekeeper.
SmartERP manufacturing order execution and shop floor lifecycle.

SmartERP Manufacturing Dashboard

Database schema, relational entities, core Python models (mrp.production, mrp.bom, mrp.workcenter), and ORM hooks.

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#

  1. Log into your SmartERP instance at https://smarterp.et/odoo.
  2. Open the main App Switcher (grid icon in the top-left corner).
  3. Navigate to Operations.

SmartERP Manufacturing Dashboard

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.

Relational Data Model#

SmartERP Manufacturing is built upon a high-performance relational ORM architecture connecting production orders, recipes, work centers, and stock moves.

Relational data model connecting bills of materials, manufacturing orders, work centers, work orders, quality checks, and scrap.
SmartERP Manufacturing and Quality relational data model.

Core Python Models#

mrp.production (Manufacturing Order)#

  • Stores header data, product reference, quantity to produce, date planned, and state (draft, confirmed, progress, to_close, done, cancel).
  • Implements action_confirm(), button_mark_done(), and _get_moves_raw_values().

mrp.bom & mrp.bom.line (Bill of Materials)#

  • Defines component ratios, scrap percentages, routing operations, and by-product allocations.
  • Computes recursive BoM explosions via explode().

mrp.workcenter & mrp.workorder (Shop Floor Execution)#

  • Tracks real-time machine run times, operator assignments, and OEE loss logs (mrp.workcenter.productivity).

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 prices
    • Quality: Trigger periodic inspection alerts (quality.ir_cron_inspection_check): Runs daily to flag mandatory quality testing queues
    • Workcenter: 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 / ExceptionProbable Root CauseCorrective Action / Resolution
BoM Missing Error: No active Bill of Materials foundProduct 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 stockRaw 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 failedWork order failed critical quality tolerance threshold.Perform required corrective rework or request authorized Quality Manager override.
Workcenter Capacity OverloadScheduled production duration exceeds available work center shift capacity.Adjust scheduled start dates or distribute load across alternative work centers.
Last updated: 2026-11-15