SmartERP Documentation An Ashewa Technology Solutions Platform

Project Cash Flow Forecasting and S-Curve Modeling

Generating project S-Curves, matching IPC billing milestones against vendor and labor commitments, and overdraft planning.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Project Cash Flow Forecasting and S-Curve Modeling 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

Generating project S-Curves, matching IPC billing milestones against vendor and labor commitments, and overdraft planning.

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.

Construction Cash Flow Dynamics#

Cash flow timing is the leading cause of contractor insolvency in Ethiopia. Advance payments must be preserved for major procurement (rebar coils, tower cranes, imported electromechanical packages) while monthly IPC disbursements must fund ongoing local labor and materials.

Procedure: Generating an S-Curve#

  1. Navigate to Projects > Planning > Cash Flow & S-Curve.
  2. Select your construction project.
  3. The system pulls planned BoQ milestone dates from the Gantt schedule.
  4. SmartERP plots:
    • Baseline Planned Value (PV) S-Curve: Theoretical cumulative expenditure.
    • Actual Cost of Work Performed (ACWP): Real-time debits from purchase bills, payroll timesheets, and store SIVs.
    • Earned Value (EVWP): Certified IPC valuation to date.
  5. Review the Monthly Cash Inflow vs Outflow Projection table to anticipate funding shortfalls and negotiate bank overdraft credit lines in advance.

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