odoo-reporting
oleh ashrf-in
Marketing & SalesRingkasan
Query Odoo data including salesperson performance, customer analytics, orders, invoices, CRM, accounting, VAT.
Deskripsi
Apa yang Dilakukan Skill Ini
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.
Kapan Menggunakannya
- 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
Contoh Alur Kerja
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
Persyaratan
- 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
Instalasi
clawhub install ashrf-in/odoo-reportingJalankan perintah CLI-nya, atau tempel prompt ke Claude Code, Cursor, Codex, atau coding agent apa pun yang Anda pakai.