There are two ways you can add custom sale order line in Odoo 12.<\/p>\n\n\n\n
First Method<\/strong><\/p>\n\n\n\n You can search the sale order first with the name or browse with the ID<\/p>\n\n\n\n Now, you can see the sale order line IDs using the following:<\/p>\n\n\n\n As this is a One2many relation, we need to use a tuple in the Odoo ORM write() method. Here is the list of data you can pass in a tuple to change data that has One2many or Many2many relation<\/p>\n\n\n\n Odoo ORM Documentation<\/a><\/p>\n\n\n\n You can now pass this as python dictionary for ‘order_line’ to sale.order of desired product as following:<\/p>\n\n\n\n Second Method<\/strong><\/p>\n\n\n\n In this method, you can simply define the order dictionary, and create a sale.order.line item with the order_id in reference. Here is an example<\/p>\n\n\n\n Note<\/strong><\/p>\n\n\n\n If you are doing\/testing this on the Odoo Shell, then make sure to run the following after the changes to reflect on database:<\/p>\n\n\n\n Odoo doesn’t call database cursor commit if you are coding on Odoo shell, it calls automatically though if you are doing it in a module. Just a friendly reminder!<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" There are two ways you can add custom sale order line in Odoo 12. First Method You can search the sale order first with the name or browse with the ID sale_order = self.env[‘sale.order’].search([(‘name’, ‘=’, ‘SO009’)]) Now, you can see the sale order line IDs using the following: sale_order.order_line As this is a One2many relation, … Continue reading “How to Add Custom Sale Order Line in Odoo 12”<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[292,293],"tags":[],"_links":{"self":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/459"}],"collection":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/comments?post=459"}],"version-history":[{"count":1,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions"}],"predecessor-version":[{"id":460,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/posts\/459\/revisions\/460"}],"wp:attachment":[{"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/media?parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/categories?post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mellowhost.com\/blog\/wp-json\/wp\/v2\/tags?post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}sale_order = self.env['sale.order'].search([('name', '=', 'SO009')])<\/code><\/p>\n\n\n\nsale_order.order_line<\/code><\/p>\n\n\n\nsale_order_new.write({ <\/code>
'order_line': [<\/code>
(0,0, {<\/code>
'order_id': sale_order.id, <\/code>
'product_id': 2003, <\/code>
'price_unit': 3000.0, <\/code>
'product_uom_qty': 2.0, <\/code>
'name': ''<\/code>
})<\/code>
] <\/code>
})<\/code><\/p>\n\n\n\n# define dictionary to add order_line
order_line_dict = { 'order_id' : 9, 'product_id': 2003, 'price_unit': 3000.0, 'product_uom_qty': 2.0, 'name': '' }
# search the order line for the sale order
sale_order_line = self.env['sale.order.line'].browse(9)
# create a new order line
sale_order_line.create(order_line_dict)
# print sale order lines
sale_order_line<\/code><\/p>\n\n\n\nself.env.cr.commit()<\/code><\/p>\n\n\n\n