Filling sale order lines from purchase order, error

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Účetnictví
Sklad
PoS
Project
MRP

All apps

All Posts Lidé Odznaky

Štítky (View all)

odoo accounting v14 pos v15

O tomto fóru

Pomoc

Filling sale order lines from purchase order, error

odoo10

5 Odpovědi

5370 Zobrazení

Antonio Arcucci

Hello, I'm using Odoo 10 in english. I'm a novice.

In purchase order page I add a dropdown with a reference to Sale Order.

In PurchaseOrder inherited model, I wrote following code:

@api.onchange('sale_order_id')    
def onchange_sale_order_lines(self):        
    model_purchase_order_line = self.env['purchase.order.line']
            
    for so_line in self.sale_order_id.order_line:            
        vals = {}            
        vals['order_id'] = self._origin.id            
        vals['product_id'] = so_line.product_id.id            
        vals['product_qty'] = so_line.product_uom_qty            
        vals['product_uom'] = so_line.product_uom.id            
        vals['price_unit'] = so_line.price_unit            
        vals['price_total'] = so_line.price_total            
        vals['price_tax'] = so_line.price_tax            
        vals['name'] = so_line.name            
        vals['date_planned'] = date.today()            
        model_purchase_order_line.create(vals)

but when sale order dropdown changes, I have the following error (Odoo administrator user set to english language):

Traceback (most recent call last):
  File "/home/odooadmin/OCB/odoo/http.py", line 642, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/odooadmin/OCB/odoo/http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "/home/odooadmin/OCB/odoo/http.py", line 334, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/odooadmin/OCB/odoo/service/model.py", line 101, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/odooadmin/OCB/odoo/http.py", line 327, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/odooadmin/OCB/odoo/http.py", line 942, in __call__
    return self.method(*args, **kw)
  File "/home/odooadmin/OCB/odoo/http.py", line 507, in response_wrap
    response = f(*args, **kw)
  File "/home/odooadmin/OCB/addons/web/controllers/main.py", line 895, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/odooadmin/OCB/addons/web/controllers/main.py", line 887, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/odooadmin/OCB/odoo/api.py", line 689, in call_kw
    return call_kw_multi(method, model, args, kwargs)
  File "/home/odooadmin/OCB/odoo/api.py", line 678, in call_kw_multi
    recs = self.with_context(context or {}).browse(ids)
  File "/home/odooadmin/OCB/odoo/models.py", line 4835, in browse
    return self._browse(ids, self.env, prefetch)
  File "/home/odooadmin/OCB/odoo/models.py", line 4822, in _browse
    prefetch[cls._name].update(ids)
TypeError: unhashable type: 'list'

unexpectedly, when I switch to italian language, I have a different error:

(translated from italian)

The operation cannot probably be concluded for the following reasons:
- elimination: other recordings refer to the registration that we want to delete
- creation / modification: a mandatory field is not filled in correctly

[object with reference: order_id - order.id]

I don't understand which is the problem, can you help me?

thanks in advance

Tony

Protagonist

Do you want to create sale order from purchase order?

GiusyG

Nejlepší odpověď

Hi, this is an example:

def create_po_orders(self):
    self.ensure_one()    
    po_obj = self.env['purchase.order']
    vendors = self.mapped('wizard_line_ids.partner_id')

    for vendor in vendors:
        # creating the order
        fiscal_position = vendor.property_account_position_id
        po_order = po_obj.create({
            'partner_id': vendor.id,
            'fiscal_position_id': fiscal_position.id,
            'date_planned': fields.Datetime.to_string(datetime.today()),
        })

        # creating order lines

        lines = self.env['sale.order'].filtered(lambda l: l.partner_id == vendor)
        line_ids = []
        for line in lines:           
            price = line.product_id.standard_price            
            taxes = line.product_id.taxes_id.filtered(
                lambda r: r.company_id == company)
            if fiscal_position and taxes:
                tax_ids = fiscal_position.map_tax(taxes).ids
            else:
                tax_ids = taxes.ids

            line_ids.append((0, 0, {
                'name': line.product_id.name,
                'product_id': line.product_id.id,
                'product_qty': line.qty_purchase,
                'price_unit': price,
                'product_uom': line.product_id.uom_po_id,
                'date_planned': fields.Datetime.to_string(datetime.today()),
                'taxes_id': [(6, 0, tax_ids)],

            }))
        po_order.update({'order_line': line_ids})

Antonio Arcucci

Autor

Thanks to @GiusyG:

my code:

@api.onchange('sale_order_id')

def onchange_sale_order_lines(self):

# import pdb; pdb.set_trace()

id_order = False

if self._origin.id:

id_order = self._origin.id

if not id_order and self.id:

id_order = self.id

vals = []

for so_line in self.sale_order_id.order_line:

vals.append((0,0, {

'order_id': id_order,

'name': so_line.name,

'product_id': so_line.product_id.id,

'product_qty': so_line.product_uom_qty,

'price_unit': so_line.price_unit,

'product_uom': so_line.product_uom.id,

'date_planned': fields.Datetime.to_string(datetime.today()),

}))

self.update({'order_line' : vals})

Protagonist

I think you can fill the field by inheriting the function

_prepare_purchase_order_line

this is the default function for creating purchase order from sale order

Antonio Arcucci

Autor

No, I want to create purchase order lines from a related sale order lines.

Antonio Arcucci

Autor

Sorry, I was wrong to write the title

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
Create schedule action For sending emails odoo10	2 čvc 25	4695
How to send messages that are not shown in chatter? odoo10	2 pro 24	7812
How to ORDER BY? [Odoo 10] Vyřešeno odoo10	2 lis 24	28604
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Vyřešeno odoo10	2 kvě 24	7535
Change state of other module odoo10	3 bře 24	6961

This question has been flagged

Enjoying the discussion? Don't just read, join in!