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.


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#
- 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.
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.

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#
- Navigate to Projects > Construction > Payment Requests (IPC) and click New.
- Select Project and enter Certificate Number (e.g.,
IPC #06 - Meskerem 2019). - Under BoQ Measurement Sheet:
- Enter Cumulative Quantity to Date for each executed line item (e.g.,
C-25 Concrete Columns: Previous210 m3, This Period85 m3, Total295 m3).
- Enter Cumulative Quantity to Date for each executed line item (e.g.,
- Under Deductions & Adjustments:
- The system automatically calculates
25%Advance Payment Recovery. - The system automatically withholds
5%Retention Money into escrow.
- The system automatically calculates
- Click Submit to Resident Engineer.
- Attach joint site measurement sheets signed by the consultant quantity surveyor.
- Upon consultant approval, click Generate Client VAT Invoice.
- 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 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. |