I would like to add the EAN13 of the product in each line of my invoice report but can't figure out the right code in OpenOffice Report designer. Help would be appriciate. Thank's
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
2
Risposte
5628
Visualizzazioni
For report account.invoice use the following term:
[[ l.product_id and l.product_id.ean13 ]]
For account.invoice.layout of v6.0 this is more complex.
You have to:
Update file
account_invoice_layout/report/report_account_invoice_layout.pyand include a new fieldres['ean13'] = entry.product_id.ean13
Update report and add
[[ a['ean13'] ]]
I can't make it work in account.invoice.layout ? But it's fine in account.invoice. Thank you for your help.
I get this in my server logfile, but i believe it is not related to the ean term :
[2013-03-06 15:11:17,495][ravensara] WARNING:report:rml_except: " o.payment_ter$ Traceback (most recent call last): File "/opt/openerp/server/bin/report/render/rml2pdf/utils.py", line 90, in _c$ eval(n.get('rml_except'), {}, self.localcontext) File "/opt/openerp/server/bin/tools/safe_eval.py", line 284, in safe_eval return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_$ File "/opt/openerp/server/bin/tools/safe_eval.py", line 105, in test_expr code_obj = compile(expr, "", mode) File "<string>", line 1 o.payment_term and o.payment_term.name ]] : [[ (o.payment_term and o.payme$ ^ SyntaxError: invalid syntax
I have solved this warning, it wasn't related to my ean13 issue
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
0
nov 16
|
5095 | ||
|
1
mar 15
|
3741 | ||
|
0
mar 15
|
2983 | ||
|
0
set 21
|
1908 | ||
|
ean13 Validation from Product
Risolto
|
|
1
feb 16
|
4156 |
Thank you Andreas for your answer but it's not working. I am using "Invoice with layout".
Please check the logfile whether there are any errors or warnings
Which OpenERP Version do you use?
version 6.0.3
I have updated my answer