Skip to main content

Enforce uniqueness on bank accounts

Project description

License: AGPL-3

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 (
    select
        id, acc_number, coalesce(company_id, 0) as company_id,
        sanitized_acc_number
    from res_partner_bank
),
res_partner_bank_sanitized_grouped as (
    select
        array_agg(id) ids, sanitized_acc_number, count(*) kount,
        company_id
    from res_partner_bank_sanitized
    group by sanitized_acc_number, company_id
)
select * from res_partner_bank_sanitized_grouped where kount > 1;

Installation

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

Bug Tracker

Bugs are tracked on GitHub Issues.

Credits

Contributors

Maintainer

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

File details

Details for the file odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev4-py2-none-any.whl.

File metadata

File hashes

Hashes for odoo8_addon_base_bank_account_number_unique-8.0.1.1.0.99.dev4-py2-none-any.whl
Algorithm Hash digest
SHA256 44d68bd39d645f82cfe3e67f3044bd529ebc6c6c8d376e0a78ba0d2a495fd8ab
MD5 5271ebbd72a85697b141a04800031dd3
BLAKE2b-256 6b9780dca7e22bac375db6519a4b4c9cc95e249d602de3038cc750eb25488cf9

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page