odoo-reporting
par ashrf-in
Marketing & SalesRésumé
Query Odoo data including salesperson performance, customer analytics, orders, invoices, CRM, accounting, VAT.
Description
Ce que fait ce skill
Connects to an Odoo instance via XML-RPC or JSON-RPC to query sales orders, invoices, journal entries, CRM records, and accounting data. Reports are generated locally as WhatsApp cards (PNG), PDFs, or Excel files. All operations are strictly read-only.
Reports pull directly from account.move.line and the chart of accounts rather than Odoo's summary views, so balance sheets balance correctly including proper treatment of Odoo's current-year earnings suspense account.
Quand l'utiliser
- Check a salesperson's order count and invoiced revenue for a given quarter
- Run AR aging to identify which customer invoices are overdue by bucket
- Generate a one-page CFO executive summary for a monthly finance review
- Compare revenue vs expenses across two custom date ranges
- Find top customers by revenue for a specific period or salesperson
Exemple de workflow
User asks: How is Ahmed's sales performance this quarter?
- 1
Search res.users for a user matching 'Ahmed' to retrieve their user_id
- 2
Query sale.order filtered by user_id for the quarter date range, aggregate order count and total amount
- 3
Query account.move for posted invoices linked to that salesperson and check payment_state
- 4
Generate a KPI WhatsApp card with orders, revenue, and invoice collection rate
1080x1080 PNG card showing Ahmed's order count, total revenue, and invoice payment status for the quarter
Prérequis
- Odoo instance URL, database name, and user account (ODOO_URL, ODOO_DB, ODOO_USER)
- Odoo API key or account password (ODOO_PASSWORD) — API key generated from Odoo Settings > Account Security > API Keys
Installation
clawhub install ashrf-in/odoo-reportingExécute la commande CLI, ou colle l'instruction dans Claude Code, Cursor, Codex ou l'agent de code que tu utilises.