sale.report: fields, relations and API
The sale.report model ("Sales Analysis Report") is a persistent model declared by the Sales module, then extended by 7 other modules. It exposes 57 fields, 51 of them declared directly on the model. Below you will find every field with its technical name, type, label and relations, followed by an Odoo 20 JSON-2 API call.
Model identity
- Technical name
sale.report- Label
- Sales Analysis Report
- Type
- Persistent (models.Model)
- SQL table
- None (no table)
- Origin module
- Sales (
sale) - Extended by
- sale_project, sale_stock, pos_sale, sale_margin, pos_sale_margin, pos_sale_stock, website_sale
- Default order (_order)
date desc- Display field (_rec_name)
date
Model fields
51 own fields, 0 inherited from mixins and 6 automatic ORM fields. Click a name to get a direct link to that field.
57 of 57 fields shown
| Technical name | Label | Type | Details |
|---|---|---|---|
| campaign_id | Campaign | many2one | read-only |
| categ_id | Product Category | many2one | read-only |
| commercial_partner_id | Customer Entity | many2one | read-only |
| company_id | Company | many2one | read-only |
| country_id | Customer Country | many2one | read-only |
| currency_id | Currency | many2one | read-only |
| date | Order Date | datetime | read-only |
| discount | Discount % | float | read-only |
| discount_amount | Discount Amount | monetary | read-only |
| industry_id | Customer Industry | many2one | read-only |
| invoice_status | Order Invoice Status | selection | read-only Values: |
| is_abandoned_cart | Abandoned Cart | boolean | read-only added by eCommerce ( |
| line_invoice_status | Invoice Status | selection | read-only Values: |
| line_name | Order Line Name | char | read-only |
| margin | Margin | monetary | read-only added by Margins in Sales Orders ( |
| margin_percent | Margin (%) | float | read-only added by Margins in Sales Orders ( |
| medium_id | Medium | many2one | read-only |
| name | Order Reference | char | read-only |
| nbr | # of Lines | integer | read-only |
| order_reference | Order | reference | |
| partner_id | Customer | many2one | read-only |
| partner_tag_ids | Customer Tags | many2many | read-only related: |
| partner_zip | Customer ZIP | char | read-only |
| price_subtotal | Untaxed Total | monetary | read-only |
| price_total | Total | monetary | read-only |
| price_unit | Unit Price | monetary | read-only |
| pricelist_id | Pricelist | many2one | read-only |
| product_id | Product Variant | many2one | read-only |
| product_tmpl_id | Product | many2one | read-only |
| product_uom_id | Unit | many2one→ uom.uom | read-only |
| product_uom_qty | Qty Ordered | float | read-only |
| project_id | Project | many2one | read-only added by Sales - Project ( |
| public_categ_ids | eCommerce Categories | many2many | related: added by eCommerce ( |
| purchase_price | Expected Cost | monetary | read-only added by Margins in Sales Orders ( |
| qty_delivered | Qty Delivered | float | read-only |
| qty_invoiced | Qty Invoiced | float | read-only |
| qty_to_deliver | Qty To Deliver | float | read-only |
| qty_to_invoice | Qty To Invoice | float | read-only |
| source_id | Source | many2one | read-only |
| state | Status | selection | read-only Values: |
| state_id | Customer State | many2one | read-only |
| team_id | Sales Team | many2one→ crm.team | read-only |
| untaxed_amount_invoiced | Untaxed Amount Invoiced | monetary | read-only |
| untaxed_amount_to_invoice | Untaxed Amount To Invoice | monetary | read-only |
| untaxed_delivered_amount | Untaxed Amount Delivered | monetary | read-only |
| user_id | Salesperson | many2one | read-only |
| utm_reference | UTM Reference | reference | |
| volume | Volume | float | read-only |
| warehouse_id | Warehouse | many2one | read-only added by Sales and Warehouse Management ( |
| website_id | Website | many2one→ website | read-only added by eCommerce ( |
| weight | Gross Weight | float | read-only |
| create_date | Created on | datetime | read-onlyautomatic |
| create_uid | Created by | many2one | read-onlyautomatic |
| display_name | Display Name | char | read-onlycomputedautomatic |
| id | ID | integer | read-onlyautomatic |
| write_date | Last Updated on | datetime | read-onlyautomatic |
| write_uid | Last Updated by | many2one | read-onlyautomatic |
Relations
Models linked from this model
- crm.team: team_id
- product.category: categ_id
- product.pricelist: pricelist_id
- product.product: product_id
- product.public.category: public_categ_ids
- product.template: product_tmpl_id
- project.project: project_id
- res.company: company_id
- res.country: country_id
- res.country.state: state_id
- res.currency: currency_id
- res.partner: commercial_partner_id, partner_id
- res.partner.category: partner_tag_ids
- res.partner.industry: industry_id
- res.users: user_id
- stock.warehouse: warehouse_id
- uom.uom: product_uom_id
- utm.campaign: campaign_id
- utm.medium: medium_id
- utm.source: source_id
- website: website_id
Fields of other models pointing here
No Many2one or Many2many field of another model points to this model.
Reading this model through the API
Odoo 20 JSON-2 API call reading the first five records with real fields of the model. Replace the instance, database and API key with your own.
curl -X POST "https://your-instance.odoo.com/json/2/sale.report/search_read" \
-H "Authorization: bearer $ODOO_API_KEY" \
-H "X-Odoo-Database: your-db" \
-H "Content-Type: application/json" \
-d '{"domain":[],"fields":["date","state","campaign_id","categ_id","commercial_partner_id"],"limit":5}'import requests
BASE_URL = "https://your-instance.odoo.com/json/2"
headers = {"Authorization": f"bearer {API_KEY}", "X-Odoo-Database": "your-db"}
res = requests.post(
f"{BASE_URL}/sale.report/search_read",
headers=headers,
json={"domain": [], "fields": ["date","state","campaign_id","categ_id","commercial_partner_id"], "limit": 5},
)
res.raise_for_status()
print(res.json())- External API access requires Odoo's Custom plan.
- XML-RPC and JSON-RPC will be removed in Odoo 22 (fall 2028): use JSON-2.
- The access rights and record rules of the key's user apply.
Cite this tool
Writing a tutorial, internal documentation or a forum answer? Copy this link to send your readers to the up-to-date reference.
<a href="https://aidoo.ai/en/outils/explorateur-modeles-odoo/sale-report">sale.report (Odoo 20.0)</a>Sources
Data verified on September 25, 2026 · Odoo 20.0 Community
Have an Odoo project, or want to put your ERP to work with AI? Let's talk
Implementation, custom module development, connecting Claude or ChatGPT to your data: tell us about your context and we will reply within 24 business hours.