SmartERP Documentation An Ashewa Technology Solutions Platform

Prepare and Validate Interim Payment Certificates (IPCs)

Measuring monthly work progress, resident engineer certification, advance payment deductions, retention withholding, and billing.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Prepare and Validate Interim Payment Certificates (IPCs) 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

Measuring monthly work progress, resident engineer certification, advance payment deductions, retention withholding, and billing.

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.

The Interim Payment Certificate (IPC) Workflow#

The Interim Payment Certificate (smarterp_construction_payment_request) is the formal legal instrument through which a contractor claims payment for executed work.

Construction project BoQ and Interim Payment Certificate (IPC) lifecycle diagram.
Construction contract execution, BoQ measurement, and IPC certification lifecycle.

The IPC Mathematical Valuation Equation#

Each IPC calculates net payable amounts through strict cumulative accounting:

$$\text{Gross Work Executed to Date} = \sum (\text{Cumulative Measured Quantity}_i \times \text{Contract Unit Rate}_i)$$

$$\text{Current Period Gross} = \text{Gross Work to Date} - \text{Previous Gross Certified}$$

$$\text{Net Payable Before VAT} = \text{Current Gross} - \text{Advance Recovery} - \text{5\% Retention Withheld} + \text{Materials on Site (80\%)}$$

$$\text{Total Invoice Amount} = \text{Net Payable Before VAT} + 15\% \text{ VAT}$$

Procedure: Generating an IPC#

  1. Navigate to Projects > Construction > Payment Requests (IPC) and click New.
  2. Select Project and enter Certificate Number (e.g., IPC #06 - Meskerem 2019).
  3. Under BoQ Measurement Sheet:
    • Enter Cumulative Quantity to Date for each executed line item (e.g., C-25 Concrete Columns: Previous 210 m3, This Period 85 m3, Total 295 m3).
  4. Under Deductions & Adjustments:
    • The system automatically calculates 25% Advance Payment Recovery.
    • The system automatically withholds 5% Retention Money into escrow.
  5. Click Submit to Resident Engineer.
  6. Attach joint site measurement sheets signed by the consultant quantity surveyor.
  7. Upon consultant approval, click Generate Client VAT Invoice.
  8. SmartERP creates the commercial VAT invoice with withholding tax receivable tracking.

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