Sale Commission Extended

Sales and collection commissions with aging, absolute sections and ECharts dashboard

Module functionalities

• For each achievement rule: tax base or total with taxes
• Applies to sales (amount_sold) and billing (amount_invoiced)
• And also to the new type of collection (amount_collected)
• Optimized SQL directly in the achievement report
• New achievement type: Amount raised
• Based on payments actually reconciled with invoices
• Source: account.partial.reconcile on accounts receivable
• Achievement date = actual payment date
• Filter by days elapsed between invoice date and payment date
• Fields: payment_delay_min and payment_delay_max
• Allows ranges such as 0-60, 60-90 and >90 days
• Each section defines its own commission percentage
• New target_mode field: % compliance or absolute amount
• Commission ladder for real values ​​(e.g. <400M, 400-700M, >700M)
• Step function: the section to which the achievement reached is paid
• Ideal for committees of management positions
• New commission_basis field: fixed amount or % of what was achieved
• Supports all four combined modes
• Calculation: achieved × percent_rate in the applied section
• Avoid having to pre-estimate the OTC
• First item on the Commissions menu
• 6 KPIs, 6 graphs (bars, line, donut, aging, compliance, etc.)
• Date range filter
• Lazy loading: only the bundle is downloaded when opened
• Sales (SO) — achievement for confirmed orders
• Invoicing / Adjustments — achievement via invoices and manual adjustments
• Actual collection — payments reconciled to invoices
• Total commission calculated
• Number of sellers and average commission per seller
• Average % compliance
• Combined monthly evolution (sales/billing bars + collection and commission lines)
• Top 10 Salespeople by Commission and Achievement (Horizontal Bars)
• Commission per plan (donut)
• Aging collection 0‑60 / 60‑90 / >90 days (donut)
• % Compliance by seller (bars with red-green visualMap and goal line 100%)
• Sales achieved vs Monthly goal (grouped bars)
• Extends the sale.commission.plan, sale.commission.plan.achievement, and sale.commission.plan.target.commission models.
• Overrides the SQL of the sale.commission.achievement.report and sale.commission.report reports.
• JSON-RPC Controller: /sale_commission_extended/dashboard_data.
• Frontend in OWL 2 with Apache ECharts 6 (local library, without CDN).
• Lazy loading via loadBundle() — bundle sale_commission_extended.dashboard_assets.
• Depends on: sale_commission, account, web.
• Sales (sales)
• Accounting
• Sale Commission — Enterprise (sale_commission)
• Web (web)
• Commission plans set up
• Salespeople assigned to plans
• Invoices and payments reconciled for collection
• Targets (target_ids) per period

Specs

What is included with Mi-ERP