Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
2 Vastaukset
2914 Näkymät
Avatar
Franz Ofner

Hi there,

i try to get a relation between account_invoice and sales_order to show a custom field of sales_order in my invoice report. Therefore i inherit account.invoice with a sales_order_id field.

# -*- coding: utf-8 -*-
from odoo import models, fields, api
class account_invoice(models.Model):
    _inherit = "account.invoice" sale_order_id = fields.Many2one('sale.order', string='Related Order') 

I want to access the value of the custom field ( e.g. tm_short_description ) in the invoice report ( o.sale_order_id.tm_short_description )
The problem is, creating a new invoice, the account_invoice.sales_order_id will not be filled. Updating it manually the report is ok. Do i have to override some default original function to get the sales_order_id to account.invoice ?

Thanks for your help,

Franz

Avatar
Hylkää
Avatar
Emipro Technologies Pvt. Ltd.
Paras vastaus

You should not create new field in  the invoice, based on invoice line we can  get sale order id.

Example :

order=invoice.invoice_line_ids.mapped('sale_line_ids').mapped('order_id')

This may help you.

Avatar
Hylkää
Avatar
Franz Ofner
Tekijä Paras vastaus

Sorry,

I didn't understand the way you show to me. Where do I have to place such code to get the sale_order field in my invoice report ? Do you have a link for me to read more about this way ?

Kind regards,

Franz

Problem has been solved. I added t-field="l.invoice_line_ids.sale_line_ids.order_id.tm_short_description" to the report and this will show me the field from sale_order in my invoice report.
Thank you so much !

Avatar
Hylkää