Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
5649 Widoki

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

Awatar
Odrzuć
Autor

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?

Autor

version 6.0.3

I have updated my answer

Najlepsza odpowiedź

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.py and include a new field

    res['ean13'] = entry.product_id.ean13

  • Update report and add

    [[ a['ean13'] ]]

Awatar
Odrzuć
Autor

I can't make it work in account.invoice.layout ? But it's fine in account.invoice. Thank you for your help.

Autor Najlepsza odpowiedź

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

Awatar
Odrzuć
Autor

I have solved this warning, it wasn't related to my ean13 issue

Powiązane posty Odpowiedzi Widoki Czynność
0
lis 16
5110
1
mar 15
3761
0
mar 15
2985
0
wrz 21
1912
1
lut 16
4169