Skip to Content
This question has been flagged
productsale.order.lineproduct_id
3 Replies
5736 Views
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
Discard
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
Discard
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
Discard
Avatar
Sebex S.A.
Author Best Answer

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

Avatar
Discard
Gopakumar N G

can you explain your requirement?

Sebex S.A.
Author

Sorry I was may be not very clear.

Sebex S.A.
Author

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.
Author

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 Replies Views Activity
Change Sale Quotation Form so Product is Not Required?
product sale.order.line
Avatar
Avatar
Avatar
2
Mar 18
3667
product sales relation
product sale.order.line boolean
Avatar
0
Jan 23
1298
How to create product odoo V15 sale.order
product sale sale.order.line
Avatar
0
Dec 21
1745
Cannot change delivered quantity on Sales Order Line
product invoicing sale.order.line sales.order
Avatar
0
Oct 23
8937
How can display products vendor only in custom field Solved
product sale.order.line vendor related_fields
Avatar
Avatar
Avatar
3
Dec 22
6997