Skip to Content
Menu
This question has been flagged
2 Replies
9145 Zobrazenia

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
Zrušiť
Best Answer

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

Avatar
Zrušiť
Autor

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

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
Zrušiť
Autor

can i know this code put under python file?

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

Related Posts Replies Zobrazenia Aktivita
6
jan 24
58441
1
máj 16
3795
0
jan 25
1303
3
nov 24
4594
0
okt 24
1299