Skip to Content
Menu
This question has been flagged

Hello Community.

In the model account_move, I have a field called "invoice_origin" that have the ID of a sale order. It's define like this:

invoice_origin = fields.Char(string='Origin', readonly=True, tracking=True)

I need the entire sale.order because a need the the "business_unit_it", but I onlyhave this data. How can I search and return the entire sale.order, in the move_account file?


I've tried something like this but it doesn't work


client_order_ref = fields.Char('get_sale_order().client_order_ref')

# Get a sale order with the invoice_origin field
def get_sale_order(self):
sale_order = self.env['sale.order'].search([
('name', '=', self.invoice_origin)
])
return sale_order


Thank you! :)

Avatar
Discard
Best Answer

Hi 

Try,

client_order_ref = fields.Char(compute='_get_sale_order')

# Get a sale order with the invoice_origin field
def _get_sale_order(self):
for rec in self:
sale_order = self.env['sale.order'].search([
('id', '=', int(rec.invoice_origin))
])
rec.client_order_ref = sale_order.name if sale_order else False


Avatar
Discard
Related Posts Replies Views Activity
0
Oct 22
2433
0
Aug 21
2429
2
Sep 23
9894
1
Mar 23
2509
1
Sep 22
2366