Account balance reporting engine

account_balance_reporting · OCA/l10n-spain

    Repository
    OCA/l10n-spain · module folder · Try on Runboat
    Module version
    1.4.0
    Category
    Accounting & Finance
    Folder size
    0.64 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    http://www.pexego.es
    Last tracking update
    2026-08-07 07:17:42
    Authors
    Odoo Community Association (OCA), Pexego, AvanzOSC, Tecnativa
    Maintainers
    Odoo Community Association (OCA), Pexego, AvanzOSC, Tecnativa
    Committers
    Alexandre Fayolle, Pedro M. Baeza, Jairo Llopis, Carlos Dauden, Weblate, cubells, OCA Transbot, oca-travis
    Odoo dependencies
    OCA/server-tools:
    - date_range
    odoo/odoo:
    - account
    - base_setup
    - base
    - web_kanban
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - report
    - analytic
    - web_planner
    Python dependencies
    None
    System dependencies
    None
    Required by
    account_balance_reporting_xlsx, l10n_es_account_balance_report
    Description
    
    
    

    


    

    Code Analysis ⓘ
    

    Views touched (7)
    


    

    
    
    XML IDNameModelTypeStatus
    
    
        
        
    
            account_balance_reporting.report_generic
            account_balance_reporting.report_generic
            ir.ui.view
            qweb
            
                
                New
                
            
        
    
        
        
    
            report_generic_non_zero
            report_generic_non_zero
            ir.ui.view
            qweb
            
                
                Inherits account_balance_reporting.report_generic
                
            
        
    
        
        
    
            view_account_balance_reporting_form
            account.balance.reporting.form
            account.balance.reporting
            form
            
                
                New
                
            
        
    
        
        
    
            view_account_balance_reporting_template_form
            account.balance.reporting.template.form
            account.balance.reporting.template
            form
            
                
                New
                
            
        
    
        
        
    
            view_account_balance_reporting_template_tree
            account.balance.reporting.template.tree
            account.balance.reporting.template
            tree
            
                
                New
                
            
        
    
        
        
    
            view_account_balance_reporting_tree
            account.balance.reporting.tree
            account.balance.reporting
            tree
            
                
                New
                
            
        
    
        
        
    
            wizard_account_balance_reporting_print
            account.balance.reporting.print.wizard.form
            account.balance.reporting.print.wizard
            form
            
                
                New
                
            
        
    
        
        

    

    



    HTTP endpoints (0)
    


    No HTTP endpoints found for this module.
    



    Models touched (5)
    


    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (12)
                
                
      
                    
                    
    • 
                        calc_date
                        Datetime
                        
                        
      
                            
                            readonly=True
                            
                            string='Calculation date'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        company_id
                        Many2one → res.company
                        
                        
      
                            
                            comodel_name='res.company'
                            
                            default=<expr>
                            
                            ondelete='cascade'
                            
                            readonly=False
                            
                            required=True
                            
                            states=READONLY_STATES
                            
                            string='Company'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_date_from
                        Date
                        
                        
      
                            
                            required=True
                            
                            states=READONLY_STATES
                            
                            string='Date From'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_date_range
                        Many2one → date.range
                        
                        
      
                            
                            comodel_name='date.range'
                            
                            states=READONLY_STATES
                            
                            string='Date range'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_date_to
                        Date
                        
                        
      
                            
                            required=True
                            
                            states=READONLY_STATES
                            
                            string='Date To'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        line_ids
                        One2many → account.balance.reporting.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.line'
                            
                            inverse_name='report_id'
                            
                            states={'done': [('readonly', True)]}
                            
                            string='Lines'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            index=True
                            
                            required=True
                            
                            string='Name'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_date_from
                        Date
                        
                        
      
                            
                            states=READONLY_STATES
                            
                            string='Date From'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_date_range
                        Many2one → date.range
                        
                        
      
                            
                            comodel_name='date.range'
                            
                            states=READONLY_STATES
                            
                            string='Date range'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_date_to
                        Date
                        
                        
      
                            
                            states=READONLY_STATES
                            
                            string='Date To'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        state
                        Selection
                        
                        
      
                            
                            default='draft'
                            
                            selection=[('draft', 'Draft'), ('calc_done', 'Processed'), ('done', 'Done'), ('canceled', 'Canceled')]
                            
                            string='State'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        template_id
                        Many2one → account.balance.reporting.template
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template'
                            
                            index=True
                            
                            ondelete='set null'
                            
                            required=True
                            
                            states=READONLY_STATES
                            
                            string='Template'
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (6)
                
                
      
                    
                    
    • 
                        action_calculate(self)
                        
      @api.multi
      
                        
      Called when the user presses the Calculate button.
It will use the report template to generate lines of detail for the
report with calculated values.
      
                    
      • 
                    
                    
    • 
                        action_cancel(self)
                        
      @api.multi
      
                        
      Called when the user clicks the cancel button.
      
                    
      • 
                    
                    
    • 
                        action_confirm(self)
                        
      @api.multi
      
                        
      Called when the user clicks the confirm button.
      
                    
      • 
                    
                    
    • 
                        action_recover(self)
                        
      @api.multi
      
                        
      Called when the user clicks the draft button to create
a new workflow instance.
      
                    
      • 
                    
                    
    • 
                        onchange_current_date_range(self)
                        
      @api.multi@api.onchange('current_date_range')
      
                        
                    
      • 
                    
                    
    • 
                        onchange_previous_date_range(self)
                        
      @api.multi@api.onchange('previous_date_range')
      
                        
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (17)
                
                
      
                    
                    
    • 
                        calc_date
                        Datetime
                        
                        
      
                            
                            string='Calculation date'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        child_ids
                        One2many → account.balance.reporting.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.line'
                            
                            inverse_name='parent_id'
                            
                            string='Children'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        code
                        Char
                        
                        
      
                            
                            index=True
                            
                            required=True
                            
                            string='Code'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        css_class
                        Selection
                        
                        
      
                            
                            default='default'
                            
                            selection=CSS_CLASSES
                            
                            string='CSS Class'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_move_line_count
                        Integer
                        
                        
      
                            
                            compute='_compute_current_move_line_count'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_move_line_ids
                        Many2many → account.move.line
                        
                        
      
                            
                            comodel_name='account.move.line'
                            
                            string='Journal items (current)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_value
                        Float
                        
                        
      
                            
                            digits=(16, 2)
                            
                            string='Fiscal year 1'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        display_name
                        Char
                        
                        
      
                            
                            compute='_compute_display_name'
                            
                            index=True
                            
                            store=True
                            
                            string='Name'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            index=True
                            
                            required=True
                            
                            string='Name'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        notes
                        Text
                        
                        
      
                            
                            
                            
                            args: 'Notes'
                        
      
                        
                    
      • 
                    
                    
    • 
                        parent_id
                        Many2one → account.balance.reporting.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.line'
                            
                            ondelete='cascade'
                            
                            string='Parent'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_move_line_count
                        Integer
                        
                        
      
                            
                            compute='_compute_previous_move_line_count'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_move_line_ids
                        Many2many → account.move.line
                        
                        
      
                            
                            column1='line_id'
                            
                            column2='report_id'
                            
                            comodel_name='account.move.line'
                            
                            relation='account_balance_reporting_line_previous_move_line_rel'
                            
                            string='Journal items (previous)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_value
                        Float
                        
                        
      
                            
                            digits=(16, 2)
                            
                            string='Fiscal year 2'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        report_id
                        Many2one → account.balance.reporting
                        
                        
      
                            
                            comodel_name='account.balance.reporting'
                            
                            ondelete='cascade'
                            
                            string='Report'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sequence
                        Integer
                        
                        
      
                            
                            default=10
                            
                            required=True
                            
                            string='Sequence'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        template_line_id
                        Many2one → account.balance.reporting.template.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template.line'
                            
                            ondelete='set null'
                            
                            string='Line template'
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (5)
                
                
      
                    
                    
    • 
                        name_get(self)
                        
      @api.multi
      
                        
      Redefine the method to show the code in the name ("[code] name").
      
                    
      • 
                    
                    
    • 
                        name_search(self, name='', args=None, operator='ilike', limit=100)
                        
      @api.model
      
                        
      Allow to search by code.
      
                    
      • 
                    
                    
    • 
                        refresh_values(self)
                        
      @api.multi
      
                        
      Recalculates the values of report lines using the
linked line report values formulas:

Depending on this formula the final value is calculated as follows:
- Empty report value: sum of (this concept) children values.
- Number with decimal point ("10.2"): that value (constant).
- Account numbers separated by commas ("430,431,(437)"): Sum of the
    account balances.
    (The sign of the balance depends on the balance mode)
- Concept codes separated by "+" ("11000+12000"): Sum of those
    concepts values.
      
                    
      • 
                    
                    
    • 
                        show_move_lines_current(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                    
    • 
                        show_move_lines_previous(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (2)
                
                
      
                    
                    
    • 
                        report_id
                        Many2one → account.balance.reporting
                        
                        
      
                            
                            
                            
                            default=_default_report_id
                            
                            args: 'account.balance.reporting', 'Report'
                        
      
                        
                    
      • 
                    
                    
    • 
                        report_xml_id
                        Many2one → ir.actions.report.xml
                        
                        
      
                            
                            
                            
                            default=_default_report_xml_id
                            
                            args: 'ir.actions.report.xml', 'Design'
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (1)
                
                
      
                    
                    
    • 
                        print_report(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (6)
                
                
      
                    
                    
    • 
                        balance_mode
                        Selection
                        
                        
      
                            
                            
                            
                            default='0'
                            
                            help='Formula calculation mode: Depending on it, the balance is calculated as follows:\nMode 0: debit-credit (default);\nMode 1: debit-credit, credit-debit for accounts in brackets;\nMode 2: credit-debit;\nMode 3: credit-debit, debit-credit for accounts in brackets.'
                            
                            string='Balance mode'
                            
                            args: [('0', 'Debit-Credit'), ('1', 'Debit-Credit, reversed with brackets'), ('2', 'Credit-Debit'), ('3', 'Credit-Debit, reversed with brackets')]
                        
      
                        
                    
      • 
                    
                    
    • 
                        description
                        Text
                        
                        
      
                            
                            
                            
                            args: 'Description'
                        
      
                        
                    
      • 
                    
                    
    • 
                        line_ids
                        One2many → account.balance.reporting.template.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template.line'
                            
                            inverse_name='template_id'
                            
                            string='Lines'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            index=True
                            
                            required=True
                            
                            size=64
                            
                            string='Name'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        report_xml_id
                        Many2one → ir.actions.report.xml
                        
                        
      
                            
                            comodel_name='ir.actions.report.xml'
                            
                            ondelete='set null'
                            
                            string='Report design'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        tmpl_type
                        Selection
                        
                        
      
                            
                            default='user'
                            
                            old_name='type'
                            
                            selection=[('system', 'System'), ('user', 'User')]
                            
                            string='Type'
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (1)
                
                
      
                    
                    
    • 
                        copy(self, default=None)
                        
      @api.multi
      
                        
      Redefine the copy method to perform it correctly as the line
structure is a graph.
      
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (10)
                
                
      
                    
                    
    • 
                        child_ids
                        One2many → account.balance.reporting.template.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template.line'
                            
                            inverse_name='parent_id'
                            
                            string='Children'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        code
                        Char
                        
                        
      
                            
                            help='Concept code, may be used on formulas to reference this line'
                            
                            index=True
                            
                            required=True
                            
                            size=64
                            
                            string='Code'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        css_class
                        Selection
                        
                        
      
                            
                            default='default'
                            
                            help='Style-sheet class'
                            
                            required=False
                            
                            selection=CSS_CLASSES
                            
                            string='CSS Class'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        current_value
                        Text
                        
                        
      
                            
                            help=_VALUE_FORMULA_HELP
                            
                            string='Fiscal year 1 formula'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            help='Concept name/description'
                            
                            index=True
                            
                            required=True
                            
                            size=256
                            
                            string='Name'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        negate
                        Boolean
                        
                        
      
                            
                            help='Negate the value (change the sign of the balance)'
                            
                            string='Negate'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        parent_id
                        Many2one → account.balance.reporting.template.line
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template.line'
                            
                            ondelete='cascade'
                            
                            string='Parent'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        previous_value
                        Text
                        
                        
      
                            
                            help=_VALUE_FORMULA_HELP
                            
                            string='Fiscal year 2 formula'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sequence
                        Integer
                        
                        
      
                            
                            default=10
                            
                            help='Lines will be sorted/grouped by this field'
                            
                            required=True
                            
                            string='Sequence'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        template_id
                        Many2one → account.balance.reporting.template
                        
                        
      
                            
                            comodel_name='account.balance.reporting.template'
                            
                            ondelete='cascade'
                            
                            string='Template'
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (2)
                
                
      
                    
                    
    • 
                        name_get(self)
                        
      @api.multi
      
                        
      Redefine the name_get method to show the code in the name
("[code] name").
      
                    
      • 
                    
                    
    • 
                        name_search(self, name='', args=None, operator='ilike', limit=100)
                        
      @api.model
      
                        
      Allow to search by code.
      
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    

    


    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…