Odoo model
sale.report
Sales Analysis Report. Defined in module sale; exists in Odoo 16, 17, 18, 19, 20. Across the upgrade steps we tracked: 16 fields added, 2 removed, 1 renamed, 7 type changes.
- Odoo 16 sale
- Odoo 17 sale
- Odoo 18 sale
- Odoo 19 sale
- Odoo 20 sale
Fields removed (1)
| Field | Type | Module | Notes |
|---|---|---|---|
| order_id | many2one | sale |
Fields added (6)
| Field | Type | Module |
|---|---|---|
| currency_id | many2one | sale |
| invoice_status | selection | sale |
| is_abandoned_cart | boolean | website_sale |
| order_reference | reference | sale |
| partner_zip | char | sale |
| state_id | many2one | sale |
Type changed (5)
| Field | Odoo 16 | Odoo 17 |
|---|---|---|
| discount_amount | float | monetary |
| price_subtotal | float | monetary |
| price_total | float | monetary |
| untaxed_amount_invoiced | float | monetary |
| untaxed_amount_to_invoice | float | monetary |
Fields removed (1)
| Field | Type | Module | Notes |
|---|---|---|---|
| analytic_account_id | many2one | sale |
Fields added (3)
| Field | Type | Module |
|---|---|---|
| line_invoice_status | selection | sale |
| price_unit | float | sale |
| project_id | many2one | sale_project |
Renamed (1)
| Odoo 18 | Odoo 19 | Confidence |
|---|---|---|
| product_uom | product_uom_id | possible (same type, name extended) |
Fields added (1)
| Field | Type | Module |
|---|---|---|
| public_categ_ids | many2many | website_sale |
Fields added (6)
| Field | Type | Module |
|---|---|---|
| line_name | char | sale |
| margin_percent | float | sale_margin |
| partner_tag_ids | many2many | sale |
| purchase_price | monetary | sale_margin |
| untaxed_delivered_amount | monetary | sale |
| utm_reference | reference | sale |
Type changed (2)
| Field | Odoo 19 | Odoo 20 |
|---|---|---|
| margin | float | monetary |
| price_unit | float | monetary |
All fields declared on sale.report (56)
Fields this model declares itself in any version, with the versions they exist in. Inherited fields (mail.thread and other mixins) are on the parent model's page.
present not present not covered (Enterprise, Odoo 16 and 17)
Show all 56 fields
| Field | Type | Label | Module | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|
| analytic_account_id | many2one account.analytic.account | Analytic Account | sale | |||||
| campaign_id | many2one utm.campaign | Campaign | sale | |||||
| categ_id | many2one product.category | Product Category | sale | |||||
| commercial_partner_id | many2one res.partner | Customer Entity | sale | |||||
| commission_plan_id | many2one commission.plan | partner_commissionE | ||||||
| company_id | many2one res.company | Company | sale | |||||
| country_id | many2one res.country | Customer Country | sale | |||||
| currency_id | many2one res.currency | sale | ||||||
| date | datetime | Order Date | sale | |||||
| discount | float | Discount % | sale | |||||
| discount_amount | monetary | Discount Amount | sale | |||||
| industry_id | many2one res.partner.industry | Customer Industry | sale | |||||
| invoice_status | selection | Order Invoice Status | sale | |||||
| is_abandoned_cart | boolean | Abandoned Cart | website_sale | |||||
| line_invoice_status | selection | Invoice Status | sale | |||||
| line_name | char | Order Line Name | sale | |||||
| margin | monetary | Margin | sale_margin | |||||
| margin_percent | float | Margin (%) | sale_margin | |||||
| medium_id | many2one utm.medium | Medium | sale | |||||
| name | char | Order Reference | sale | |||||
| nbr | integer | # of Lines | sale | |||||
| order_id | many2one sale.order | Order # | sale | |||||
| order_reference | reference | Order | sale | |||||
| partner_id | many2one res.partner | Customer | sale | |||||
| partner_tag_ids | many2many | Customer Tags | sale | |||||
| partner_zip | char | Customer ZIP | sale | |||||
| price_subtotal | monetary | Untaxed Total | sale | |||||
| price_total | monetary | Total | sale | |||||
| price_unit | monetary | Unit Price | sale | |||||
| pricelist_id | many2one product.pricelist | Pricelist | sale | |||||
| product_id | many2one product.product | Product Variant | sale | |||||
| product_tmpl_id | many2one product.template | Product | sale | |||||
| product_uom | many2one uom.uom | Unit of Measure | sale | |||||
| product_uom_id | many2one uom.uom | Unit | sale | |||||
| product_uom_qty | float | Qty Ordered | sale | |||||
| project_id | many2one project.project | sale_project | ||||||
| public_categ_ids | many2many | eCommerce Categories | website_sale | |||||
| purchase_price | monetary | Expected Cost | sale_margin | |||||
| qty_delivered | float | Qty Delivered | sale | |||||
| qty_invoiced | float | Qty Invoiced | sale | |||||
| qty_to_deliver | float | Qty To Deliver | sale | |||||
| qty_to_invoice | float | Qty To Invoice | sale | |||||
| referrer_id | many2one res.partner | Referrer | partner_commissionE | |||||
| source_id | many2one utm.source | Source | sale | |||||
| state | selection | Status | sale | |||||
| state_id | many2one res.country.state | Customer State | sale | |||||
| team_id | many2one crm.team | Sales Team | sale | |||||
| untaxed_amount_invoiced | monetary | Untaxed Amount Invoiced | sale | |||||
| untaxed_amount_to_invoice | monetary | Untaxed Amount To Invoice | sale | |||||
| untaxed_delivered_amount | monetary | Untaxed Amount Delivered | sale | |||||
| user_id | many2one res.users | Salesperson | sale | |||||
| utm_reference | reference | UTM Reference | sale | |||||
| volume | float | Volume | sale | |||||
| warehouse_id | many2one stock.warehouse | Warehouse | sale_stock | |||||
| website_id | many2one website | website_sale | ||||||
| weight | float | Gross Weight | sale |
Related models
Coverage.
Odoo 16 to 17 and 17 to 18 compare Community modules only (the Enterprise 16 and 17 sources
are not available to us). Odoo 18 to 19 and 19 to 20 include Community and Enterprise modules.
Everything here comes from a static read of the Odoo source code: a field counts as removed only when no
parent model, mixin or delegated model still provides it. Fields created dynamically at run time can be
missed, and entries we could not confirm are marked as low confidence.
Planning an Odoo upgrade?
Odoo app
Check your own database: Studio Upgrade Checker
Scans your Studio fields, views, automations and custom code for everything listed here before you upgrade.
See it on the Odoo Apps store
Odoo app
Fix broken views: Studio View Repair Assistant
Finds views that stopped loading after an upgrade and helps you repair the xpaths and fields they point at.
See it on the Odoo Apps store
Upgrade service
Need the upgrade done? Book a call
We move databases between major Odoo versions, port custom modules and validate the data.
Book a call
Free
Free upgrade scan, we run it for you
Send us a copy of your database or give us access and we report what will break on the target version.
Ask for a scan