osbzr/gooderp_addons

<?xml version="1.0" encoding="utf-8"?>
<openerp>
    <data>
        <record id='report_stock_balance_tree' model='ir.ui.view'>
            <field name='name'>report.stock.balance.tree</field>
            <field name='model'>report.stock.balance</field>
            <field name='arch' type='xml'>
                <tree string='商品库存余额表'>
                    <field name='goods' />
                    <field name='attribute_id' groups='goods.multi_attrs_groups' />
                    <field name='lot' groups='goods.batch_groups' />
                    <field name="location" groups="warehouse.multi_location_groups"/>
                    <field name='uom' />
                    <field name='uos' groups='goods.auxiliary_unit_groups' />
                    <field name='warehouse' groups='warehouse.multi_warehouse_groups' />
                    <field name='goods_uos_qty' groups='goods.auxiliary_unit_groups' sum='辅助数量合计' />
                    <field name='goods_qty' sum='数量合计' />
                    <field name='cost' sum='成本合计' />
                </tree>
            </field>
        </record>

        <record id='report_stock_balance_graph' model='ir.ui.view'>
            <field name='name'>report.stock.balance.graph</field>
            <field name='model'>report.stock.balance</field>
            <field name='arch' type='xml'>
                <pivot string="商品库存余额表">
                    <field name='goods' type='row' />
                    <field name='attribute_id' type='col' groups='goods.multi_attrs_groups' />
                    <field name='warehouse' type='col' groups='warehouse.multi_warehouse_groups' />
                    <field name='goods_qty' type='measure' />
                    <field name='goods_uos_qty' type='measure' groups='goods.auxiliary_unit_groups' />
                    <field name='cost' type='measure' groups='goods.view_cost_groups'/>
                </pivot>
            </field>
        </record>

        <record id='report_stock_balance_search' model='ir.ui.view'>
            <field name='name'>report.stock.balance.search</field>
            <field name='model'>report.stock.balance</field>
            <field name='arch' type='xml'>
                <search string='商品库存余额表' >
                    <field name='goods' string='编号/商品名' filter_domain="[('goods_id', 'ilike', self)]" />
                    <field name='lot' string='批号' filter_domain="[('lot', 'ilike', self)]" groups='goods.batch_groups' />
                    <field name='warehouse' string='仓库' filter_domain="[('warehouse', 'ilike', self)]" groups='warehouse.multi_warehouse_groups' />

                    <group expand="0" string="Group By">
                        <filter string="商品" context="{'group_by':'goods'}"/>
                        <filter string="批号" context="{'group_by': 'lot'}" groups='goods.batch_groups'/>
                        <filter string="仓库" context="{'group_by': 'warehouse'}" groups='warehouse.multi_warehouse_groups'/>
                        <filter string="单位" context="{'group_by': 'uom'}"/>
                        <filter string="辅助单位" context="{'group_by': 'uos'}" groups='goods.auxiliary_unit_groups'/>
                    </group>
                </search>
            </field>
        </record>
    </data>
</openerp>