SmartERP Documentation An Ashewa Technology Solutions Platform

Sales cockpits and revenue reports

Executive sales reporting, pipeline velocity, salesperson leaderboards, aged receivables, and product profitability cockpits.

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Sales cockpits and revenue reports within SmartERP.

Swimlane lead-to-cash workflow diagram from CRM capture to quotation, credit check, order confirmation, and invoice payment.
Commercial lead-to-cash operational and fulfillment lifecycle.

SmartERP Sales Dashboard

This reference guide details all executive cockpits and commercial reports in SmartERP Sales.

Executive Reporting Dashboard

2. Prerequisites & Security Access Groups#

  • Required Modules: sale_management, crm, point_of_sale, smarterp_payment_telebirr
  • Security Groups:
    • Sales User (Technical ID: sales_team.group_sale_salesman)
    • Sales Administrator (Technical ID: sales_team.group_sale_manager)
    • POS User / Cashier (Technical ID: point_of_sale.group_pos_user)
  • Master Data Dependencies: Customer partner registry, selling pricelists, product inventory balances, payment providers (Telebirr/CBE Birr), and POS terminal sessions.

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

SmartERP Sales Dashboard

Step 2: Operational Data Parameters & Controls#

Ensure all mandatory parameters comply with enterprise operational standards:

  • Authorized Operator: Action executed under assigned RBAC permissions (Authorized Operator).
  • Relational Integrity: Linked to upstream customer, product, inventory lot, or manufacturing order.
  • Statutory & Quality Controls: Verified against Ethiopian commercial and tax regulations or technical engineering specifications.

Step 3: Operational Execution & State Progression#

  • State Progression Gate: Advance record from Draft through Confirmed to Completed / Posted.
  • Integrated System Impact: Automatically updates inventory stock quants, customer receivables, or work-in-progress cost accounting ledgers.
  • Audit Verification: System registers tamper-evident audit records logging user ID, timestamp, and cryptographic transaction digests.

Core Reports#

1. Sales Pipeline Funnel Analysis#

Visualizes deal volume and conversion rates across stages:

  • Inbound Lead Velocity.
  • Stage Conversion Ratios (Qualified → Proposition → Won).
  • Average Deal Cycle Duration (in calendar days).

2. Customer Aged Receivables Report#

Categorizes unpaid commercial sales invoices:

  • Current (0–30 Days)
  • 31–60 Days Overdue
  • 61–90 Days Overdue
  • 90+ Days (Critical Credit Review)

3. Product Profitability & Margin Matrix#

  • Compares Invoiced Revenue against Cost of Goods Sold (COGS).
  • Realized Gross Margin percentage per product category and customer sector.

4. Advanced Configuration Points#

  • Automated Actions & Scheduled Tasks (Crons):
    • CRM: Lead auto-assignment (crm.ir_cron_lead_assign): Runs hourly to allocate unassigned leads across sales teams
    • Sales: Expire overdue quotations (sale.ir_cron_expire_quotes): Runs nightly to mark stale quotes as cancelled
    • POS: Close abandoned register sessions (point_of_sale.ir_cron_session_cleanup): Runs nightly to alert managers of open cashier terminals
  • Custom Print Templates & Reports:
    • Customer Sales Quotation / Pro-forma Invoice
    • Commercial Tax Invoice (Model 85 Compliant)
    • POS Cash Register Receipt with QR Validation
    • Customer Credit Limit & Receivables Aging Statement
  • 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
Credit Limit Blocked: Customer balance exceeds ceilingOutstanding customer debt plus current order exceeds approved credit limit.Obtain credit committee exception approval or collect an advance cash payment.
Validation Error: Tax definition missing on product lineProduct item lacks default statutory 15% VAT mapping.Update the product master accounting tab with standard statutory VAT rates.
POS Session Error: Cash register mismatch upon closurePhysical cash count does not reconcile with POS recorded register balance.Document discrepancy explanation in the closing wizard and submit for manager review.
Payment Gateway Error: Telebirr timeoutNetwork timeout or invalid API bridge credentials.Verify merchant credentials in Invoicing → Configuration → Payment Providers and retry transaction query.

Next#

Last updated: 2026-11-15