Odoo Help

0

[9.0] Accounting Business Intelligence with analytic tag

By
Henrik Norlin
on 11/13/15, 6:44 AM 881 views

Hi,

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:

<openerp>

<data>

<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"/>

</pivot>

</field>

</record>

<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"/>

</record>

<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"/>

</data>

</openerp>

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.

Register

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)

Stats

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