QWeb Financial Reports (account_financial_report_qweb)

Security findings

Migration considerations

general_ledger_wizard — For a target of Odoo 17.0+: view 'general_ledger_wizard' uses `attrs=`/`states=`, which are no longer supported. Convert modifiers to direct Python boolean expressions in `invisible`/`readonly`/`required`; preserve the original AND/OR logic. migration-view-attrs-states · source
trial_balance_wizard — For a target of Odoo 17.0+: view 'trial_balance_wizard' uses `attrs=`/`states=`, which are no longer supported. Convert modifiers to direct Python boolean expressions in `invisible`/`readonly`/`required`; preserve the original AND/OR logic. migration-view-attrs-states · source
account_financial_report_qweb.internal_layout — Template 'account_financial_report_qweb.internal_layout' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
account_financial_report_qweb.report_general_ledger_ending_cumul — Template 'account_financial_report_qweb.report_general_ledger_ending_cumul' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
account_financial_report_qweb.report_general_ledger_lines — Template 'account_financial_report_qweb.report_general_ledger_lines' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
account_financial_report_qweb.report_open_items_qweb_lines — Template 'account_financial_report_qweb.report_open_items_qweb_lines' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
account_financial_report_qweb.report_trial_balance_qweb_account_footer — Template 'account_financial_report_qweb.report_trial_balance_qweb_account_footer' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
account_financial_report_qweb.report_trial_balance_qweb_line — Template 'account_financial_report_qweb.report_trial_balance_qweb_line' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_aged_partner_balance_base — Template 'report_aged_partner_balance_base' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_aged_partner_balance_move_lines — Template 'report_aged_partner_balance_move_lines' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_general_ledger_base — Template 'report_general_ledger_base' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_journal_qweb_base — Template 'report_journal_qweb_base' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_open_items_base — Template 'report_open_items_base' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source
report_trial_balance_base — Template 'report_trial_balance_base' uses `t-raw`, deprecated since Odoo 15.0. Prefer `t-out` for escaped output. For intentional HTML, verify sanitization at its source before marking it safe; Markup alone does not sanitize untrusted content. migration-template-t-raw · source

Migration review checklist, not a compatibility verdict. No target version is selected: apply version-specific advice only when migrating to that version or later.

Repository: OCA/account-financial-reporting · module folder · Try on Runboat
Module version: 3.1.3
Category: Reporting
Folder size: 1.92 MB
License: AGPL-3
Application: Yes
Auto-installable: No
Website: https://odoo-community.org/
Last tracking update: 2026-08-07 07:17:43
Authors: Camptocamp, ACSONE SA/NV, Odoo Community Association (OCA), initOS GmbH, redCOR AG
Maintainers: Camptocamp, ACSONE SA/NV, Odoo Community Association (OCA), initOS GmbH, redCOR AG
Committers: Stefan Rijnhart, Alexis de Lattre, eLBati, Pedro M. Baeza, GitHub, Cédric Pigeon, Denis Roussel, Akim Juillerat, Stéphane Bidoul (ACSONE), Ivan Yelizariev, Jordi Ballester Alomar, Jordi Ballester, jcoux, ahenriquez, Iryna Vyshnevska, Benjamin Willig, Simone Rubino, Vincent Van Rossem, Weblate, OCA Transbot, Adrien Peiffer (ACSONE), Denis Leemann, OCA-git-bot, oca-travis, SimoRubi, mpanarin, Eloi Cousinet, hveficent, Roodin

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

xlsxwriter

System dependencies

None

Required by

account_balance_ebp_csv_export, account_multicurrency_revaluation

Description

Code Analysis info_outline

Views touched (49)

XML ID	Name	Model	Type	Status
`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	form	Inherits account.view_account_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

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.

Loading…

build Migration considerations

Code Analysis info_outline

Views touched (49)

HTTP endpoints (0)

Models touched (35)

account.account Extends Model 1 field 0 methods AccountAccount · inherits account.account

account.group Extends Model 2 fields 0 methods AccountGroup · inherits account.group

account.move.line Extends Model 0 fields 1 method AccountMoveLine · inherits account.move.line

aged.partner.balance.wizard New model TransientModel 8 fields 5 methods AgedPartnerBalance · Aged Partner Balance Wizard Aged partner balance report wizard.

general.ledger.report.wizard New model TransientModel 18 fields 7 methods GeneralLedgerReportWizard · General Ledger Report Wizard General ledger report wizard.

journal.report.wizard New model TransientModel 10 fields 5 methods JournalReportWizard

open.items.report.wizard New model TransientModel 9 fields 5 methods OpenItemsReportWizard · Open Items Report Wizard Open items report wizard.

report_aged_partner_balance_qweb Extends TransientModel 0 fields 3 methods AgedPartnerBalanceReportCompute · inherits report_aged_partner_balance_qweb Here, we just define methods. For class fields, go more top at this file.

report_aged_partner_balance_qweb_account New model TransientModel 18 fields 0 methods AgedPartnerBalanceReportAccount · inherits report_qweb_abstract

report_aged_partner_balance_qweb_line New model TransientModel 9 fields 0 methods AgedPartnerBalanceReportLine · inherits report_qweb_abstract

report_aged_partner_balance_qweb_move_line New model TransientModel 16 fields 0 methods AgedPartnerBalanceReportMoveLine · inherits report_qweb_abstract

report_aged_partner_balance_qweb_partner New model TransientModel 5 fields 0 methods AgedPartnerBalanceReportPartner · inherits report_qweb_abstract

report_general_ledger_qweb Extends TransientModel 0 fields 3 methods GeneralLedgerReportCompute · inherits report_general_ledger_qweb Here, we just define methods. For class fields, go more top at this file.

report_general_ledger_qweb_account New model TransientModel 16 fields 0 methods GeneralLedgerReportAccount · inherits report_qweb_abstract

report_general_ledger_qweb_move_line New model TransientModel 18 fields 0 methods GeneralLedgerReportMoveLine · inherits report_qweb_abstract

report_general_ledger_qweb_partner New model TransientModel 13 fields 0 methods GeneralLedgerReportPartner · inherits report_qweb_abstract

report_journal_qweb New model TransientModel 14 fields 4 methods ReportJournalQweb · inherits report_qweb_abstract

report_journal_qweb_journal New model TransientModel 10 fields 0 methods ReportJournalQwebJournal · inherits report_qweb_abstract

report_journal_qweb_journal_tax_line New model TransientModel 1 field 0 methods ReportJournalQwebJournalTaxLine · inherits report_journal_qweb_report_tax_line

report_journal_qweb_move New model TransientModel 6 fields 0 methods ReportJournalQwebMove · inherits report_qweb_abstract

report_journal_qweb_move_line New model TransientModel 22 fields 0 methods ReportJournalQwebMoveLine · inherits report_qweb_abstract

report_journal_qweb_report_tax_line New model TransientModel 10 fields 0 methods ReportJournalQwebReportTaxLine · inherits report_qweb_abstract

report_open_items_qweb Extends TransientModel 0 fields 3 methods OpenItemsReportCompute · inherits report_open_items_qweb Here, we just define methods. For class fields, go more top at this file.

report_open_items_qweb_account New model TransientModel 10 fields 0 methods OpenItemsReportAccount · inherits report_qweb_abstract

report_open_items_qweb_move_line New model TransientModel 14 fields 0 methods OpenItemsReportMoveLine · inherits report_qweb_abstract

report_open_items_qweb_partner New model TransientModel 9 fields 0 methods OpenItemsReportPartner · inherits report_qweb_abstract

report_qweb_abstract New model AbstractModel 0 fields 0 methods AbstractReport

report_trial_balance_qweb Extends TransientModel 0 fields 3 methods TrialBalanceReportCompute · inherits report_trial_balance_qweb Here, we just define methods. For class fields, go more top at this file.

report_trial_balance_qweb_account New model TransientModel 20 fields 0 methods TrialBalanceReportAccount · inherits report_qweb_abstract

report_trial_balance_qweb_partner New model TransientModel 11 fields 0 methods TrialBalanceReportPartner · inherits report_qweb_abstract

trial.balance.report.wizard New model TransientModel 19 fields 7 methods TrialBalanceReportWizard · Trial Balance Report Wizard Trial balance report wizard.

Migration considerations