Skip to Content
This question has been flagged
invoiceaccount.invoicesale.orderodooV8
2 Replies
8165 Views
Avatar
E.M.

From sales.order object, how do I get the associated invoices?

I have tried to extend class stock.picking like this and added a function field:

#Field:

payment_method = fields.Char(compute='_get_payment_terms',string='Payment Method',readonly=True)

#Method:

@api.depends(''sale_id.invoice_ids','sale_id.invoice_ids.payment_method_id','sale_id.invoice_ids.payment_method_id.name')
def _get_payment_terms(self):
    self.payment_method = self.sale_id.invoice_ids and self.sale_id.invoice_ids[0].payment_method_id and self.sale_id.invoice_ids[0].payment_method_id.name or ''

When loading the module it says: fields = [model._fields[head]] KeyError: 'payment_method_id'

Is there anything obvious I could be missing?

Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

Hello E.M.,

There is a m2m field called "invoice_ids" in Sale Order which contains all the Invoices related to the SO.

I don't see "payment_method_id" field in account.invoice. Make sure you are using right field. I guess you want to show "Payment  Terms". For this you have to use "payment_term" field which is in "account.invoice".

Hope this will resolve your issue.

Thanks,

Avatar
Discard
E.M.
Author

In the GUI, if you select an invoice and go to "Other information" tab, you will find there: payment_method. That is what I am trying to recover.

Sudhir Arya (ERP Harbor Consulting Services)

Yes, you are right. But you are using wrong field in your code. You should use "payment_term" instead of "payment_method_id".

E.M.
Author

i finally found that I just had to use payment_method, not payment_method_id. However, if I do that I just got "bank_transfer", how can I get the descriptive text "Bank Transfer"

E.M.
Author

WOW I forgot payment_method was actually an extension I wrote a few months ago. Requesting support for your own custom module seems like kinda audacious.

Related Posts Replies Views Activity
How to link an existing invoice to a sale order?
invoice account.invoice sale.order
Avatar
0
May 15
7798
Error when try to convert order in invoice
account.invoice sale.order odooV8
Avatar
0
Apr 15
3472
How can I find where journal entries are generated when an invoice is validated? Solved
invoice account.invoice journal_entry odooV8
Avatar
Avatar
1
Feb 16
4812
import new field values from sale_order to invoice
invoice values sale.order odooV8
Avatar
0
Dec 15
2366
How to convert sale order total and invoice total to text and print them on the report in Arabic language ??
account.invoice sale.order amount_to_text odooV8
Avatar
0
Mar 15
3835