Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2147 Widoki

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
0
maj 24
1052
2
mar 24
1979
2
cze 23
8415
0
maj 23
90
4
maj 22
26088