QWeb Financial Reports

account_financial_report_qweb
REPOSITORY
REPOSITORYOCA/account-financial-reporting
GIT
GIThttps://github.com/OCA/account-financial-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/account-financial-reporting/tree/10.0/account_financial_report_qweb
VERSION
VERSION 3.1.3
CATEGORY
CATEGORYReporting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONYes
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Camptocamp, ACSONE SA/NV, initOS GmbH, redCOR AG
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), Camptocamp, ACSONE SA/NV, initOS GmbH, redCOR AG
COMMITTERS
COMMITTERSAlexis de Lattre, Stefan Rijnhart, eLBati, Pedro M. Baeza, GitHub, Cédric Pigeon, Denis Roussel, Akim Juillerat, Stéphane Bidoul (ACSONE), Ivan Yelizariev, Jordi Ballester Alomar, Jordi Ballester, OCA Transbot, jcoux, ahenriquez, Adrien Peiffer (ACSONE), Denis Leemann, oca-travis, Weblate, OCA-git-bot, SimoRubi, Simone Rubino, mpanarin, Iryna Vyshnevska, Benjamin Willig, Vincent Van Rossem, hveficent, Eloi Cousinet, Roodin
WEBSITE
WEBSITEhttps://odoo-community.org/
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:20:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-financial-tools:
    - account_group
OCA/reporting-engine:
    - report_xlsx
OCA/server-tools:
    - date_range
OCA/web:
    - web_widget_many2many_tags_multi_selection
odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - report
    - analytic
    - web_planner
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (49)
XML IDNameModelTypeStatus
account_financial_report_assets_backend account_financial_report assets ir.ui.view qweb Inherits web.assets_backend
account_financial_report_qweb.internal_layout account_financial_report_qweb.internal_layout ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_ending_cumul account_financial_report_qweb.report_general_ledger_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_filters account_financial_report_qweb.report_general_ledger_filters ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_lines account_financial_report_qweb.report_general_ledger_lines ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_all account_financial_report_qweb.report_journal_qweb_all ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_all_taxes account_financial_report_qweb.report_journal_qweb_all_taxes ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_journal account_financial_report_qweb.report_journal_qweb_journal ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_journal_first_line account_financial_report_qweb.report_journal_qweb_journal_first_line ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_journal_table_header account_financial_report_qweb.report_journal_qweb_journal_table_header ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_journal_taxes account_financial_report_qweb.report_journal_qweb_journal_taxes ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_move account_financial_report_qweb.report_journal_qweb_move ir.ui.view qweb New
account_financial_report_qweb.report_journal_qweb_move_line account_financial_report_qweb.report_journal_qweb_move_line ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_ending_cumul account_financial_report_qweb.report_open_items_qweb_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_filters account_financial_report_qweb.report_open_items_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_lines account_financial_report_qweb.report_open_items_qweb_lines ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb account_financial_report_qweb.report_trial_balance_qweb ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_account_footer account_financial_report_qweb.report_trial_balance_qweb_account_footer ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_filters account_financial_report_qweb.report_trial_balance_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_line account_financial_report_qweb.report_trial_balance_qweb_line ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_lines_header account_financial_report_qweb.report_trial_balance_qweb_lines_header ir.ui.view qweb New
aged_partner_balance_wizard Aged Partner Balance aged.partner.balance.wizard form New
assets_specific assets_specific ir.ui.view qweb Inherits report.assets_common
general_ledger_wizard General Ledger general.ledger.report.wizard form New
journal_report_wizard_form_view journal.report.wizard.form (in account_financial_report_qweb) journal.report.wizard form New
open_items_wizard Open Items open.items.report.wizard form New
report_aged_partner_balance_account_ending_cumul report_aged_partner_balance_account_ending_cumul ir.ui.view qweb New
report_aged_partner_balance_base report_aged_partner_balance_base ir.ui.view qweb New
report_aged_partner_balance_filters report_aged_partner_balance_filters ir.ui.view qweb New
report_aged_partner_balance_html report_aged_partner_balance_html ir.ui.view qweb New
report_aged_partner_balance_lines report_aged_partner_balance_lines ir.ui.view qweb New
report_aged_partner_balance_lines_header report_aged_partner_balance_lines_header ir.ui.view qweb New
report_aged_partner_balance_move_lines report_aged_partner_balance_move_lines ir.ui.view qweb New
report_aged_partner_balance_partner_ending_cumul report_aged_partner_balance_partner_ending_cumul ir.ui.view qweb New
report_aged_partner_balance_qweb report_aged_partner_balance_qweb ir.ui.view qweb New
report_buttons report_buttons ir.ui.view qweb New
report_general_ledger_base report_general_ledger_base ir.ui.view qweb New
report_general_ledger_html report_general_ledger_html ir.ui.view qweb New
report_general_ledger_qweb report_general_ledger_qweb ir.ui.view qweb New
report_journal_html report_journal_html ir.ui.view qweb New
report_journal_qweb report_journal_qweb ir.ui.view qweb New
report_journal_qweb_base report_journal_qweb_base ir.ui.view qweb New
report_open_items_base report_open_items_base ir.ui.view qweb New
report_open_items_html report_open_items_html ir.ui.view qweb New
report_open_items_qweb report_open_items_qweb ir.ui.view qweb New
report_trial_balance_base report_trial_balance_base ir.ui.view qweb New
report_trial_balance_html report_trial_balance_html ir.ui.view qweb New
trial_balance_wizard Trial Balance trial.balance.report.wizard form New
view_account_specific_form account.account.form.inherit account.account field Inherits account.view_account_form
Models touched (35)

New fields (1)
  • centralized Boolean
    help='If flagged, no details will be displayed in the General Ledger report (the webkit one only), only centralized amounts per period.' args: 'Centralized'
Public methods (0)

No public methods.

New fields (2)
  • compute_account_ids Many2many → account.account
    compute='_compute_group_accounts' store=True string='Accounts' args: 'account.account'
  • group_child_ids One2many → account.group
    comodel_name='account.group' inverse_name='parent_id' string='Child Groups'
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (1)
  • init(self)
    @api.model_cr
    The join between accounts_partners subquery and account_move_line can be heavy to compute on big databases. Join sample: JOIN account_move_line ml ON ap.account_id = ml.account_id AND ml.date < '2018-12-30' AND ap.partner_id = ml.partner_id AND ap.include_initial_balance = TRUE By adding the following index, performances are strongly increased. :return:

New fields (8)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> required=False string='Company'
  • date_at Date
    default=fields.Date.context_today required=True
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • show_move_line_details Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (5)
  • button_export_html(self)
    @api.multi
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (18)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • analytic_tag_ids Many2many → account.analytic.tag
    comodel_name='account.analytic.tag' string='Filter accounts'
  • centralize Boolean
    default=True string='Activate centralization'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> required=False string='Company'
  • cost_center_ids Many2many → account.analytic.account
    comodel_name='account.analytic.account' string='Filter cost centers'
  • date_from Date
    default=<expr> required=True
  • date_range_id Many2one → date.range
    comodel_name='date.range' string='Date range'
  • date_to Date
    default=fields.Date.context_today required=True
  • foreign_currency Boolean
    default=<expr> help='Display foreign currency for move lines, unless account currency is not setup through chart of accounts will display initial and final balance in that currency.' string='Show foreign currency'
  • fy_start_date Date
    compute='_compute_fy_start_date'
  • hide_account_at_0 Boolean
    help='Use this filter to hide an account or a partner with an ending balance at 0. If partners are filtered, debits and credits totals will not match the trial balance.' string='Hide account ending balance at 0'
  • journal_ids Many2many → account.journal
    comodel_name='account.journal' string='Filter journals'
  • not_only_one_unaffected_earnings_account Boolean
    readonly=True string='Not only one unaffected earnings account'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' default=<expr> string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • show_analytic_tags Boolean
    string='Show analytic tags'
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (7)
  • button_export_html(self)
    @api.multi
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_date_range_id(self)
    @api.onchange('date_range_id')
    Handle date range change.
  • onchange_partner_ids(self)
    @api.onchange('partner_ids')
    Handle partners change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (10)
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> ondelete='cascade' required=False string='Company'
  • date_from Date
    required=True string='Start date'
  • date_range_id Many2one → date.range
    comodel_name='date.range' string='Date range'
  • date_to Date
    required=True string='End date'
  • foreign_currency Boolean
  • group_option Selection
    default='journal' required=True selection='_get_group_options' string='Group entries by'
  • journal_ids Many2many → account.journal
    comodel_name='account.journal' required=False string='Journals'
  • move_target Selection
    default='all' required=True selection='_get_move_targets'
  • sort_option Selection
    default='move_name' required=True selection='_get_sort_options' string='Sort entries by'
  • with_account_name Boolean
    default=False
Public methods (5)
  • button_export_html(self)
    @api.multi
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_date_range_id(self)
    @api.onchange('date_range_id')

New fields (9)
  • account_ids Many2many → account.account
    comodel_name='account.account' domain=[('reconcile', '=', True)] string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> required=False string='Company'
  • date_at Date
    default=fields.Date.context_today required=True
  • foreign_currency Boolean
    default=<expr> help='Display foreign currency for move lines, unless account currency is not setup through chart of accounts will display initial and final balance in that currency.' string='Show foreign currency'
  • hide_account_at_0 Boolean
    help='Use this filter to hide an account or a partner with an ending balance at 0. If partners are filtered, debits and credits totals will not match the trial balance.' string='Hide account ending balance at 0'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' default=<expr> string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (5)
  • button_export_html(self)
    @api.multi
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (8)
  • account_ids One2many → report_aged_partner_balance_qweb_account
    comodel_name='report_aged_partner_balance_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_at Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • only_posted_moves Boolean
  • open_items_id Many2one → report_open_items_qweb
    comodel_name='report_open_items_qweb'
  • show_move_line_details Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (3)
  • compute_data_for_report(self)
    @api.multi
  • get_html(self, given_context=None)
    @api.model
  • print_report(self, report_type)
    @api.multi

New fields (18)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • cumul_age_120_days Float
    digits=(16, 2)
  • cumul_age_30_days Float
    digits=(16, 2)
  • cumul_age_60_days Float
    digits=(16, 2)
  • cumul_age_90_days Float
    digits=(16, 2)
  • cumul_amount_residual Float
    digits=(16, 2)
  • cumul_current Float
    digits=(16, 2)
  • cumul_older Float
    digits=(16, 2)
  • name Char
  • partner_ids One2many → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' inverse_name='report_account_id'
  • percent_age_120_days Float
    digits=(16, 2)
  • percent_age_30_days Float
    digits=(16, 2)
  • percent_age_60_days Float
    digits=(16, 2)
  • percent_age_90_days Float
    digits=(16, 2)
  • percent_current Float
    digits=(16, 2)
  • percent_older Float
    digits=(16, 2)
  • report_id Many2one → report_aged_partner_balance_qweb
    comodel_name='report_aged_partner_balance_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (9)
  • age_120_days Float
    digits=(16, 2)
  • age_30_days Float
    digits=(16, 2)
  • age_60_days Float
    digits=(16, 2)
  • age_90_days Float
    digits=(16, 2)
  • amount_residual Float
    digits=(16, 2)
  • current Float
    digits=(16, 2)
  • older Float
    digits=(16, 2)
  • partner Char
  • report_partner_id Many2one → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (16)
  • account Char
  • age_120_days Float
    digits=(16, 2)
  • age_30_days Float
    digits=(16, 2)
  • age_60_days Float
    digits=(16, 2)
  • age_90_days Float
    digits=(16, 2)
  • amount_residual Float
    digits=(16, 2)
  • current Float
    digits=(16, 2)
  • date Date
  • date_due Date
  • entry Char
  • journal Char
  • label Char
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • older Float
    digits=(16, 2)
  • partner Char
  • report_partner_id Many2one → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (5)
  • line_ids One2many → report_aged_partner_balance_qweb_line
    comodel_name='report_aged_partner_balance_qweb_line' inverse_name='report_partner_id'
  • move_line_ids One2many → report_aged_partner_balance_qweb_move_line
    comodel_name='report_aged_partner_balance_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_aged_partner_balance_qweb_account
    comodel_name='report_aged_partner_balance_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (17)
  • account_ids One2many → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' inverse_name='report_id'
  • centralize Boolean
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_from Date
  • date_to Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_analytic_tag_ids Many2many → account.analytic.tag
    comodel_name='account.analytic.tag'
  • filter_cost_center_ids Many2many → account.analytic.account
    comodel_name='account.analytic.account'
  • filter_journal_ids Many2many → account.journal
    comodel_name='account.journal'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • foreign_currency Boolean
  • fy_start_date Date
  • hide_account_at_0 Boolean
  • only_posted_moves Boolean
  • show_analytic_tags Boolean
  • show_cost_center Boolean
    default=<expr>
  • unaffected_earnings_account Many2one → account.account
    comodel_name='account.account' compute='_compute_unaffected_earnings_account' store=True
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (3)
  • compute_data_for_report(self, with_line_details=True, with_partners=True)
    @api.multi
  • get_html(self, given_context=None)
    @api.model
  • print_report(self, report_type)
    @api.multi

New fields (16)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • final_balance Float
    digits=(16, 2)
  • final_balance_foreign_currency Float
    digits=(16, 2)
  • final_credit Float
    digits=(16, 2)
  • final_debit Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • initial_balance_foreign_currency Float
    digits=(16, 2)
  • initial_credit Float
    digits=(16, 2)
  • initial_debit Float
    digits=(16, 2)
  • is_partner_account Boolean
  • move_line_ids One2many → report_general_ledger_qweb_move_line
    comodel_name='report_general_ledger_qweb_move_line' inverse_name='report_account_id'
  • name Char
  • partner_ids One2many → report_general_ledger_qweb_partner
    comodel_name='report_general_ledger_qweb_partner' inverse_name='report_account_id'
  • report_id Many2one → report_general_ledger_qweb
    comodel_name='report_general_ledger_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (18)
  • account Char
  • amount_currency Float
    digits=(16, 2)
  • cost_center Char
  • credit Float
    digits=(16, 2)
  • cumul_balance Float
    digits=(16, 2)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • date Date
  • debit Float
    digits=(16, 2)
  • entry Char
  • journal Char
  • label Char
  • matched_ml_id Many2one → account.full.reconcile
    args: 'account.full.reconcile'
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • partner Char
  • report_account_id Many2one → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' index=True ondelete='cascade'
  • report_partner_id Many2one → report_general_ledger_qweb_partner
    comodel_name='report_general_ledger_qweb_partner' index=True ondelete='cascade'
  • tags Char
  • taxes_description Char
Public methods (0)

No public methods.

New fields (13)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • final_balance Float
    digits=(16, 2)
  • final_balance_foreign_currency Float
    digits=(16, 2)
  • final_credit Float
    digits=(16, 2)
  • final_debit Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • initial_balance_foreign_currency Float
    digits=(16, 2)
  • initial_credit Float
    digits=(16, 2)
  • initial_debit Float
    digits=(16, 2)
  • move_line_ids One2many → report_general_ledger_qweb_move_line
    comodel_name='report_general_ledger_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (14)
  • company_id Many2one → res.company
    comodel_name='res.company' ondelete='cascade' required=True
  • date_from Date
    required=True
  • date_to Date
    required=True
  • foreign_currency Boolean
  • group_option Selection
    default='journal' required=True selection='_get_group_options'
  • journal_ids Many2many → account.journal
    comodel_name='account.journal' required=True
  • move_target Selection
    default='all' required=True selection='_get_move_targets'
  • report_journal_ids One2many → report_journal_qweb_journal
    comodel_name='report_journal_qweb_journal' inverse_name='report_id'
  • report_journal_tax_line_ids One2many → report_journal_qweb_journal_tax_line
    comodel_name='report_journal_qweb_journal_tax_line' inverse_name='report_id'
  • report_move_ids One2many → report_journal_qweb_move
    comodel_name='report_journal_qweb_move' inverse_name='report_id'
  • report_move_line_ids One2many → report_journal_qweb_move_line
    comodel_name='report_journal_qweb_move_line' inverse_name='report_id'
  • report_tax_line_ids One2many → report_journal_qweb_report_tax_line
    comodel_name='report_journal_qweb_report_tax_line' inverse_name='report_id'
  • sort_option Selection
    default='move_name' required=True selection='_get_sort_options'
  • with_account_name Boolean
Public methods (4)
  • compute_data_for_report(self)
    @api.multi
  • get_html(self, given_context=None)
    @api.model
  • print_report(self, report_type)
    @api.multi
  • refresh(self)
    @api.multi

New fields (10)
  • code Char
  • company_id Many2one → res.company
    comodel_name='res.company' ondelete='cascade' required=True
  • credit Float
    digits=DIGITS
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • debit Float
    digits=DIGITS
  • journal_id Many2one → account.journal
    comodel_name='account.journal' ondelete='cascade' required=True
  • name Char
    required=True
  • report_id Many2one → report_journal_qweb
    comodel_name='report_journal_qweb' ondelete='cascade' required=True
  • report_move_ids One2many → report_journal_qweb_move
    comodel_name='report_journal_qweb_move' inverse_name='report_journal_id'
  • report_tax_line_ids One2many → report_journal_qweb_journal_tax_line
    comodel_name='report_journal_qweb_journal_tax_line' inverse_name='report_journal_id'
Public methods (0)

No public methods.

New fields (1)
  • report_journal_id Many2one → report_journal_qweb_journal
    comodel_name='report_journal_qweb_journal' ondelete='cascade' required=True
Public methods (0)

No public methods.

New fields (6)
  • company_id Many2one → res.company
    comodel_name='res.company' ondelete='cascade' required=True
  • move_id Many2one → account.move
    comodel_name='account.move' ondelete='cascade' required=True
  • name Char
  • report_id Many2one → report_journal_qweb
    comodel_name='report_journal_qweb' ondelete='cascade' required=True
  • report_journal_id Many2one → report_journal_qweb_journal
    comodel_name='report_journal_qweb_journal' ondelete='cascade' required=True
  • report_move_line_ids One2many → report_journal_qweb_move_line
    comodel_name='report_journal_qweb_move_line' inverse_name='report_move_id'
Public methods (0)

No public methods.

New fields (22)
  • account Char
  • account_code Char
  • account_id Many2one → account.account
    comodel_name='account.account'
  • account_type Char
  • amount_currency Monetary
    currency_field='currency_id'
  • company_currency_id Many2one → res.currency
    comodel_name='res.currency'
  • company_id Many2one → res.company
    comodel_name='res.company' ondelete='cascade' required=True
  • credit Float
    digits=DIGITS
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • currency_name Char
  • date Date
  • debit Float
    digits=DIGITS
  • entry Char
  • label Char
  • move_line_id Many2one → account.move.line
    comodel_name='account.move.line' ondelete='cascade' required=True
  • partner Char
  • partner_id Many2one → res.partner
    comodel_name='res.partner'
  • report_id Many2one → report_journal_qweb
    comodel_name='report_journal_qweb' ondelete='cascade' required=True
  • report_journal_id Many2one → report_journal_qweb_journal
    comodel_name='report_journal_qweb_journal' ondelete='cascade' required=True
  • report_move_id Many2one → report_journal_qweb_move
    comodel_name='report_journal_qweb_move' ondelete='cascade' required=True
  • tax_id Many2one → account.tax
    comodel_name='account.tax'
  • taxes_description Char
Public methods (0)

No public methods.

New fields (10)
  • base_balance Float
    compute='_compute_base_balance' digits=DIGITS
  • base_credit Float
    digits=DIGITS
  • base_debit Float
    digits=DIGITS
  • report_id Many2one → report_journal_qweb
    comodel_name='report_journal_qweb' ondelete='cascade' required=True
  • tax_balance Float
    compute='_compute_tax_balance' digits=DIGITS
  • tax_code Char
  • tax_credit Float
    digits=DIGITS
  • tax_debit Float
    digits=DIGITS
  • tax_id Many2one → account.tax
    comodel_name='account.tax'
  • tax_name Char
Public methods (0)

No public methods.

New fields (8)
  • account_ids One2many → report_open_items_qweb_account
    comodel_name='report_open_items_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_at Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • foreign_currency Boolean
  • hide_account_at_0 Boolean
  • only_posted_moves Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (3)
  • compute_data_for_report(self)
    @api.multi
  • get_html(self, given_context=None)
    @api.model
  • print_report(self, report_type)
    @api.multi

New fields (10)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • final_amount_residual Float
    digits=(16, 2)
  • final_amount_residual_currency Float
    digits=(16, 2)
  • final_amount_total_due Float
    digits=(16, 2)
  • final_amount_total_due_currency Float
    digits=(16, 2)
  • name Char
  • partner_ids One2many → report_open_items_qweb_partner
    comodel_name='report_open_items_qweb_partner' inverse_name='report_account_id'
  • report_id Many2one → report_open_items_qweb
    comodel_name='report_open_items_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (14)
  • account Char
  • amount_residual Float
    digits=(16, 2)
  • amount_residual_currency Float
    digits=(16, 2)
  • amount_total_due Float
    digits=(16, 2)
  • amount_total_due_currency Float
    digits=(16, 2)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • date Date
  • date_due Date
  • entry Char
  • journal Char
  • label Char
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • partner Char
  • report_partner_id Many2one → report_open_items_qweb_partner
    comodel_name='report_open_items_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (9)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • final_amount_residual Float
    digits=(16, 2)
  • final_amount_residual_currency Float
    digits=(16, 2)
  • final_amount_total_due Float
    digits=(16, 2)
  • final_amount_total_due_currency Float
    digits=(16, 2)
  • move_line_ids One2many → report_open_items_qweb_move_line
    comodel_name='report_open_items_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_open_items_qweb_account
    comodel_name='report_open_items_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (17)
  • account_ids One2many → report_trial_balance_qweb_account
    comodel_name='report_trial_balance_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_from Date
  • date_to Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_journal_ids Many2many → account.journal
    comodel_name='account.journal'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • foreign_currency Boolean
  • fy_start_date Date
  • general_ledger_id Many2one → report_general_ledger_qweb
    comodel_name='report_general_ledger_qweb'
  • hide_account_at_0 Boolean
  • hide_parent_hierarchy_level Boolean
    default=False args: 'Do not display parent levels'
  • hierarchy_on Selection
    default='computed' help='Computed Accounts: Use when the account group have codes\n that represent prefixes of the actual accounts.\n\n Child Accounts: Use when your account groups are hierarchical.\n\n No hierarchy: Use to display just the accounts, without any grouping.\n ' period_balance=fields.Float(digits=(16, 2)) required=True string='Hierarchy On' args: [('computed', 'Computed Accounts'), ('relation', 'Child Accounts'), ('none', 'No hierarchy')]
  • limit_hierarchy_level Boolean
    args: 'Limit hierarchy levels'
  • only_posted_moves Boolean
  • show_hierarchy_level Integer
    default=1 args: 'Hierarchy Levels to display'
  • show_partner_details Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (3)
  • compute_data_for_report(self)
    @api.multi
  • get_html(self, given_context=None)
    @api.model
  • print_report(self, report_type)
    @api.multi

New fields (20)
  • account_group_id Many2one → account.group
    index=True args: 'account.group'
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • child_account_ids Char
    string='Accounts'
  • code Char
  • compute_account_ids Many2many → account.account
    store=True string='Accounts' args: 'account.account'
  • credit Float
    digits=(16, 2)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • debit Float
    digits=(16, 2)
  • final_balance Float
    digits=(16, 2)
  • final_balance_foreign_currency Float
    digits=(16, 2)
  • hide_line Boolean
    compute='_compute_hide_line'
  • initial_balance Float
    digits=(16, 2)
  • initial_balance_foreign_currency Float
    digits=(16, 2)
  • level Integer
    default=1 index=True
  • name Char
  • parent_id Many2one → account.group
    index=True args: 'account.group'
  • partner_ids One2many → report_trial_balance_qweb_partner
    comodel_name='report_trial_balance_qweb_partner' inverse_name='report_account_id'
  • period_balance Float
    digits=(16, 2)
  • report_id Many2one → report_trial_balance_qweb
    comodel_name='report_trial_balance_qweb' index=True ondelete='cascade'
  • sequence Integer
    default=1 index=True
Public methods (0)

No public methods.

New fields (11)
  • credit Float
    digits=(16, 2)
  • currency_id Many2one → res.currency
    comodel_name='res.currency'
  • debit Float
    digits=(16, 2)
  • final_balance Float
    digits=(16, 2)
  • final_balance_foreign_currency Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • initial_balance_foreign_currency Float
    digits=(16, 2)
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • period_balance Float
    digits=(16, 2)
  • report_account_id Many2one → report_trial_balance_qweb_account
    comodel_name='report_trial_balance_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (19)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> required=False string='Company'
  • date_from Date
    required=True
  • date_range_id Many2one → date.range
    comodel_name='date.range' string='Date range'
  • date_to Date
    required=True
  • foreign_currency Boolean
    help='Display foreign currency for move lines, unless account currency is not setup through chart of accounts will display initial and final balance in that currency.' string='Show foreign currency'
  • fy_start_date Date
    compute='_compute_fy_start_date'
  • hide_account_at_0 Boolean
    default=True help='When this option is enabled, the trial balance will not display accounts that have initial balance = debit = credit = end balance = 0' string='Hide accounts at 0'
  • hide_parent_hierarchy_level Boolean
    default=False args: 'Do not display parent levels'
  • hierarchy_on Selection
    default='computed' help='Computed Accounts: Use when the account group have codes\n that represent prefixes of the actual accounts.\n\n Child Accounts: Use when your account groups are hierarchical.\n\n No hierarchy: Use to display just the accounts, without any grouping.\n ' required=True string='Hierarchy On' args: [('computed', 'Computed Accounts'), ('relation', 'Child Accounts'), ('none', 'No hierarchy')]
  • journal_ids Many2many → account.journal
    comodel_name='account.journal' string='Filter journals'
  • limit_hierarchy_level Boolean
    args: 'Limit hierarchy levels'
  • not_only_one_unaffected_earnings_account Boolean
    readonly=True string='Not only one unaffected earnings account'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • show_hierarchy_level Integer
    default=1 args: 'Hierarchy Levels to display'
  • show_partner_details Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (7)
  • button_export_html(self)
    @api.multi
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_date_range_id(self)
    @api.onchange('date_range_id')
    Handle date range change.
  • onchange_show_partner_details(self)
    @api.onchange('show_partner_details')
    Handle partners change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.
REPOSITORY
REPOSITORYOCA/account-financial-reporting
GIT
GIThttps://github.com/OCA/account-financial-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/account-financial-reporting/tree/9.0/account_financial_report_qweb
VERSION
VERSION 1.0.5
CATEGORY
CATEGORYReporting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONYes
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), initOS GmbH, Camptocamp SA, redCOR AG
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), initOS GmbH, Camptocamp SA, redCOR AG
COMMITTERS
COMMITTERSAlexis de Lattre, Matthieu Dietrich, Leonardo Pistone, Pedro M. Baeza, GitHub, Jairo Llopis, Akim Juillerat, Stéphane Bidoul (ACSONE), OCA Transbot, Juan Jose Scarafia, jcoux, Stefan Rijnhart (Opener), Florian da Costa, oca-travis
WEBSITE
WEBSITEhttps://odoo-community.org/
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:15:23
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
OCA/server-tools:
    - date_range
odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - report
    - analytic
    - web_tip
    - web_planner
    - account_full_reconcile
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (27)
XML IDNameModelTypeStatus
account_financial_report_qweb.internal_layout account_financial_report_qweb.internal_layout ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb account_financial_report_qweb.report_aged_partner_balance_qweb ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_account_ending_cumul account_financial_report_qweb.report_aged_partner_balance_qweb_account_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_filters account_financial_report_qweb.report_aged_partner_balance_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_lines account_financial_report_qweb.report_aged_partner_balance_qweb_lines ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_lines_header account_financial_report_qweb.report_aged_partner_balance_qweb_lines_header ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_move_lines account_financial_report_qweb.report_aged_partner_balance_qweb_move_lines ir.ui.view qweb New
account_financial_report_qweb.report_aged_partner_balance_qweb_partner_ending_cumul account_financial_report_qweb.report_aged_partner_balance_qweb_partner_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_qweb account_financial_report_qweb.report_general_ledger_qweb ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_qweb_ending_cumul account_financial_report_qweb.report_general_ledger_qweb_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_qweb_filters account_financial_report_qweb.report_general_ledger_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_general_ledger_qweb_lines account_financial_report_qweb.report_general_ledger_qweb_lines ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb account_financial_report_qweb.report_open_items_qweb ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_ending_cumul account_financial_report_qweb.report_open_items_qweb_ending_cumul ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_filters account_financial_report_qweb.report_open_items_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_open_items_qweb_lines account_financial_report_qweb.report_open_items_qweb_lines ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb account_financial_report_qweb.report_trial_balance_qweb ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_account_footer account_financial_report_qweb.report_trial_balance_qweb_account_footer ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_filters account_financial_report_qweb.report_trial_balance_qweb_filters ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_line account_financial_report_qweb.report_trial_balance_qweb_line ir.ui.view qweb New
account_financial_report_qweb.report_trial_balance_qweb_lines_header account_financial_report_qweb.report_trial_balance_qweb_lines_header ir.ui.view qweb New
aged_partner_balance_wizard Aged Partner Balance aged.partner.balance.wizard form New
assets_specific assets_specific ir.ui.view qweb Inherits report.assets_common
general_ledger_wizard General Ledger general.ledger.report.wizard form New
open_items_wizard Open Items open.items.report.wizard form New
trial_balance_wizard Trial Balance trial.balance.report.wizard form New
view_account_specific_form account.account.form.inherit account.account field Inherits account.view_account_form
Models touched (26)

New fields (1)
  • centralized Boolean
    help='If flagged, no details will be displayed in the General Ledger report (the webkit one only), only centralized amounts per period.' args: 'Centralized'
Public methods (0)

No public methods.

New fields (8)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> string='Company'
  • date_at Date
    default=fields.Date.to_string(datetime.today()) required=True
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • show_move_line_details Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (3)
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (14)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • centralize Boolean
    default=True string='Activate centralization'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> string='Company'
  • cost_center_ids Many2many → account.analytic.account
    comodel_name='account.analytic.account' string='Filter cost centers'
  • date_from Date
    required=True
  • date_range_id Many2one → date.range
    comodel_name='date.range' required=True string='Date range'
  • date_to Date
    required=True
  • fy_start_date Date
    compute='_compute_fy_start_date'
  • hide_account_balance_at_0 Boolean
    help='Use this filter to hide an account or a partner with an ending balance at 0. If partners are filtered, debits and credits totals will not match the trial balance.' string='Hide account ending balance at 0'
  • not_only_one_unaffected_earnings_account Boolean
    readonly=True string='Not only one unaffected earnings account'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (6)
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_date_range_id(self)
    @api.onchange('date_range_id')
    Handle date range change.
  • onchange_partner_ids(self)
    @api.onchange('partner_ids')
    Handle partners change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (8)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> string='Company'
  • date_at Date
    default=fields.Date.to_string(datetime.today()) required=True
  • hide_account_balance_at_0 Boolean
    help='Use this filter to hide an account or a partner with an ending balance at 0. If partners are filtered, debits and credits totals will not match the trial balance.' string='Hide account ending balance at 0'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (3)
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.

New fields (8)
  • account_ids One2many → report_aged_partner_balance_qweb_account
    comodel_name='report_aged_partner_balance_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_at Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • only_posted_moves Boolean
  • open_items_id Many2one → report_open_items_qweb
    comodel_name='report_open_items_qweb'
  • show_move_line_details Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • compute_data_for_report(self)
    @api.multi
  • print_report(self, xlsx_report=False)
    @api.multi

New fields (18)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • cumul_age_120_days Float
    digits=(16, 2)
  • cumul_age_30_days Float
    digits=(16, 2)
  • cumul_age_60_days Float
    digits=(16, 2)
  • cumul_age_90_days Float
    digits=(16, 2)
  • cumul_amount_residual Float
    digits=(16, 2)
  • cumul_current Float
    digits=(16, 2)
  • cumul_older Float
    digits=(16, 2)
  • name Char
  • partner_ids One2many → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' inverse_name='report_account_id'
  • percent_age_120_days Float
    digits=(16, 2)
  • percent_age_30_days Float
    digits=(16, 2)
  • percent_age_60_days Float
    digits=(16, 2)
  • percent_age_90_days Float
    digits=(16, 2)
  • percent_current Float
    digits=(16, 2)
  • percent_older Float
    digits=(16, 2)
  • report_id Many2one → report_aged_partner_balance_qweb
    comodel_name='report_aged_partner_balance_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (9)
  • age_120_days Float
    digits=(16, 2)
  • age_30_days Float
    digits=(16, 2)
  • age_60_days Float
    digits=(16, 2)
  • age_90_days Float
    digits=(16, 2)
  • amount_residual Float
    digits=(16, 2)
  • current Float
    digits=(16, 2)
  • older Float
    digits=(16, 2)
  • partner Char
  • report_partner_id Many2one → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (16)
  • account Char
  • age_120_days Float
    digits=(16, 2)
  • age_30_days Float
    digits=(16, 2)
  • age_60_days Float
    digits=(16, 2)
  • age_90_days Float
    digits=(16, 2)
  • amount_residual Float
    digits=(16, 2)
  • current Float
    digits=(16, 2)
  • date Date
  • date_due Date
  • entry Char
  • journal Char
  • label Char
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • older Float
    digits=(16, 2)
  • partner Char
  • report_partner_id Many2one → report_aged_partner_balance_qweb_partner
    comodel_name='report_aged_partner_balance_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (5)
  • line_ids One2many → report_aged_partner_balance_qweb_line
    comodel_name='report_aged_partner_balance_qweb_line' inverse_name='report_partner_id'
  • move_line_ids One2many → report_aged_partner_balance_qweb_move_line
    comodel_name='report_aged_partner_balance_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_aged_partner_balance_qweb_account
    comodel_name='report_aged_partner_balance_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (14)
  • account_ids One2many → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' inverse_name='report_id'
  • centralize Boolean
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_from Date
  • date_to Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_cost_center_ids Many2many → account.analytic.account
    comodel_name='account.analytic.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • fy_start_date Date
  • has_second_currency Boolean
  • hide_account_balance_at_0 Boolean
  • only_posted_moves Boolean
  • show_cost_center Boolean
    default=<expr>
  • unaffected_earnings_account Many2one → account.account
    comodel_name='account.account' compute='_compute_unaffected_earnings_account' store=True
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • compute_data_for_report(self, with_line_details=True, with_partners=True)
    @api.multi
  • print_report(self, xlsx_report=False)
    @api.multi

New fields (13)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • final_balance Float
    digits=(16, 2)
  • final_credit Float
    digits=(16, 2)
  • final_debit Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • initial_credit Float
    digits=(16, 2)
  • initial_debit Float
    digits=(16, 2)
  • is_partner_account Boolean
  • move_line_ids One2many → report_general_ledger_qweb_move_line
    comodel_name='report_general_ledger_qweb_move_line' inverse_name='report_account_id'
  • name Char
  • partner_ids One2many → report_general_ledger_qweb_partner
    comodel_name='report_general_ledger_qweb_partner' inverse_name='report_account_id'
  • report_id Many2one → report_general_ledger_qweb
    comodel_name='report_general_ledger_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (16)
  • account Char
  • amount_currency Float
    digits=(16, 2)
  • cost_center Char
  • credit Float
    digits=(16, 2)
  • cumul_balance Float
    digits=(16, 2)
  • currency_name Char
  • date Date
  • debit Float
    digits=(16, 2)
  • entry Char
  • journal Char
  • label Char
  • matching_number Char
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • partner Char
  • report_account_id Many2one → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' index=True ondelete='cascade'
  • report_partner_id Many2one → report_general_ledger_qweb_partner
    comodel_name='report_general_ledger_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (10)
  • final_balance Float
    digits=(16, 2)
  • final_credit Float
    digits=(16, 2)
  • final_debit Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • initial_credit Float
    digits=(16, 2)
  • initial_debit Float
    digits=(16, 2)
  • move_line_ids One2many → report_general_ledger_qweb_move_line
    comodel_name='report_general_ledger_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_general_ledger_qweb_account
    comodel_name='report_general_ledger_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (8)
  • account_ids One2many → report_open_items_qweb_account
    comodel_name='report_open_items_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_at Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • has_second_currency Boolean
  • hide_account_balance_at_0 Boolean
  • only_posted_moves Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • compute_data_for_report(self)
    @api.multi
  • print_report(self, xlsx_report=False)
    @api.multi

New fields (6)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • final_amount_residual Float
    digits=(16, 2)
  • name Char
  • partner_ids One2many → report_open_items_qweb_partner
    comodel_name='report_open_items_qweb_partner' inverse_name='report_account_id'
  • report_id Many2one → report_open_items_qweb
    comodel_name='report_open_items_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (14)
  • account Char
  • amount_residual Float
    digits=(16, 2)
  • amount_residual_currency Float
    digits=(16, 2)
  • amount_total_due Float
    digits=(16, 2)
  • amount_total_due_currency Float
    digits=(16, 2)
  • currency_name Char
  • date Date
  • date_due Date
  • entry Char
  • journal Char
  • label Char
  • move_line_id Many2one → account.move.line
    args: 'account.move.line'
  • partner Char
  • report_partner_id Many2one → report_open_items_qweb_partner
    comodel_name='report_open_items_qweb_partner' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (5)
  • final_amount_residual Float
    digits=(16, 2)
  • move_line_ids One2many → report_open_items_qweb_move_line
    comodel_name='report_open_items_qweb_move_line' inverse_name='report_partner_id'
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_open_items_qweb_account
    comodel_name='report_open_items_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (11)
  • account_ids One2many → report_trial_balance_qweb_account
    comodel_name='report_trial_balance_qweb_account' inverse_name='report_id'
  • company_id Many2one → res.company
    comodel_name='res.company'
  • date_from Date
  • date_to Date
  • filter_account_ids Many2many → account.account
    comodel_name='account.account'
  • filter_partner_ids Many2many → res.partner
    comodel_name='res.partner'
  • fy_start_date Date
  • general_ledger_id Many2one → report_general_ledger_qweb
    comodel_name='report_general_ledger_qweb'
  • hide_account_balance_at_0 Boolean
  • only_posted_moves Boolean
  • show_partner_details Boolean
Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • compute_data_for_report(self)
    @api.multi
  • print_report(self, xlsx_report=False)
    @api.multi

New fields (9)
  • account_id Many2one → account.account
    index=True args: 'account.account'
  • code Char
  • credit Float
    digits=(16, 2)
  • debit Float
    digits=(16, 2)
  • final_balance Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • name Char
  • partner_ids One2many → report_trial_balance_qweb_partner
    comodel_name='report_trial_balance_qweb_partner' inverse_name='report_account_id'
  • report_id Many2one → report_trial_balance_qweb
    comodel_name='report_trial_balance_qweb' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (7)
  • credit Float
    digits=(16, 2)
  • debit Float
    digits=(16, 2)
  • final_balance Float
    digits=(16, 2)
  • initial_balance Float
    digits=(16, 2)
  • name Char
  • partner_id Many2one → res.partner
    index=True args: 'res.partner'
  • report_account_id Many2one → report_trial_balance_qweb_account
    comodel_name='report_trial_balance_qweb_account' index=True ondelete='cascade'
Public methods (0)

No public methods.

New fields (13)
  • account_ids Many2many → account.account
    comodel_name='account.account' string='Filter accounts'
  • company_id Many2one → res.company
    comodel_name='res.company' default=<expr> string='Company'
  • date_from Date
    required=True
  • date_range_id Many2one → date.range
    comodel_name='date.range' required=True string='Date range'
  • date_to Date
    required=True
  • fy_start_date Date
    compute='_compute_fy_start_date'
  • hide_account_balance_at_0 Boolean
    help='Use this filter to hide an account or a partner with an ending balance at 0. If partners are filtered, debits and credits totals will not match the trial balance.' string='Hide account ending balance at 0'
  • not_only_one_unaffected_earnings_account Boolean
    readonly=True string='Not only one unaffected earnings account'
  • partner_ids Many2many → res.partner
    comodel_name='res.partner' string='Filter partners'
  • payable_accounts_only Boolean
  • receivable_accounts_only Boolean
  • show_partner_details Boolean
  • target_move Selection
    default='all' required=True string='Target Moves' args: [('posted', 'All Posted Entries'), ('all', 'All Entries')]
Public methods (6)
  • button_export_pdf(self)
    @api.multi
  • button_export_xlsx(self)
    @api.multi
  • onchange_company_id(self)
    @api.onchange('company_id')
    Handle company change.
  • onchange_date_range_id(self)
    @api.onchange('date_range_id')
    Handle date range change.
  • onchange_show_partner_details(self)
    @api.onchange('show_partner_details')
    Handle partners change.
  • onchange_type_accounts_only(self)
    @api.onchange('receivable_accounts_only', 'payable_accounts_only')
    Handle receivable/payable accounts only change.