SmartERP Documentation An Ashewa Technology Solutions Platform

Set Performance Targets and Red-Amber-Green (RAG) Thresholds

Configuring baseline benchmarks, stretch targets, Red-Amber-Green tolerance bands, and perspective weighting.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Set Performance Targets and Red-Amber-Green (RAG) Thresholds within SmartERP.

Balanced Scorecard strategy cascading diagram connecting vision, strategy map, department scorecards, and individual employee KPIs.
Balanced Scorecard strategy cascading and performance execution flow.

BSC Strategic Executive Dashboard and Cause-Effect Map

Configuring baseline benchmarks, stretch targets, Red-Amber-Green tolerance bands, and perspective weighting.

2. Prerequisites & Security Access Groups#

  • Required Modules: smarterp_balanced_scorecard, smarterp_strategy
  • Security Groups:
    • Strategy Officer (Technical ID: smarterp_balanced_scorecard.group_bsc_user)
    • Strategy Director (Technical ID: smarterp_balanced_scorecard.group_bsc_manager)
    • Executive Committee Member (Technical ID: smarterp_balanced_scorecard.group_bsc_executive)
  • Master Data Dependencies: Strategic themes, 4 BSC perspectives (Financial, Customer, Internal Process, Learning & Growth), corporate KPIs, and quarterly appraisal periods.

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 Balanced Scorecard → Strategic Dashboard.

BSC Strategic Executive Dashboard and Cause-Effect Map

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Chief Executive Officer, Corporate Planning Director, Strategy Lead).
  • 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.

Target Setting Methodology#

Every KPI requires calibrated baseline benchmarks and realistic stretch targets aligned with annual operating plans (AOP).

Red-Amber-Green (RAG) Tolerance Limits#

SmartERP standardizes performance evaluation using five-tier RAG tolerance bands:

Score >= 100%: Outstanding Performance (Dark Green)
Score 90% - 99%: Target Met (Green)
Score 75% - 89%: Minor Deviation / Attention Required (Amber)
Score 50% - 74%: Significant Underperformance (Red)
Score < 50%: Critical Failure (Dark Red)

Procedure: Setting RAG Bands#

  1. On the KPI form, switch to the Targets & Thresholds tab.
  2. Select current fiscal year (e.g., 2019 E.C. / 2026-2027 G.C.).
  3. Enter targets per period:
    • Q1 Target: 100,000,000 ETB.
    • Q2 Target: 120,000,000 ETB.
    • Q3 Target: 135,000,000 ETB.
    • Q4 Target: 150,000,000 ETB.
  4. Define RAG Threshold Percentages:
    • Green Minimum: 90%.
    • Amber Range: 75% - 89%.
    • Red Trigger: Below 75%.
  5. Set Weighting Percentage (e.g., 20% of the Financial Perspective).
  6. Click Save.

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • BSC: Calculate quarterly KPI achievements (smarterp_bsc.ir_cron_compute_kpi): Runs quarterly on the 5th to compute composite achievement scores
    • BSC: Issue appraisal cascade reminders (smarterp_bsc.ir_cron_appraisal_alert): Runs monthly to remind objective champions to update progress
  • Custom Print Templates & Reports:
    • Institutional Balanced Scorecard Executive Dashboard
    • Departmental Strategic Cascade Matrix
    • KPI Performance Variance & Trend Analysis
    • Corporate Strategy Execution Summary
  • 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
Weighting Error: Perspective weights do not equal 100%Total weights assigned to objectives within perspective fail to sum to 100.00%.Adjust individual objective weightings so the perspective total equals exactly 100%.
Data Feed Error: Automated KPI metric returned nullUnderlying model query failed or target database view has no records.Verify connected model name and filter domain in the KPI automated calculation parameters.
Lockout Error: Period results locked for executive reviewCurrent appraisal quarter has been locked by the Strategy Director.Obtain written authorization and request temporary unlock from the Strategy Director.
Last updated: 2026-11-15