Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
2349 Vistas

I would like to know how to set up a commission system in Odoo to automatically calculate commissions for each sales representative and integrate it into their monthly payslips.

Avatar
Descartar
Mejor respuesta

Setting up an automatic commission system in Odoo and linking it to payslips involves leveraging Odoo's SalesHR, and Payroll modules. Below is a step-by-step guide to implement this workflow:

Step 1: Define the Commission Rules

First, define how commissions are calculated for your sales representatives:

  • Percentage-based: A percentage of the sales amount.
  • Fixed amount: A fixed amount per sale.
  • Tiered structure: Different percentages based on the total sales achieved.

Step 2: Set Up Commission Calculation

Option 1: Use Odoo Studio (No Coding Required)

  1. Add a Commission Field to Sales Orders:
    • Activate Odoo Studio.
    • Go to Sales > Orders > Sales Orders.
    • Add a field (e.g., x_commission_amount) to calculate the commission amount:
      • Field Type: Monetary
      • Compute: (record.amount_total * 0.10) for 10% commission.
  2. Add a Salesperson Field to the Invoice:
    • Ensure each sales order/invoice has a related salesperson (user_id field).
  3. Enable Commission Tracking on Invoices:
    • Add a computed field to track the salesperson’s total commissions.

Option 2: Create a Custom Commission Module

If Odoo Studio isn't flexible enough, create a custom module to compute commissions:

  1. Extend the Sales Order Model: Add a computed field for commission based on the order's total.
    pythonCopy codefrom odoo import models, fields, api
    
    class SaleOrder(models.Model):
        _inherit = 'sale.order'
    
        commission_amount = fields.Monetary(
            string="Commission",
            compute="_compute_commission",
            store=True,
        )
    
        @api.depends('amount_total', 'user_id')
        def _compute_commission(self):
            for order in self:
                commission_rate = 0.10  # Example: 10% commission
                order.commission_amount = order.amount_total * commission_rate
    
  2. Aggregate Monthly Commissions: Add a model or logic to calculate monthly commissions for each salesperson:
    pythonCopy codeclass MonthlyCommission(models.Model):
        _name = 'sales.commission'
    
        salesperson_id = fields.Many2one('res.users', string="Salesperson")
        commission_total = fields.Float(string="Total Commission")
        month = fields.Date(string="Month")
    

Step 3: Link Commissions to Payslips

Odoo's Payroll module allows custom salary rules, which can be used to integrate commissions into payslips.

Set Up a Salary Rule for Commissions:

  1. Go to Payroll > Configuration > Salary Rules.
  2. Create a New Salary Rule:
    • Name: Commission
    • Code: COMMISSION
    • Category: Allowance
    • Condition: Always True
    • Amount Type: Python Code
    • Python Code:
      pythonCopy coderesult = employee.contract_id.commission_amount or 0.0
      
  3. Add a Field in Employee Contract:
    • Go to Employees > Contracts.
    • Add a new field for commission_amount (either using Studio or custom code).
    • Populate this field with the total commission calculated for the period.

Automate Monthly Commission Updates:

  1. Calculate Monthly Commissions: Write a scheduled job to update each salesperson's commission_amount field based on their sales for the month:
    pythonCopy codefrom odoo import models, fields, api
    from datetime import datetime
    
    class EmployeeContract(models.Model):
        _inherit = 'hr.contract'
    
        commission_amount = fields.Float(string="Monthly Commission")
    
        @api.model
        def update_commission(self):
            sales_data = self.env['sales.commission'].read_group(
                [('month', '=', datetime.today().strftime('%Y-%m'))],
                ['salesperson_id', 'commission_total'],
                ['salesperson_id']
            )
            for data in sales_data:
                contract = self.search([('employee_id.user_id', '=', data['salesperson_id'][0])], limit=1)
                if contract:
                    contract.commission_amount = data['commission_total']
    
  2. Schedule the Job:
    • Go to Settings > Technical > Automation > Scheduled Actions.
    • Create a new scheduled action to run the update_commission method monthly.

Step 4: Generate Payslips

Once the commission field is populated in the employee’s contract, it will automatically appear in their payslips:

  1. Go to Payroll > Payslips > Generate Payslips.
  2. Select the employees and generate payslips.
  3. The Commission rule will calculate the commission and add it to the payslip.

Step 5: Reporting

To track commissions:

  1. Sales Report:
    • Use Odoo's Sales Analysis report to track total sales and commissions.
    • Add a custom measure for commission_amount.
  2. Payroll Report:
    • Use Payroll Analysis to view commissions included in payslips.

Summary

This setup will allow you to:

  1. Automatically calculate commissions for each salesperson based on sales orders.
  2. Aggregate monthly commissions.
  3. Link commissions to employee payslips via salary rules.
  4. Provide clear reports for tracking commissions and payouts.

Avatar
Descartar
Autor Mejor respuesta

Thank you so much

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
jul 25
771
0
may 25
5
1
ago 17
5158
2
jul 25
787
1
feb 25
1317