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.

Installation

During installation, the module checks if your bank account numbers are unique already. If this is not the case, you won’t be able to install the module until duplicates are fixed.

The error message only shows the first few duplicates, in order to find all of them, use the following statement:

with res_partner_bank_sanitized as (
    select
        id, acc_number,
        regexp_replace(acc_number, '\W+', '', 'g') acc_number_sanitized
    from res_partner_bank
),
res_partner_bank_sanitized_grouped as (
    select
        array_agg(id) ids, acc_number_sanitized, count(*) amount
    from res_partner_bank_sanitized group by acc_number_sanitized
)
select * from res_partner_bank_sanitized_grouped where amount > 1;

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback here.

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.0.1.99.dev4-py2-none-any.whl.

File metadata

File hashes

Hashes for odoo8_addon_base_bank_account_number_unique-8.0.1.0.1.99.dev4-py2-none-any.whl
Algorithm Hash digest
SHA256 3238e6f191cf312d9b607e69bf735487a86c4ef6ca5a4e0f79b7f951967d81d0
MD5 93bf4a86cf16fab5f088914acb6cb3ba
BLAKE2b-256 3b0b2fbb3e8f81613d024e6f3950d97cda9c8eba48c5cea3b50645700e19fa4c

See more details on using hashes here.

Supported by

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