Odoo Help

Welcome!

This community 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.

0

[9.0] Accounting Business Intelligence with analytic tag

By
Henrik Norlin
on 11/13/15, 6:44 AM 622 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>

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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