Balanced Scorecard Troubleshooting and Common Inconsistencies

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Balanced Scorecard Troubleshooting and Common Inconsistencies within SmartERP.

Resolving out-of-bounds weight calculations, orphan objectives in strategy maps, stale ORM queries, and rounding errors.

{screenshot:bsc-troubleshooting-overview-dashboard}

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 Module 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. Select the Strategic Execution app icon.
4. From the top navigation bar, open Strategic Execution → Perspectives → Strategic Objectives / KPIs / Action Plans.

{screenshot:bsc-troubleshooting-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Objective / KPI Name (Mandatory): Precise strategic outcome statement
   • Perspective (Mandatory): One of the 4 balanced perspectives with mandated weighting
   • Weight (%) (Mandatory): Percentage allocation contributing to overall perspective score
   • Target Value & Baseline (Mandatory): Quantifiable numerical goal and historical starting point
3. Configure optional operational parameters and localized tags as required:
   • Calculation Formula (Optional): Automated SQL query or module model metric extraction
   • Initiative Champion (Optional): Department head or senior manager accountable for result
   • Review Frequency (Optional): Monthly, quarterly, or annual appraisal cadence
4. Click the Save icon in the control bar to commit the record.

{screenshot:bsc-troubleshooting-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Draft → Active Target → Mid-Term Review → Final Appraisal → Locked).
• Ledger & System Impact: Financial perspective KPIs dynamically read General Ledger balances, revenue growth metrics, and cost ratios directly from the accounting engine.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:bsc-troubleshooting-transaction-processing-state}

Common BSC Configuration Issues#

Issue 1: Scorecard Validation Fails with 'Weights Do Not Equal 100%'#

• Cause: Total KPI weights within a perspective sum to 95% or 105%.
• Solution: Open the scorecard. SmartERP displays the live weight tally. Recalibrate individual KPI weights so each perspective equals exactly 100%.

Issue 2: Automated KPI Actual Displays Zero Despite Completed Invoices#

• Cause: Domain filter on the ORM query is improperly formatted or date range points to an inactive period.
• Solution: Click Test Query on the KPI form. Check whether invoices are in posted state and date filters match current fiscal year boundaries.

Issue 3: Orphan Strategic Objective in Strategy Map Canvas#

• Cause: An objective was created without cause-and-effect links to parent or child perspectives.
• Solution: Open the Strategy Map Canvas. Locate the isolated node and draw the necessary cause-and-effect arrows connecting it to adjacent perspectives.

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#