Sales Intelligence Portal
AKAI
Sales Order Register
KPI Guide: Open Order Book — All prior year orders not yet invoiced; unsettled orders carry forward each year Total Booking — New orders booked in selected FY Open Orders Total — Open Order Book + Total Booking (full pipeline) Invoiced — Orders billed in selected FY (any origin year) Orders Closed — Completed & paid orders Avg Margin — Weighted GP% on selected orders Net Margin on Invoiced — Gross profit earned on invoiced value in selected FY Executable Backlog — Open Orders Total − Invoiced YTD − Spill-over to next FY Revenue Target — Manual revenue target for current FY (enter in save bar) Revenue Shortfall — Target − (Invoiced YTD + Executable Backlog)
① CRM Dashboard
→
② CRM Register
→
③ RFQ Register
→
④ Sales Register (SAP Booking)
Sales Register
ROW COLOUR: Closed — completed & paid Payment Pending — invoiced, awaiting payment Active — order in progress ★Spill-over from prior FY
Revenue Phasing
Current FY High value Spill-over ✓Balanced -valUnder-phased
Cashflow
ACCOUNTS RECEIVABLE
Monthly AR Summary
Order-Level GP Detail —
① CRM Dashboard
→
② CRM Register
→
③ RFQ Register
→
④ Sales Register (SAP Booking)
◆
Pipeline health at a glance. These figures cover every CRM prospect synced from Odoo for Adage Kanoo Analytical Industry — how much is still in play, where it sits, and how it's actually converting into won RFQs and booked SAP orders below.
Pipeline Overview —
Snapshot of all synced prospects right now — value still open, how many are active, and how many were lost.
Sales Funnel — Prospect → RFQ → SAP Booking —
Follows the same records end to end: a prospect becomes an RFQ (via Odoo's Linked CRM Lead field), an RFQ is Won or Lost, and a Won RFQ is matched to its real SAP order by PO number. Every stage below only counts records traceable back to a CRM prospect — not raw SAP/Odoo totals. Click any card or bar to jump to the underlying records.
Conversion Funnel
Record count at each stage. The gap between bars is the actual drop-off.
Value Waterfall (AED)
How the deal's estimated value compares to what was actually won and booked.
Revenue Forecast — By Expected Close
What open pipeline is expected to close, and when — based on each prospect's Expected Closing date. Regret (lost) prospects are excluded.
Expected Close Value by Month (AED)
Open pipeline value grouped by the month it's expected to close.
① CRM Dashboard
→
② CRM Register
→
③ RFQ Register
→
④ Sales Register (SAP Booking)
CRM Register
Row colour Converted to RFQ Regret (lost) New / Active
① CRM Dashboard
→
② CRM Register
→
③ RFQ Register
→
④ Sales Register (SAP Booking)
RFQ Register
Row colour Won Lost / Drop Active / Hold PO Number ↔ SAP Customer PO — see README for the known matching caveat