Manufacturing Technical Architecture and Data Model

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.

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

{screenshot:technical-architecture-overview-dashboard}

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 Module 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. Select the Manufacturing app icon.
4. From the top navigation bar, open Manufacturing → Operations → Manufacturing Orders / Work Orders; Quality → Quality Control.

{screenshot:technical-architecture-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Finished Product (Mandatory): Manufacturable item variant linked to an active Bill of Materials
   • Quantity to Produce (Mandatory): Target production batch volume in standard unit of measure
   • Bill of Materials (BoM) (Mandatory): Active engineering recipe defining component roll-ups and operation steps
   • Scheduled Date (Mandatory): Target production execution date and shift allocation
3. Configure optional operational parameters and localized tags as required:
   • Work Center Routing (Optional): Specific shop floor machine or assembly station sequence
   • Lot / Serial Number (Optional): Assigned traceability lot for finished goods batch tracking
   • Analytic Cost Account (Optional): Cost absorption center for direct labor and utility overhead
4. Click the Save icon in the control bar to commit the record.

{screenshot:technical-architecture-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Draft → Confirmed → In Production → Quality Gate Passed → Done → Cost Closed).
• Ledger & System Impact: Consumes raw materials from inventory (crediting stock valuation), absorbs labor/machine overhead, and debits finished goods inventory at actual cost.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:technical-architecture-transaction-processing-state}

Relational Data Model#

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

[mrp-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#