Skip to Content
Menu
This question has been flagged
2334 Views

only logic with the below formula is , first check if last invoice date to selected customer is less than selected invoice date, if yes then check if last issued bill was paid by him on or before last invoice due date, if yes, then current_lps = 0 , if not then current_lps = amount_payable * 0.15.



Problem: the field is showing empty didn't do any calculations nor any error has been face.



class CurrentLPS(models.Model):

_inherit = 'account.move'



current_lps = fields.Float(string='Current LPS', store=True, help='Place to store the amount',readonly=True)



@api.depends('partner_id', 'invoice_date')

def _compute_current_lps(self):

for move in self:

last_invoice = move.env['account.move'].search([

('partner_id', '=', move . partner_id. id),

('move_type', '=', 'out_invoice'),

], order='invoice_date desc, id desc', limit=1)



if last_invoice and last_invoice.invoice_date < move.invoice_date:

# Find the last payment for the last invoice

last_payment = self.env['account.payment'].search([

('partner_id', '=',  move,partner_id,id),

('communication', '=', last_invoice.invoice_payment_term_id),

('payment_date', '<=', last_invoice.invoice_date_due),

], order='payment_date desc', limit=1)



if last_payment and last_payment.state == 'posted':

move.current_lps = 0.0

else:

move.current_lps = move.amount_payable * 0.15

else:

move.current_lps = move.amount_payable * 0.15

Avatar
Discard
Related Posts Replies Views Activity
0
May 24
1185
2
Mar 24
2227
2
Jun 23
8668
0
May 23
90
4
Aug 25
26594