Odoo Help


[9.0] Accounting Business Intelligence with analytic tag

Henrik Norlin
on 11/13/15, 6:44 AM 1,595 views


How can I get a pivot view on account.move.line where I can filter or group by analytic tags?

Relationships: account.move.line many2one account.analytic.account many2many account.analytic.tag

Thanks for any help! Below is a simple view, and I want to replace the column field with account.analytic tag:



<record id="view_account_move_line_pivot" model="ir.ui.view">

<field name="name">account.move.line.pivot</field>

<field name="model">account.move.line</field>

<field name="arch" type="xml">

<pivot string="Accounting Analysis">

<field name="account_id" type="row"/>

<field name="analytic_account_id" type="col"/>

<field name="balance" type="measure"/>




<record model="ir.actions.act_window" id="action_account_move_line_pivot">

<field name="name">action_account_move_line_pivot</field>

<field name="res_model">account.move.line</field>

<field name="view_mode">pivot</field>

<field name="view_id" ref="view_account_move_line_pivot"/>


<menuitem id="menu_account_move_line_pivot" parent="account.account_reports_business_intelligence_menu" name="Journal Items" sequence="10" action="action_account_move_line_pivot"/>



About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 11/13/15, 6:44 AM
Seen: 1595 times
Last updated: 11/13/15, 6:44 AM