Skip to Content
Menu
This question has been flagged
2378 Views

hi. i have a one2many field on which there is a python constraint that a sum of one of its fields must match a certain value. on record creation it works fine. but when editing the record and deleting a row of the one2omany field the deleted row is still taken in the constraint. please help

Version is updated v14.0 Community

Avatar
Discard

We cannot help you until you share your code, specially constraint.

Author

the code has grown quite large but ill try to compress:

class Order(models.Model):

order_line = fields.One2Many('order.line', ...

cost_center_line = fields.One2Many('cost_center_line', ...

amount_total = fields.Monetary(store=True, compute='_compute_amount')

amount_cost_center = fields.Monetary(store=True, compute='_compute_cost_center_amount')

@api.depends('order_line.price_total')

def _compute_amount(self):

for rec in self:

amount = 0.0

for line in rec.order_line:

amount += line.price_total

rec.amount_total = amount

@api.depends('cost_center_line.amount')

def _compute_cost_center_amount(self):

for rec in self:

amount = 0.0

for line in rec.cost_center_line:

amount += line.amount

rec.amount_cost_center = amount

@api.constrains('amount_total','amount_cost_center')

def _constrains_amount(self):

for rec in self:

if rec.amount_total != rec.amount.cost_center:

raise ValidationError('...')

Related Posts Replies Views Activity
2
Mar 24
5313
1
Nov 17
12286
1
Jun 15
4871
0
Jun 15
4834
3
Mar 15
5330