Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.

Module: Invoicing

Entity: res.partner

Compute Method: _invoice_total

Inputs Method Outputs
  • id
"""Compute the total amount invoiced to the partner. Multiple currencies may have been linked to the invoices, then it
        is important to define a unique currency to compute the total amount otherwise this one is meaningless. This currency
        is either the one of the partner's company if they have one or the currency of the environment's company."""
if self.ids:
            query_res = self.env.execute_query(SQL(
                """SELECT move.partner_id, SUM(move.amount_total_signed * COALESCE(currency_rate.rate, 1))
                     FROM account_move move
                     LEFT JOIN res_partner partner
                       ON partner.id = move.partner_id
                     LEFT JOIN res_company company
                       ON company.id = COALESCE(partner.company_id, %(default_company_id)s)
                     /* To use the exchange rate effective at the creation of the invoice. */
                     LEFT JOIN LATERAL (
                         SELECT rate
                           FROM res_currency_rate
                          WHERE company_id = move.company_id
                            AND currency_id = company.currency_id
                            AND name < move.date
                          ORDER BY name DESC
                          LIMIT 1
                     ) currency_rate
                       ON TRUE
                    WHERE move.state NOT IN ('draft', 'cancel')
                      AND move.company_id IN %(company_ids)s
                      AND move.partner_id IN %(partner_ids)s
                      AND move.move_type IN ('out_invoice', 'out_refund')
                    GROUP BY move.partner_id""",
                partner_ids=tuple(self.ids),
                company_ids=tuple(self.env.companies.ids),
                default_company_id=self.env.company.id,
            ))
            data_map = dict(query_res)
        else:
            data_map = {}
for partner in self:
            partner.total_invoiced = data_map.get(partner.id, 0.0)

Back to entity