How to Add Measure in Purchase Analysis Report Odoo 12

Question

Report Preview [1]
​
from odoo import fields, models, api
class PurchaseReport(models.Model):
_inherit = 'purchase.report'
product_qty = fields.Float(string='Quantity', digits=dp.get_precision('Product Unit of Measure'), readonly=True)  qty_received = fields.Float(string="Received Qty", digits=dp.get_precision('Product Unit of Measure'), readonly=True)  qty_balanced = fields.Float(string="Balance", digits=dp.get_precision('Product Unit of Measure'), readonly=True)
def _select(self):
return super

Vishnu Vanneri · Accepted Answer

Hello,
Please try this code
def _select(self):
return super(PurchaseReport, self)._select() + ", sum(l.qty_received),sum(l.product_qty - l.qty_received*) as qty_balanced"* You can found your Balance in *Measures Button (Graph and Pivot).*

Anusha · Answer

Hi,
Just try this
def _select(self):
res = super(PurchaseReport, self)._select()
select_str = res + """,sum(l.product_qty -l.qty_received)
as qty_balanced"""
return select_str                                                                                                                                                                                                                                        qty_received and product_qty are already there in purchase order line.so we can directly take

Usman Farzand · Answer

i Use this

from odoo import fields, models, api
class PurchaseReport(models.Model):  _inherit = 'purchase.report'
qty_balanced = fields.Float(string="Balance",group_operator = 'avg', readonly=True)
def _select(self):
return super(PurchaseReport, self)._select() + ", (l.product_qty - l.qty_received) as qty_balanced"
def _group_by(self):
return super(PurchaseReport, self)._group_by() + ", l.product_qty" + ", l.qty_received"

Це запитання позначене

Enjoying the discussion? Don't just read, join in!