Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
viewtreecreditdebitdifference
1 Odgovori
6873 Prikazi
Avatar
Pascal Tremblay

Hello all,

How could I display somewhere on this tree view the difference between the debit and the credit.

Here, I would want somewhere displayed : 1524,58 - 9,75 = 1514,82 $.


Possible???

Thanks

UPDATE #1

I have used this code finally :

class account_move_line(osv.osv):
    _inherit = "account.move.line"
    #_logger.error("result_calcasdgfas dfsdfg sdfg asdfg sdf")
    def _result_calc(self, cr, uid, ids, name, arg, context=None):
        res = {}
        for aml in self.browse(cr, uid, ids, context=context):
            res[aml.id] =  aml.credit - aml.debit
        return res   
    _columns = {
        'result': fields.function(_result_calc, type='float', string='Total result')
    }

Avatar
Opusti
Avatar
Gerhard Baumgartner
Best Answer

If you want to have the exact string "1524,58 - 9,75 = 1514,82 $." I would recommend making a new field where you compute the difference. 

def _calc_diff(self):
     self.diff = self.debit-self.credit

diff = fields.Float(compute=_calc_diff)

And another field where you create a String with the exact format.

def _build_str(self):
    self.string = str(self.debit) + " - " + str(self.credit) + " = " + str(self.diff)  + " $"

string = fields.Char(compute=_build_str)


Add the new fields to your xml and that should be it.

Avatar
Opusti
Pascal Tremblay
Avtor

great thanks.

Gerhard Baumgartner

If you inherit the original model and you're working with odoo 8 or 9 it should work for sure. If you add to the original you'd just need to try, never tried mixing oldstyle fields and newstyle fields myself. If you're using an older version this new style won't work, but the logic is the same.

Related Posts Odgovori Prikazi Aktivnost
How to add css to any row in a tree view based on a condition Solved
view tree
Avatar
Avatar
1
mar. 15
13183
There is a fix for dynamic tree glitch?
view tree
Avatar
0
mar. 15
5030
Debit Currency area ??
current credit debit
Avatar
0
jan. 25
1557
How to color a field in tree view? Solved
view tree color
Avatar
Avatar
Avatar
2
okt. 24
13791
How to display uploaded image in tree view
image view tree
Avatar
Avatar
Avatar
Avatar
3
okt. 17
18426