コンテンツへスキップ
この質問にフラグが付けられました
purchase.order.line
3 返信
5275 ビュー
アバター
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
10月 24
3226
How to make order line field visible in search view.
purchase.order purchase.order.line
アバター
アバター
2
11月 22
3904
How can I customize purchase order report and purchase order form view 解決済
purchase_order purchase.order.line
アバター
アバター
1
9月 21
8115
The operation cannot be completed!! Issue...
vendor purchase.order purchase.order.line
アバター
0
1月 24
2736
Expected delivery date in purchase request
date delivery purchase.order.line
アバター
0
11月 23
3020