Skip to content

Bank Statement Import Generate Unique ID

account_statement_import_generate_unique_id · OCA/bank-statement-import

Follow
    Health
    60/100
    fair
    • Security25/25
      No findings
    • Activity25/25
      Human commit this month
    • Required by5/25
      0 modules depend on it
    • Maturity5/25
      In 1 Odoo series since 18.0

    Heuristic over the facts below, not an audit · How it's computed

    Security findings
    Grave / minor (static analysis)
    Required by
    0
    Modules depending on it
    External deps
    0 pip · 0 bin
    Python packages / system binaries
    License
    LGPL-3
    No conflicts with its dependencies
    Folder size
    0.05 MB
    Module directory on disk
    Code analysis 0 migration notes 1 model 1 view 0 HTTP endpoints

    Description

    Some bank statement sources (e.g. some CSV/sheet exports or camt files) do not provide a unique identifier for their transactions. Without it, importing an overlapping period creates duplicate statement lines.

    This module adds an option on bank journals to generate a unique_import_id for statement lines that come without one. The value is a SHA-256 hash of the normalized account number, date, payment reference, amount, reference and partner name. An identifier provided by the source always takes priority.

    Identical transactions within the same import are numbered (<hash>, <hash>-2, <hash>-3, ...), so they are all imported, while importing the same statement again still ignores all of them.

    Dependencies

    Odoo dependencies
    OCA/account-reconcile:
    - account_statement_base
    OCA/bank-statement-import:
    - account_statement_import_base
    odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - html_editor
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
    Python dependencies
    None
    System dependencies
    None
    Required by
    None

    Code analysis

    Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.

    Views touched 1

    XML IDNameModelTypeStatus
    view_account_journal_form account.journal form Inherits account.view_account_journal_form

    HTTP endpoints 0

    No HTTP endpoints found for this module.

    Models touched 1

    New fields (1)
    • generate_unique_import_id Boolean
      help="Ensures that a unique_import_id is set on bank statement lines when importing them via bank statement import. If no unique identifier was provided, the value is a hash of the account number, date, payment reference, amount, reference and partner name. Identical transactions within the same import are numbered. Only lines imported after enabling this option get an ID; for existing lines without ID use the 'Generate for Existing Lines' button." string='Generate Missing Import IDs'
    Public methods (1)
    • action_generate_unique_import_ids(self)
      Generate the unique_import_id of the existing statement lines which have none, the same way an import of all of them would