Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged

I want the Price_list field to keep the fixed_price value from the product_pricelist_item of the product in the invoice, but from my code. The value is 0. How should I fix a fixed_price value from a product_pricelist_item of a product stored in a field? Thanks for the help.
-----------------------------------------------------

class AccountInvoiceLine(models.Model):

  _inherit = 'account.invoice.line'

price_list = fields.Float('fixed_price ',compute='get_commission')

@api.multi

def get_commission(self):

self. price_list =  self.env.cr.execute\

("SELECT a.fixed_price FROM product_pricelist_item a"

"WHERE a.pricelist_id=2 AND a.product_id=%s",

(self.product_id.id,))

Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
5
sep. 20
63094
2
avg. 24
1738
2
feb. 22
5439
1
apr. 15
22782
2
feb. 25
1663