Skip to Content
This question has been flagged
productsale.order.lineproduct_id
3 Respostes
6352 Vistes
Avatar
Sebex S.A.

Hi, I would like to add the product_id in the sale.order.tree but don't find the solution.

<tree string="Sales Orders" fonts="bold:message_unread==True" colors="grey:state=='cancel';blue:state in ('waiting_date','manual');red:state in ('invoice_except','shipping_except')"> <field name="message_unread" invisible="1"/> <field name="name" string="Order Number"/> <field name="client_order_ref"/> <field name="date_order"/> <field name="partner_id"/> <field name="requested_date"/> <field name="amount_total" sum="Total Tax Included"/> <field name="state"/> </tree<>

Many thanks.

Avatar
Descartar
Avatar
Gopakumar N G
Best Answer

Field "product_id" is in the model sale.order.line and not in sale.order. So you cannot add it in Sale Order tree view, you can show the order_line in the tree view of sale_order.

Avatar
Descartar
Avatar
Victor Admin
Best Answer

I am trying to accomplish this same exact thing. I want to show a mini list of products and prices in the tree view for Sales Orders, so that customer service can see a brief overview of the whole order without having to open up the actual Sales Order. 

 

I understand that it's not possible to put sale.order.line inside of sale.order.tree, but would be possible to define a field in sales.order that inherits some values from sale.order.line, so that it could then be accessible from sale.order.tree?

Avatar
Descartar
Avatar
Sebex S.A.
Autor Best Answer

thanks. but the result is : (1 record) and not the name of the product. any solution ? thanks!

Avatar
Descartar
Gopakumar N G

can you explain your requirement?

Sebex S.A.
Autor

Sorry I was may be not very clear.

Sebex S.A.
Autor

In the menu "Sales" , "Sales Order" there is a view listing all the pending order. The original view list the fields : name, order_number, client_ref, client_order_ref... to make the things easier and faster to read I would like to add in the view the "product_id". If I add "order_line" field the result is "(1 record).

Gopakumar N G

You cannot add product_id in sale order list view as it is defined in sale.order.line. Consider one more point, if there are more than products in your sale order how can you list them in one line of the order?

Sebex S.A.
Autor

I understand what you mean. Tell me something, are you working as consultant ? I'm based in Sri Lanka travelling all the time, and don't find the time to set up correctly the system I would like. Give me your email so we can discuss a bit more... thanks. Peter

Related Posts Respostes Vistes Activitat
Change Sale Quotation Form so Product is Not Required?
product sale.order.line
Avatar
Avatar
Avatar
2
de març 18
4181
product sales relation
product sale.order.line boolean
Avatar
0
de gen. 23
1659
How to create product odoo V15 sale.order
product sale sale.order.line
Avatar
0
de des. 21
2433
Cannot change delivered quantity on Sales Order Line
product invoicing sale.order.line sales.order
Avatar
0
d’oct. 23
9606
How can display products vendor only in custom field Solved
product sale.order.line vendor related_fields
Avatar
Avatar
Avatar
3
de des. 22
7626