SmartERP Documentation An Ashewa Technology Solutions Platform

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.

Swimlane diagram of a sprint. The project manager or Scrum Master creates a sprint with dates and a goal. The team pulls backlog tasks in; if the project enforces the Definition of Ready and a task is not ready, SmartERP refuses with a message. Otherwise the sprint starts and SmartERP freezes committed hours and points. The team works the Kanban board. When the sprint is closed SmartERP freezes velocity and the completion rate.
A sprint from planning to close, and what SmartERP records at each end.

SmartERP Project Task Board and Milestones

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#

  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 Project → Projects.

SmartERP Project Task Board and Milestones

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 delays
    • Timesheets: 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 / ExceptionProbable Root CauseCorrective Action / Resolution
Access Rights Error: Cannot view confidential taskUser 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 stageAttempting 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 rateAssigned 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