This question has been flagged
4 Replies
8352 Views

I have problem in generating invoices in PDF with openerp v7.0. this problem is not general, some invoices are generated and others are not(Please Wait...). I have openerp installed on ubuntu server 12.04.

thanks!

Avatar
Discard

Did you customize the invoice report?

Best Answer

Your error log says that in your report you are trying to fetch note field of account.invoice.line which is not there in your database. It looks like you have done some changes in Invoice Report in your custom module. Try to remove note field or replace with other field of account.invoice.line of type character or note. Then maybe your invoice will generate properly.

Avatar
Discard
Author

I found this line : [[ format(l.note or '') or removeParentNode('tr') ]] . I removed it! Wait and See!!!!

Is it working now?

Best Answer

hi,

Did you check into attachments ?

Email : info@acespritech.com
Skype: acespritech

Avatar
Discard
Author

attachements of what ?

Best Answer

If you do not get a PDF-file, what will happen if you wait a long time? Do you get messages about loading, and a suggestion to take a coffee? If so, it looks like the DB is having issues.

Next time, can you look into the logging file? It is located at

/var/log/openerp/openerp-server.log

I had an issue with this kind of behaviour, caused by a greater than expected (by openERP) number of locations. This was fixed by a patch (which will come into the main and trunk some day).

Avatar
Discard
Author

Exactly, there are messages about loading like "take a coffee, .." "You Must press F5" if it lasts! (Sorry for the translation of message, I have french version). but without any issue. Where can I find the solution ?

Author Best Answer

Hi, Any help please ? i'm waiting for the pacth! This is an extract from the log file :

2013-05-06 15:12:24,669 1726 WARNING DB_TEST openerp.osv.orm.browse_record.account.invoice: Field 'address_invoice_id' does not exist in object 'browse_record(account.invoice, 121)' 2013-05-06 15:12:24,670 1726 ERROR DB_TEST openerp.tools.safe_eval: Cannot eval "(o.address_invoice_id and o.address_invoice_id.partner_id and o.address_invoice_id.partner_id.ref) or ' '" Traceback (most recent call last): File "/opt/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict) File "", line 1, in <module> File "/opt/openerp/server/openerp/osv/orm.py", line 486, in __getattr__ raise AttributeError(e) AttributeError: "Field 'address_invoice_id' does not exist in object 'browse_record(account.invoice, 121)'" 2013-05-06 15:12:24,704 1726 WARNING DB_TEST openerp.osv.orm.browse_record.account.invoice.line: Field 'note' does not exist in object 'browse_record(account.invoice.line, 155)' 2013-05-06 15:12:24,705 1726 ERROR DB_TEST openerp.tools.safe_eval: Cannot eval " format(l.note or '') or removeParentNode('tr') " Traceback (most recent call last): File "/opt/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict) File "", line 1, in <module> File "/opt/openerp/server/openerp/osv/orm.py", line 486, in __getattr__ raise AttributeError(e) AttributeError: "Field 'note' does not exist in object 'browse_record(account.invoice.line, 155)'" 2013-05-06 15:12:24,705 1726 WARNING DB_TEST openerp.report.render.rml2pdf.utils: rml_except: " format(l.note or '') or removeParentNode('tr') " Traceback (most recent call last): File "/opt/openerp/server/openerp/report/render/rml2pdf/utils.py", line 92, in _child_get eval(n.get('rml_except'), {}, self.localcontext) File "/opt/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict) File "", line 1, in <module> File "/opt/openerp/server/openerp/osv/orm.py", line 486, in __getattr__ raise AttributeError(e) AttributeError: "Field 'note' does not exist in object 'browse_record(account.invoice.line, 155)'"

Avatar
Discard