Odoo Help


How to get client order ref on delivery orders?

Andreas Marpmann
on 2/12/15, 8:45 AM 957 views

I only find modules or answers for v6 and v8.
Can someone help me on v7?


class stock_picking_out(orm.Model):
    _inherit = 'stock.picking.out'  
    def _get_sale_client_order_ref(self, cr, uid, ids, field_name, arg, context={}):
        res = {}
        for session in self.browse(cr,uid,ids,context=context):
            if (session.sale_id):
                res[session.id] = session.sale_id.client_order_ref or False
        return res
    _columns = {
        "client_order_reference": fields.function(_get_sale_client_order_ref, type='char', size=64,
                                                 method=True, string="Sales Order Customer Reference"


Instead of using a function field, you could try with related field

class stock_picking_out(orm.Model):
    _inherit = 'stock.picking.out'  
    _columns = {
        "client_order_reference": fields.related('sale_id', 'client_order_ref', type='char', size=64,
                   string="Sales Order Customer Reference"

NOTE:  If you try to store a related field at stock.picking.out by adding parameter store=True, then you need to define this column at stock.picking also.(This is a special case only applicable for stock.picking, stock.picking.out and stock.picking.in)

Thanks for your note to the code has helped.

Metrolux Gmbh, Andreas Marpmann
on 2/12/15, 10:23 AM

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 2/12/15, 8:45 AM
Seen: 957 times
Last updated: 3/16/15, 8:10 AM