KPI Guide:Open Order Book — All prior year orders not yet invoiced; unsettled orders carry forward each yearTotal Booking — New orders booked in selected FYOpen Orders Total — Open Order Book + Total Booking (full pipeline)Invoiced — Orders billed in selected FY (any origin year)Orders Closed — Completed & paid ordersAvg Margin — Weighted GP% on selected ordersNet Margin on Invoiced — Gross profit earned on invoiced value in selected FYExecutable Backlog — Open Orders Total − Invoiced YTD − Spill-over to next FYRevenue 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 & paidPayment Pending — invoiced, awaiting paymentActive — order in progress★Spill-over from prior FY🔗 Source: SAP B1 — auto-synced
🔍
🔍
Revenue Phasing
Current FYHigh valueSpill-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 colourConverted to RFQRegret (lost)New / Active
① CRM Dashboard
→
② CRM Register
→
③ RFQ Register
→
④ Sales Register (SAP Booking)
RFQ Register
Row colourWonLost / DropActive / HoldPO Number ↔ SAP Customer PO — see README for the known matching caveat