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

إدارة علاقات العملاء
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 الردود

5228 أدوات العرض

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	3211
How to make order line field visible in search view. purchase.order purchase.order.line	2 نوفمبر 22	3870
How can I customize purchase order report and purchase order form view تم الحل purchase_order purchase.order.line	1 سبتمبر 21	8083
The operation cannot be completed!! Issue... vendor purchase.order purchase.order.line	0 يناير 24	2711
Expected delivery date in purchase request date delivery purchase.order.line	0 نوفمبر 23	3002

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!