Access sales order from picking report

Question

Hello together,

I want customize the Picking report (report_picking) in odoo 8 (qWeb). How I can access the sales Order from the picking report.

For Example if the VAT field of a customer must be accessed from a report we can write

*o.partner_id.vat,* when the partner_id is avaiable in the current report.

If I call *o.origin.client_order_ref *I get the following error message after call the picking.

Odoo Client Fehler

SyntaxError: JSON.parse: unexpected end of data

http://localhost:8069/w

Nicolas PIGANEAU · Answer

Origin is just a text field.

Use the sale_id field instead => o.sale_id.client_order_ref is what you want.