Hello all,

On Odoo 8, I added a new pivot table in a custom dashboard.

Pivot table is on the model stock.quant.

Actually, the pivot table appears with the fields location_id and product_id (two fields of the stock.quant model). See image and code below.

But instead, I would want a pivot table with the warehouse_id and the product_category_id. But these two fields don't exist on the stock.quant model.

Should I create two new fields (warehouse_id and product_category_id) on the stock.quant model? May be two new relational or functionnal fields...

Is this the best approach?

Comments?

Image

The code of this pivot table :

<record id="inventory_pivot_1" model="ir.ui.view">
            <field name="name">inventory.pivot.1</field>
            <field name="model">stock.quant</field>
            <field name="arch" type="xml">
                <graph string="My inventory pivot #1" type="pivot">
                    <field name="product_id" type="row"/>
                    <field name="location_id"  type="col"/>
                </graph>
            </field>
        </record>