Construction Technical Architecture and Data Schema
Database models: smarterp_construction_contract, payment_request, boq_line, daily_labor, and ORM hooks.
1. Overview & Business Value#
This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Construction Technical Architecture and Data Schema within SmartERP.


Database models: smarterp_construction_contract, payment_request, boq_line, daily_labor, and ORM hooks.
2. Prerequisites & Security Access Groups#
- Required Modules:
project, smarterp_project_governance, hr_timesheet - Security Groups:
Project User(Technical ID:project.group_project_user)Project Administrator(Technical ID:project.group_project_manager)Timesheet Approver(Technical ID:hr_timesheet.group_hr_timesheet_approver)
- Master Data Dependencies: Project master records, milestone stages, work breakdown structures (WBS), bill of quantities (BoQ), and employee billing cost rates.
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 Project → Projects.

Step 2: Operational Data Parameters & Controls#
Ensure all mandatory parameters comply with enterprise operational standards:
- Authorized Operator: Action executed under assigned RBAC permissions (Project Director, Project Manager, Agile Scrum Master, Lead Engineer).
- Relational Integrity: Linked to upstream master records, approval requests, or transactional ledgers.
- Statutory & Quality Controls: Verified against Ethiopian statutory regulations and corporate governance standards.
Step 3: Operational Execution & State Progression#
- State Progression Gate: Advance record from Draft through Audited to Confirmed / Certified.
- Integrated System Impact: Automatically updates real-time operational states and posts financial/inventory journal moves.
- Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.
Relational Data Architecture#
SmartERP Construction extends core project management (project.project, project.task) with comprehensive construction-specific relational models.
Core Python Models#
smarterp_construction_contract#
- Master contract record holding employer link, contract sum, advance payment terms, retention percentages, and FIDIC/PPA clauses.
smarterp_construction_boq_line#
- Individual Bill of Quantities items storing division codes, tender quantities, contract unit rates, cumulative certified quantities, and analytic account links.
smarterp_construction_payment_request (IPC)#
- Manages monthly interim payment certificates, gross-to-net calculations, advance recovery schedules, and retention withholds.
- Implements
action_generate_invoice()to spawn customer VAT invoices.
smarterp_construction_daily_labor#
- Site diary tracking equipment plant hours, subcontractor headcounts, weather downtime, and material deliveries.
4. Advanced Configuration Points#
- Automated Actions & Scheduled Tasks (Crons):
Project: Flag overdue milestone deadlines(project.ir_cron_overdue_tasks): Runs daily to notify project managers of pending schedule delaysTimesheets: Send unsubmitted reminder alerts(hr_timesheet.ir_cron_timesheet_reminder): Runs weekly on Friday afternoon to remind team members
- Custom Print Templates & Reports:
- Project Status & Milestone Execution Scorecard
- Interim Payment Certificate (IPC) for Construction
- Project Timesheet & Resource Utilization Summary
- Earned Value Management (EVM) Financial Report
- 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 |
|---|---|---|
Access Rights Error: Cannot view confidential task | User is not listed as a project follower or team member. | Add user to Project Privacy Settings or Collaborators tab. |
Validation Error: Timesheet date outside active stage | Attempting to log labor against a closed or cancelled milestone. | Select an active task stage or request reopening of the target work package. |
Billing Rate Error: Missing employee cost rate | Assigned employee lacks an hourly labor cost rate on their profile. | Configure the employee hourly cost rate under Human Resources → Employees → HR Settings. |
Last updated: 2026-11-15