Sales cockpits and revenue reports

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.

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

{screenshot:reports-and-dashboards-overview-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 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 Sales app icon.
4. From the top navigation bar, open Sales → Orders → Quotations / Orders; Point of Sale → Dashboard.

{screenshot:reports-and-dashboards-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:
   • Customer Name (Mandatory): Registered partner record with complete invoicing and delivery addresses
   • Product Lines (Mandatory): Saleable items with approved commercial pricelist rates and VAT classification
   • Payment Terms (Mandatory): Immediate settlement, milestone advance, or agreed commercial credit terms
   • Salesperson (Mandatory): Account executive responsible for the customer commercial relationship
3. Configure optional operational parameters and localized tags as required:
   • Analytic Account (Optional): Revenue center or project allocation for commercial tracking
   • Customer PO Reference (Optional): External purchase order number issued by the client
   • Shipping Policy (Optional): Deliver all products at once or allow partial dispatches
4. Click the Save icon in the control bar to commit the record.

{screenshot:reports-and-dashboards-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Quotation → Sent → Confirmed Sales Order → Delivery Done → Invoiced → Paid).
• Ledger & System Impact: Generates customer tax invoice, posts accounts receivable debit and sales revenue credit, and updates inventory valuation upon delivery.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:reports-and-dashboards-transaction-processing-state}

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#

Next#

• Roles: Roles and permissions.