Skip to Content
This question has been flagged
pythonodoo
1 Respondre
3583 Vistes
Avatar
AZCHILENO .

I am trying to add an attribute that has several totals from other tables and that influences the type of account it is in. For example in an account called "Bank" I have totals 5, 10, 15 and the sum of all those totals is 30. To do this I have two tables that are "document_ detail" and "account". In the table "document_detail" I have the total_debt attribute which in this attribute the totals of other products are added and the account of where "bank" is added in this case is added.

I have used this method to add but it does not:

@ api.multi

  @ api.depends ("account_id")

  def _sum_of_credit (self):

    self.sum_total_credit = sum (line.total_credit for line in self) if self.account_id.title == "Cash" or self.account_id.title == "Bank" else 0

I attached an image to see what I want to reach:  \photoexample  https://ibb.co/1rZv0TV


Avatar
Descartar
Avatar
Sylvain Michel Ratsarafahatra
Best Answer

Hi!

Here is an example how to compute the total line, you can adapt it as you need :

class AccountMove(models.Model):
    _inherit = "account.move"

    sum_of_credit = fields.Float(compute='_compute_sum_of_credit', string='Total Credit')

    @api.depends('move_line')
    def _compute_sum_of_credit(self):
        self.sum_of_credit = sum(line.credit for line in self.move_line_ids.filtered(lambda x: x.account_id.user_type_id.type in ['cash', 'bank']))

Best regards!

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Save filtered tree view to load as it is at another time Solved
python odoo
Avatar
Avatar
Avatar
2
d’ag. 25
3340
Private functions and public functions in odoo python Solved
python odoo
Avatar
Avatar
Avatar
Avatar
3
de febr. 25
4754
odoo ghost module
python odoo
Avatar
0
de maig 24
46
Call python method from inherit_id attribute
python odoo
Avatar
Avatar
1
d’abr. 24
4138
how Restrict users to see only his own invoice ?
python odoo
Avatar
Avatar
Avatar
Avatar
Avatar
4
de set. 23
6076