Unique bank account numbers

Enforce uniqueness on bank accounts

Technical Name:
Therp BV
  • Odoo Version

Unique bank account numbers

It can be desirable to be able to rely on a bank account number identifying exactly one partner. This module allows you to enforce this, so that an account number is unique in the system.

There are some valid corner cases were it is valid to have multiple records for the same account number. For instance in a multicompany setup where the bank-account linked to one company, is a partner bank account for another company.

Because of these corner cases, the constraint is no longer implemented as a SQL unique index. This has the added advantage, that the module can be installed on databases where the bank-account numbers are not unique already.

To find records that are not unique, you could use the following SQL statement:

with res_partner_bank_sanitized as (
        id, acc_number, coalesce(company_id, 0) as company_id,
    from res_partner_bank
res_partner_bank_sanitized_grouped as (
        array_agg(id) ids, sanitized_acc_number, count(*) kount,
    from res_partner_bank_sanitized
    group by sanitized_acc_number, company_id
select * from res_partner_bank_sanitized_grouped where kount > 1;


The constraint is active for new and changed numbers, from the moment of installation.

Bug Tracker

Bugs are tracked on GitHub Issues.




Odoo Community Association

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit http://odoo-community.org.

This is a preview of the recently viewed products by the user.
Once the user has seen at least one product this snippet will be visible.

Recently viewed Products