from odoo import models, api, fields, _ from odoo.exceptions import AccessError, UserError, ValidationError class AccountMoveLine(models.Model): _inherit = "account.move.line" qty_outstanding = fields.Float(string='Qty Outstanding', compute='_compute_qty_outstanding') invoice_marketplace = fields.Text("Invoice Mearketplace", compute='_compute_invoice_marketplace') faktur_pajak = fields.Char(string='Faktur Pajak', compute='_compute_faktur_pajak') def _compute_faktur_pajak(self): for line in self: line.faktur_pajak = False move = line.move_id if not move: continue line.faktur_pajak = move.efaktur_id.name if move.efaktur_id else False def action_gl_reconcile(self): lines = self journal = self.env['account.journal'].search([ ('suspense_account_id', '=', lines[0].account_id.id) ], limit=1) if not journal: raise UserError('Journal dengan suspense account ini tidak ditemukan!') statement = self.env['account.bank.statement'].create({ 'journal_id': journal.id, 'name': f'REKONSIL {journal.name} {lines[0].date.strftime("%d-%m-%Y")}', 'company_id': self.env.company.id, 'date': lines[0].date, }) widget_vals = [] st_line_ids = [] for line in lines: amount = line.debit - line.credit st_line = self.env['account.bank.statement.line'].create({ 'statement_id': statement.id, 'date': line.date or fields.Date.today(), 'payment_ref': line.name, 'partner_id': line.partner_id.id, 'amount': amount, 'ref': line.name, }) st_line_ids.append(st_line.id) widget_vals.append({ 'partner_id': st_line.partner_id.id, 'counterpart_aml_dicts': [{ 'counterpart_aml_id': line.id, 'debit': abs(amount) if amount < 0 else 0, 'credit': abs(amount) if amount > 0 else 0, 'name': line.name or '/', }], 'payment_aml_ids': [], 'new_aml_dicts': [], 'to_check': False, }) statement.button_post() self.env['account.reconciliation.widget'].process_bank_statement_line( st_line_ids, widget_vals ) # statement.button_validate_or_action() return { 'effect': { 'fadeout': 'slow', 'message': 'Statement + Auto Reconcile sukses besar 😎🔥', 'type': 'rainbow_man', } } @api.depends( 'move_id', 'move_id.line_ids.matched_debit_ids', 'move_id.line_ids.matched_credit_ids', ) def _compute_invoice_marketplace(self): for line in self: line.invoice_marketplace = False move = line.move_id if not move: continue # invoice if move.move_type in ('out_invoice', 'in_invoice'): line.invoice_marketplace = move.invoice_marketplace # kas?/entries else: line.invoice_marketplace = move.reklas_used_by.invoice_marketplace if move.reklas_used_by else False def _compute_qty_outstanding(self): for line in self: qty_received = line.purchase_line_id.qty_received qty_billed = line.purchase_line_id.qty_invoiced line.qty_outstanding = qty_received - qty_billed @api.onchange('quantity') def _onchange_quantity(self): for line in self: if line.move_id.move_type == 'in_invoice' and line.id.origin: if line and line.quantity > line.qty_outstanding and line.qty_outstanding > 0: raise UserError(_("Quantity Tidak Boleh Melebihi Qty Outstanding"))