Bank statement base import

account_statement_base_import · OCA/account-reconcile

    Repository
    OCA/account-reconcile · module folder · Try on Runboat
    Module version
    1.2
    Category
    Finance
    Folder size
    0.08 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    http://www.camptocamp.com
    Last tracking update
    2026-08-07 07:03:11
    Authors
    Camptocamp, Odoo Community Association (OCA)
    Maintainers
    Camptocamp
    Committers
    Stéphane Bidoul, Pedro M. Baeza, Stéphane Bidoul (ACSONE)
    Odoo dependencies
    OCA/account-reconcile:
    - account_statement_ext
    - account_statement_base_completion
    odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - decimal_precision
    - mail
    - report
    - analytic
    - board
    - edi
    - email_template
    - report_webkit
    - account_voucher
    Python dependencies
    None
    System dependencies
    None
    Required by
    account_statement_commission, account_statement_transactionid_import
    Description
     This module brings basic methods and fields on bank statement to deal with
 the importation of different bank and offices. A generic abstract method is
 defined and an example that gives you a basic way of importing bank statement
 through a standard file is provided.

 This module improves the bank statement and allows you to import your bank
 transactions with a standard .csv or .xls file (you'll find it in the 'data'
 folder). It respects the profile (provided by the accouhnt_statement_ext
 module) to pass the entries. That means, you'll have to choose a file format
 for each profile.
 In order to achieve this it uses the `xlrd` Python module which you will need
 to install separately in your environment.

 This module can handle a commission taken by the payment office and has the
 following format:

 * __ref__: the SO number, INV number or any matching ref found. It'll be used
   as reference in the generated entries and will be useful for reconciliation
   process
 * __date__: date of the payment
 * __amount__: amount paid in the currency of the journal used in the
   importation profile
 * __label__: the comunication given by the payment office, used as
   communication in the generated entries.

 The goal is here to populate the statement lines of a bank statement with the
 infos that the bank or office give you. Fell free to inherit from this module
 to add your own format. Then, if you need to complete data from there, add
 your own account_statement_*_completion module and implement the needed rules.

    Code Analysis ⓘ

    Views touched (3)
    XML IDNameModelTypeStatus
    bank_statement_view_form account_bank_statement.bank_statement.view_form account.bank.statement form Inherits account_statement_base_completion.bank_statement_view_form
    statement_importer_view credit.statement.import.config.view credit.statement.import form New
    statement_importer_view_form account.statement.profile.view account.statement.profile form Inherits account_statement_ext.statement_importer_view_form
    HTTP endpoints (0)

    No HTTP endpoints found for this module.

    Models touched (2)

    New fields (0)

    No new fields.

    Public methods (5)
    • multi_statement_import(self, cr, uid, ids, profile_id, file_stream, ftype='csv', context=None)
      Create multiple bank statements from values given by the parser for the given profile. :param int/long profile_id: ID of the profile used to import the file :param filebuffer file_stream: binary of the providen file :param char: ftype represent the file exstension (csv by default) :return: list: list of ids of the created account.bank.statemênt
    • prepare_statement_lines_vals(self, cr, uid, parser_vals, statement_id, context)
      Hook to build the values of a line from the parser returned values. At least it fullfill the statement_id. Overide it to add your own completion if needed. :param dict of vals from parser for account.bank.statement.line (called by parser.get_st_line_vals) :param int/long statement_id: ID of the concerned account.bank.statement :return: dict of vals that will be passed to create method of statement line.
    • prepare_statement_vals(self, cr, uid, profile_id, result_row_list, parser, context=None)
      Hook to build the values of the statement from the parser and the profile.
    • prepare_statetement_lines_vals(self, *args, **kwargs)
    • write_logs_after_import(self, cr, uid, ids, statement_id, num_lines, context)
      Write the log in the logger :param int/long statement_id: ID of the concerned account.bank.statement :param int/long num_lines: Number of line that have been parsed :return: True

    New fields (0)

    No new fields.

    Public methods (3)
    • default_get(self, cr, uid, fields, context=None)
    • import_statement(self, cr, uid, req_id, context=None)
      This Function import credit card agency statement
    • onchange_profile_id(self, cr, uid, ids, profile_id, context=None)

    Loading…

    Loading…