Bỏ qua tới nội dung
TakoAPI
Quay lại kỹ năng

odoo-reporting

bởi ashrf-in

Marketing & Sales
455Lượt tải do clawskills.sh công bố
0Lượt xem
0 lượt thíchĐăng nhập để thích kỹ năng này
—Chưa có đánh giá
Đánh giá của bạn

Tóm tắt

Query Odoo data including salesperson performance, customer analytics, orders, invoices, CRM, accounting, VAT.

Mô tả

Kỹ năng này làm gì

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.

Khi nào nên dùng

  • 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

Quy trình ví dụ

ĐẦU VÀO

User asks: How is Ahmed's sales performance this quarter?

AGENT
  1. 1

    Search res.users for a user matching 'Ahmed' to retrieve their user_id

  2. 2

    Query sale.order filtered by user_id for the quarter date range, aggregate order count and total amount

  3. 3

    Query account.move for posted invoices linked to that salesperson and check payment_state

  4. 4

    Generate a KPI WhatsApp card with orders, revenue, and invoice collection rate

ĐẦU RA

1080x1080 PNG card showing Ahmed's order count, total revenue, and invoice payment status for the quarter

Yêu cầu

  • 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

Cài đặt

clawhub install ashrf-in/odoo-reporting

Chạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.

Liên kết