asao-erp

Odoo Community from Python, through a verified command line. Read, group, page, print PDFs and browse the operation catalog, for notebooks, scripts and staff statistics, and review a period's books for mistakes, duplicates and signs of fraud.

from asao_erp import Client, ops, to_frame

erp = Client(profile="my-odoo")          # odoo-cli and its local profile
monthly = erp.group(ops.sales.quotation_list, by=["date_order:month"],
                    aggregate=["amount_total:sum"], filter=[["state", "=", "sale"]])
to_frame(monthly)

Odoo is a registered trademark of Odoo S.A. This project is not affiliated with or endorsed by Odoo S.A.

Install

pip install asao-erp            # or: pip install 'asao-erp[pandas]'

asao-erp holds no credential and never calls Odoo itself: every call goes through a command line, so the catalog's checks, readiness rules and refusals apply exactly as on the command line. Install the command line too, either of:

• odoo-cli, for an Odoo you configure locally: Client(profile="my-odoo"). Set the profile up once with odoo-cli profile set; the credential stays in the environment or the OS keyring, never in your notebook.
• The governed asao CLI, for an ASAO organization: Client(organization="...", connection="..."). Calls then act with the caller's ASAO login, within the permissions their role grants: reads, and, with a domain's write key, the verified writes. A high-risk one (posting, payments, rates) runs only after a colleague approves the exact request (asao aerp approval request, then approve); deletes and prints stay with odoo-cli.

Name a binary that is not on PATH with binary= or ASAO_ERP_CLI.

Use

ops lists every operation by domain, so the editor completes them (ops.finance.invoice_list). A failure raises ErpError with the command line's code, message and remediation.

Review the books of a period

review() runs odoo-cli review run (odoo-cli 0.10.0 or later) and returns the report it computes: bills or payments entered twice, duplicate partners, a supplier paid into an employee's account, orders split under an approval threshold, sales below cost, refunds after payment, expense claims twice or on leave, valuable scrap, overdue receivables, and the period's figures month by month.

report = erp.review("2026-07-01", "2026-09-30", params={"O01": {"window_days": 10}})
to_frame(report["findings"])   # check, severity, title, why, formula, thresholds, the records behind it
report["checks"]               # which checks ran, and why any did not
report["figures"]              # revenue, margin, purchases, cash in and out, by month

It only reads. A finding is a sign to look at again, never a verdict. The formulas live in odoo-cli, not in the SDK, so a script, a notebook and an agent read the same findings; odoo-cli review checks lists each check's formula and thresholds. It runs on a profile (Client(profile=...)); the governed asao CLI has no review yet.

What is verified, and what is not

The catalog's operations are verified on the stock Odoo Community image: 1285 on 19.0, and 1170 on 20.0, a candidate series that runs only with allow_unverified=True until it is supported. A public conformance run checks them again every week. Before each call, the command line checks the Odoo it reaches:

• Is it Odoo, and which series?
• Are the needed modules installed?
• Is it customised where a write acts?

A write on a customised Odoo is held back (AERP_ENVIRONMENT_UNVERIFIED). It runs only with allow_unverified=True.

Odoo Online and Enterprise. The SDK reaches them through odoo-cli and the JSON-2 API (an API key of scope RPC; Odoo Online offers the external API on its Custom plan only). Reads run there, marked unverified, and group() works there as on Community; see odoo-cli's page on them.

Customised Odoo is not guaranteed. On an Odoo changed beyond the stock image (Enterprise, third-party or in-house modules, Studio, automations, fields added by hand), operations cannot be verified, and nothing guarantees that they work as described or without error. What you accept there runs at your own risk.

Develop

python -m unittest discover -s tests     # a fake command line, no network

examples/vscode/ is a sample VS Code workspace with a statistics notebook.

This repository is exported from the ASAO monorepo (see SOURCE.md). Issues and pull requests are welcome. An accepted change is applied in the monorepo and arrives with the next export.

License

Apache License 2.0. See LICENSE and NOTICE.

Tiếng Việt

asao-erp cho phép làm việc với Odoo Community bằng Python: đọc, gộp nhóm, phân trang, in PDF và tra catalog. Thư viện hợp cho notebook và cho nhân viên làm thống kê. Mọi lệnh đi qua odoo-cli (profile cục bộ) hoặc asao (theo tổ chức ASAO). SDK không giữ mật khẩu.

ASAO chỉ kiểm chứng trên bản Odoo chuẩn. Với Odoo đã tuỳ biến, ASAO không bảo đảm thao tác chạy đúng; dùng allow_unverified=True trên Odoo đó là tự chịu rủi ro.

Từ bản 0.2.0, review() rà soát sổ sách một kỳ qua odoo-cli review run (odoo-cli 0.10.0 trở lên): hoá đơn hay khoản chi nhập hai lần, đối tác trùng, trả tiền nhà cung cấp vào tài khoản nhân viên, chia nhỏ đơn dưới ngưỡng duyệt, bán dưới giá vốn, công nợ quá hạn, và số liệu từng tháng. Mỗi phát hiện là dấu hiệu cần xem lại, không phải kết luận, và kèm công thức, ngưỡng cùng chứng từ. Công thức nằm trong odoo-cli, không nằm trong SDK.