This question has been flagged
2 Replies
7371 Views
invoicecustomerreference
Avatar
kim

Hi,

I am using OpenOffice Designer to do my Invoices report. Do anyone know what is the code for the customer reference because i try to use [[ o.client_order_ref ]] but seem like not working

Avatar
Discard
Avatar
Omal Bastin
Best Answer

In invoice name field holds the customer reference. so you can use [[ o.name ]] to get the customer reference

Avatar
Discard
kim
Author

hi i use the [[ o.name ]] but not working

Avatar
jamesbale
Best Answer

You can not directly get client_order_ref, it is sale order field.

def _get_client_order_ref(self, data):

    ref = ''
    sale_obj = self.pool.get('sale.order')
    sale_ids = sale_obj.search(cr, uid, [('origin', '=', data.origin)]
    if sale_ids:
        ref = sale_obj.browse(cr, uid, sale_ids[0]).client_order_ref
    return ref

you have to do something like this

Avatar
Discard
kim
Author

can i know this code put under python file?

Andrew

I'm actually interested in something similar. I would like to display the customer reference on a task associated with the sales order. thanks!