Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
salesale.order.lineodoo10.0
4 ตอบกลับ
27738 มุมมอง
อวตาร
tyrion

I have a sale.order.line field commission_line that computes the commission amount of the product line.

class SaleOrderlineInherited(models.Model):
    _inherit = 'sale.order.line'
    commission_line_percentage = fields.Float(related='product_id.product_tmpl_id.commission_percentage')
    commission_line = fields.Float(string='Commission', compute='get_commission')
    @api.depends('commission_line_percentage')    
    def get_commission(self):
        for record in self:
            record['commission_line'] = (record.price_subtotal * record.commission_line_percentage) / 100
        return None

The above code runs fine. Next I want to calculate all the sum of commission_line fields to get the total commission from the sale.order. I tried this code.

class CustommSaleOrder(models.Model):
    _inherit = 'sale.order'
    commission = fields.Char(string='Total Commission', compute='calculate_total_commission')
    def calculate_total_commission(self):
        print 'came in'
        summ = None
        for record in self.env['sale.order.line']:
            print 'commission'
            summ += record.commission_line_percentage
        self.env['sale.order'].commission = summ
        return None

This doesn't work. How to correct the code so as to get the sum of all commission_line as the total commission?

Thanks in advance.


อวตาร
ละทิ้ง
อวตาร
Niyas Raphy (Walnut Software Solutions)
คำตอบที่ดีที่สุด

Hi,

Try like this,

@api.depends('order_line.commission_line')
def _commission_amount(self):  
    for order in self:      
        comm_total = 0.0       
        for line in order.order_line:      
             comm_total += line.commission_line    
        order.update({'commission': comm_total })


Thanks

อวตาร
ละทิ้ง
อวตาร
lukondechitula@gmail.com
คำตอบที่ดีที่สุด

Try

@api.depends('order_line')
def _commission_amount(self):
for order in self:
comm_total = 0.0
for line in order.order_line:
comm_total += line.commission_line

อวตาร
ละทิ้ง
อวตาร
Ahmed Vahed
คำตอบที่ดีที่สุด

Neither of the above worked for me. I created a float variable x_studio_nett_untaxed_total_1 with Related field order_line.x_studio_nett_total - another field I created. It is only using the first line of the order as the total. I have tried both ways above.

Related Field : order_line.x_studio_nett_total

De[endencies : order_line.x_studio_nett_total, x_studio_nett_untaxed_total_1

Computed : 

@api.depends('order_line.x_studio_nett_total')

def _line_total(self) :

for order in self:

  line_total = 0.0

  for line in order.order_line:  

    line_total += line.x_studio_nett_total

  order.update({'x_studio_nett_untaxed_total_1':line_total})

อวตาร
ละทิ้ง
อวตาร
Michael Yeung
คำตอบที่ดีที่สุด

Sorry for off topic! @Niyas, you are the best! I applied the formula on the total discount for SO with computed field. Sharing for reference...

float field on sale.order.line, x_price_discount_amount;

float field on sale.order, x_price_discount_amount_total, depends=order_line.x_price_discount_amount

for record in self:
  discount_total = 0.0
  for line in record.order_line:  
    discount_total += line.x_price_discount_amount
  record['x_price_discount_amount_total'] = discount_total

It works! Thanks so much.

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
How to generate line numbers on quotes แก้ไขแล้ว
sale sale.order.line
อวตาร
อวตาร
1
ม.ค. 25
4402
How to add freight charges to product cost in sale quoatation
sale sale.order.line
อวตาร
อวตาร
2
ส.ค. 24
6429
What's the use of Allotment Partner in sale order line? แก้ไขแล้ว
sale sale.order.line
อวตาร
อวตาร
อวตาร
อวตาร
อวตาร
6
ธ.ค. 22
9789
how to find out where the "record" is stored, in which file and part of the pyton?
sale sale.order.line record sale.order odoo10.0
อวตาร
0
ก.ค. 19
669
[odoo 10] How to set a product category field to the sale order line?
sale sale.order.line sale.order sales.order odoo10.0
อวตาร
อวตาร
อวตาร
อวตาร
6
ก.พ. 19
11008