Hi,
I need to have a form view that shows all Journals and balance for each one.
But here, the balance is calculated based on the journal's payments not journal items.
Each 'Inbound' payment is considered a Debit and each 'Outbound' payment is considered a Credit.
Balance is Debit minus Credit.
Here is my code:
from odoo import fields, models, api
from odoo.exceptions import UserError,ValidationError
class JournalLine(models.TransientModel):
_name = 'journal.line'
move_id = fields.Many2one( comodel_name='journal', string='Journal' )
journal_name = fields.Char( string="Journal" )
sum_debit = fields.Float( string='Debit', default=0.00 )
sum_credit = fields.Float( string='Credit', default=0.00 )
balance = fields.Float( string='Balance', default=0.00 )
currency_id = fields.Many2one( 'res.currency', string='Currency' )
class Journal(models.TransientModel):
_name = 'journal'
line_ids = fields.One2many( 'journal.line', 'move_id', string='Journal lines', default=lambda self: self._compute_journal_lines() )
def _compute_journal_lines(self):
comodel_obj = self.env['journal.line']
journals = self.env['account.journal'].search([('active','=',True)])
domain = []
for journal in journals:
lines = {}
domain = [('journal_id', '=', journal.id),('state','=','posted')] payment_ids = self.env['account.payment'].search(domain)
sum_debit = 0.00
sum_credit = 0.00
balance = 0.00
if payment_ids:
for payment in payment_ids:
if payment.payment_type == 'inbound':
sum_debit += payment.debit
else:
sum_credit += payment.credit
line = {
'move_id': self.id,
'journal_name': journal.name,
'currency_id': journal.currency_id.id,
'sum_debit': sum_debit,
'sum_credit': sum_credit,
'balance': sum_debit - sum_credit
}
new_record = comodel_obj.create(line)
self.write({ 'line_ids': [(4, new_record.id)] })
But the code does not work and in the form view, It shows nothing.
As I debug the code, I see all line_ids are produced successfully but I think binding it to the Journal is the main problem.
Can someone help me out?
