Se rendre au contenu
Cette question a été signalée
pythonodoo
1 Répondre
3610 Vues
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
Ignorer
Avatar
Sylvain Michel Ratsarafahatra
Meilleure réponse

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
Ignorer
Publications associées Réponses Vues Activité
Save filtered tree view to load as it is at another time Résolu
python odoo
Avatar
Avatar
Avatar
2
août 25
3413
Private functions and public functions in odoo python Résolu
python odoo
Avatar
Avatar
Avatar
Avatar
3
févr. 25
4834
odoo ghost module
python odoo
Avatar
0
mai 24
46
Call python method from inherit_id attribute
python odoo
Avatar
Avatar
1
avr. 24
4197
how Restrict users to see only his own invoice ?
python odoo
Avatar
Avatar
Avatar
Avatar
Avatar
4
sept. 23
6146