OdooWiki OCA HUB

Sale Commission Formula

sale_commission_formula folder_open OCA/commission open_in_new
Sale License: AGPL-3

This module extends sale_commission to introduce the use of formulas to compute the agent commissions.

auto_awesome What this module does

AI-generated from the code · Odoo 14.0

Adds a new "Formula" commission type so you can write a custom calculation for agent commissions on sales orders and invoices, instead of using the standard percentage or fixed amount rules.

This module extends the commission setup in Odoo so that a commission can be calculated with a formula you write yourself.

  • On the commission form (Sales > Configuration > Commissions), a new option "Formula" appears in the Commission Type field. When selected, a Formula text box and an Instructions panel become visible.
  • The instructions explain that you use line to access the fields of the sales order line or invoice line, and result to return the commission amount. They also list common fields such as discount, price_subtotal, price_unit, quantity and product_uom_qty, and warn that field names differ between sales order lines and invoice lines, so you should test the line type (for example line._name == 'sale.order.line' or line._name == 'account.move.line').
  • When a commission line is computed, the module evaluates the formula and uses the returned value as the commission amount. If the product is marked as commission free, or the commission is not of type Formula, the standard calculation from the base commission module is used instead.
  • A demo commission called "5% + 10% extra" is included to show how a formula can combine a percentage with an extra percentage.

The module touches sale.commission and the commission line mixin used by sales orders and invoices.

Depends on

Models and fields (2)
  • sale.commission · extends an existing modelformula (Formula), commission_type
  • sale.commission.line.mixin · extends an existing model

Text generated by AI (DeepSeek) from reading the Odoo 14.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 with no information of 9 versions.

Sources · Odoo 14.0

Confirmed on 2026-11-03 in branch 14.0 of OCA/commission.

terminal Installation and usage

OCA documentation · Odoo 14.0

To use this module, you need to:

  • Go to Sales, Commission Types and create a commission with type formula

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.