Skip to Content
This question has been flagged
modulesalesale.order.lineprogramaticallyv9
1 Respondre
35026 Vistes
Avatar
Peter Nietz

In our custom Odoo module we need to programmatically create new sales order lines. The purpose is to assist our sales teams to create sales orders for follow-up purchases (the customer has already purchased a software license, we want to offer him an extension/prolongation/...). We have created a wizard for this purpose, which fills in the sales order lines (automatically using various information from other models).

Our code looks roughly as follows:

@api.multi
def add_to_offer(self):
  for wizard in self:
    new_lines = []
    for what in wizard.entries:
      new_lines.append((0, 0, {
        'name' : what.product_id.name,
        'product_id' : what.product_id.id,
        'product_uom' : what.product_id.uom_id.id,
        'product_uom_qty' : 1
      }))
    wizard.sale_order_id.write({ 'order_line' : new_lines })

In principle this works at large. We don't get any error messages from Odoo (although we had to explicitly include the fields "name" and "product_uom" in order to work around errors on missing fields.

But... apparently there are still some bits missing. Compared to regular order lines our programmatically created ones are missing the unit price, taxes and subtotal price (potentially even more fields). We could try to calculate and set that stuff explicitly (just as we did with "name" and "product_uom") but that would require us to duplicate lots of code including tax and pricelist stuff. Surely not a good idea...

What is the correct way to programmatically create order lines?


Update: Based on Ahmed's tip we are now invoking the methods listed below on all freshly created order line. This seems to work fine. Many thanks for pointing out this direction, Ahmed.

product_id_change()
product_uom_change()
_compute_invoice_status()
_compute_amount()
_get_to_invoice_qty()
_get_price_reduce()
Avatar
Descartar
Avatar
Qutechs, Ahmed M.Elmubarak
Best Answer

Hello,

You can call the on_change methods in the order.line model to get the line update with calculations ...

let's try:

    @api.multi
    def add_to_offer(self):
        line_env = self.env['sale.order.line']
        for wizard in self:
            for what in wizard.entries:
                new_line = line_env.create({
                            'product_id': what.product_id.id,
                            'name': what.product_id.name,
                            'order_id': what.sale_order_id.id,
                            'product_uom' : what.product_id.uom_id.id})                
                new_line.product_id_change() #Calling an onchange method to update the record


Then you'll get the Sale order update by the new values ..

Hope this could helps

Avatar
Descartar
Răzvan Anastasescu

In my case (v14.0) everything was fine by just adding the product as a new sale order line except the discount calculation.

So the only thing which worked to trigger that was:

`new_line._onchange_discount()`

Thx for the hint!

Related Posts Respostes Vistes Activitat
Add "Add Products" to my custom module like in sale quotation Solved
module sale custom sale.order.line quotation
Avatar
Avatar
2
de jul. 17
6862
How to generate line numbers on quotes Solved
sale sale.order.line
Avatar
Avatar
1
de gen. 25
4590
How to add freight charges to product cost in sale quoatation
sale sale.order.line
Avatar
Avatar
2
d’ag. 24
6535
What's the use of Allotment Partner in sale order line? Solved
sale sale.order.line
Avatar
Avatar
Avatar
Avatar
Avatar
6
de des. 22
9944
Odoo 19 - how does rounding work on Sales Order Lines? The Total isn't the sum of the order line totals Solved
sale sale.order.line sale.order
Avatar
Avatar
1
de nov. 25
632