Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to manage incoming packages

By
Anto R
on 7/1/16, 4:39 AM 240 views

Hello and thanks in advance to everyone who will help me with this problem.

I'm using Odoo 8 on CentOS 7, I have installed the base modules  (CRM, Purchases, MRP, Warehouse management, etc) and this 4 modules, mantained by OCA:

stock_picking_package_preparation

stock_picking_package_preparation_line

stock_picking_package_info

stock_picking_package_preparation_add_to_wave


An example of use case that I'd like to do is this: 

1) After a purchase order I receive items into WH/Input; I can't check at this moment if the packages contains all items that I ordered, so I can only say that I receive one or more packages linked to this purchase order (PACK00001, PACK00002, etc)

2) I should move these packages from WH/Input to WH/Quality Control, where one or more employees will opent that packages and will verify if they contain all the items of the purchase order, and then transfer them to WH/Stock.

I tried to do all that on my Odoo, and the first step is working. At the second step when I try to move some packages to WH/Quality Control, I have this error message:

Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 539, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 576, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 312, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/service/model.py", line 118, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 309, in checked_call
    return self.endpoint(*a, **kw)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 805, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/http.py", line 405, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/web/controllers/main.py", line 948, in call_button
    action = self._call_kw(model, method, args, {})
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/web/controllers/main.py", line 936, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 439, in old_api
    result = new_api(recs, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 443, in new_api
    result = [method(rec, *args, **kwargs) for rec in self]
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/stock/wizard/stock_transfer_details.py", line 109, in do_detailed_transfer
    self.picking_id.do_transfer()
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 592, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/addons/stock/stock.py", line 1475, in do_transfer
    self.pool.get('stock.move').action_done(cr, uid, todo_move_ids, context=notrack_context)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo/.local/share/Odoo/addons/8.0/picking_dispatch/stock.py", line 136, in action_done
    status = super(StockMove, self).action_done(cr, uid, ids, context)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 92, in action_done
    cr, uid, operation, lot_id, context=context)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 73, in check_before_action_done
    context=context)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo/.local/share/Odoo/addons/8.0/stock_no_negative/models/stock_move.py", line 136, in check_before_done_no_negative
    context=context)[0]
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 268, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3144, in read
    result = BaseModel.read(records, fields, load=load)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3179, in read
    self._read_from_database(stored, inherited)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 3400, in _read_from_database
    forbidden = missing.exists()
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/api.py", line 266, in wrapper
    return new_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/models.py", line 4901, in exists
    self._cr.execute(query, [tuple(ids)])
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.7/site-packages/odoo-8.0.post20160413-py2.7.egg/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: SELECT id FROM "product_product" WHERE id IN (false)
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

I can't explain why this happens, If someone is interested and want to help me, I can send also some screenshot or share credentials to let them see directly.

Thanks in advance
.


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/1/16, 4:39 AM
Seen: 240 times
Last updated: 7/1/16, 4:48 AM