Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

How can I Inherit Existing Pivot, graph View Reports and add a field to "purchase.report" ?

purchase.order.line

3 Ответы

5253 Представления

Jay

Hi, I'm using Odoo 14 and I want to add price_unit from purchase_order_line to pivot and graph view of purchase.report. This will involve inheriting pivot and graph of purchase.report model .

Here is the error I'm getting .

error

psycopg2.errors.UndefinedColumn: column purchase_report.price_unit does not exist
LINE 3: ..._order_line" AS "purchase_report__price_unit" ON ("purchase_...

My Model

class PurchaseReport(models.Model):
    _inherit = "purchase.report"

    price_unit = fields.Many2one('purchase.order.line', string='Unit Price')    
        def _query(self, with_clause='', fields={}, groupby='', from_clause=''):
        fields['price_unit'] = ", s.price_unit as price_unit"
        groupby += ', s.price_unit'
        return super(PurchaseReport, self)._query(with_clause, fields, groupby, from_clause)

Jay

Автор

<?xml version="1.0" encoding="utf-8"?>
<odoo>

<record model="ir.ui.view" id="view_purchase_order_inherit_pivot">
<field name="name">product.month.pivot.inherit</field>
<field name="model">purchase.report</field>
<field name="inherit_id" ref="purchase.view_purchase_order_pivot"/>
<field name="arch" type="xml">
<xpath expr="//field[@name='untaxed_total']" position="before">
<field name="price_unit" type="col"/>
<field name="price_unit" type="measure"/>
</xpath>
</field>
</record>
<record model="ir.ui.view" id="view_purchase_order_inherit_graph">
<field name="name">product.month.graph.inherit</field>
<field name="model">purchase.report</field>
<field name="inherit_id" ref="purchase.view_purchase_order_graph"/>
<field name="arch" type="xml">
<xpath expr="//field[@name='untaxed_total']" position="before">
<field name="price_unit" type="row"/>
<field name="price_unit" type="measure"/>
</xpath>
</field>
</record>

</odoo>

Sunny Sheth

Лучший ответ

Hi,

You try below  solution,  it  will  work  for  you.

class PurchaseReport(models.Model):
    _inherit = "purchase.report"
 
    picking_type_id = fields.Many2one('stock.warehouse', 'Warehouse', readonly=True)
    

    def _select(self):
        return super(PurchaseReport, self)._select() + ", spt.warehouse_id as picking_type_id"

    def _from(self):
        return super(PurchaseReport, self)._from() + " left join stock_picking_type spt on (spt.id=po.picking_type_id)"

    def _group_by(self):
        return super(PurchaseReport, self)._group_by() + ", spt.warehouse_id"


Thanks and Regards,
Sunny Sheth

Cheikh Diop

I am using this but I have an error when click the field in pivot view as LINE 3: ...ehouse" as "purchase_report__picking_type_id" ON ("purchase_...

Farid Ghanchi

You can just add new fields defination then add that fields is in Select and used in Groupby here we used l.price_unit because l meanse purchase_order_line.

Just apply this code and checked may be fixed your issue.

class PurchaseReport(models.Model):
       _inherit = "purchase.report"

       price_unit = fields.Many2one('purchase.order.line', string='Unit Price')

       def _select(self):
               return super(PurchaseReport, self)._select() + ", l.price_unit as price_unit"

       def _group_by(self):
               return super(PurchaseReport, self)._group_by() + ", l.price_unit"

Jay

Автор

@Sunny and @Farid Thank you for taking your time to help.

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
Modify Purchase Order Lines cancel purchase.order.line	1 окт. 24	3222
How to make order line field visible in search view. purchase.order purchase.order.line	2 нояб. 22	3886
How can I customize purchase order report and purchase order form view Решено purchase_order purchase.order.line	1 сент. 21	8099
The operation cannot be completed!! Issue... vendor purchase.order purchase.order.line	0 янв. 24	2723
Expected delivery date in purchase request date delivery purchase.order.line	0 нояб. 23	3010

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!