[7.0] Error trying to print invoice after Report Designer

Hello Marko ,

I have checked this issue with latest code but I did not face this error with trunk or 7.0 ,
and more i found o.address_invoice_id and o.address_invoice_id.street or ' ' in stable6 only. So
would you please try with latest code and give information regarding this issue.

Thanks and waiting for reply!

Jignesh,

Thanks for testing.
the code was the one from yesterday which I installed because I had
the problem with the previous version.
I fear now it has to do with custom report generated with openoffice
(report designer). Some time ago we created a custom print report and
yesterday we noticed the problem. A code upgrade didn't help.
We also uploaded the original print report (we made a backup) but the
error persists. At the moment I'm not sure if it's a problem with the
report or with the code.
Is there a way to reset the account.invoice report to original?

Thanks
Marko

On Fri, Feb 22, 2013 at 6:55 AM, Jignesh Rathod(OpenERP)
<email address hidden> wrote:
> Hello Marko ,
>
> I have checked this issue with latest code but I did not face this error with trunk or 7.0 ,
> and more i found o.address_invoice_id and o.address_invoice_id.street or ' ' in stable6 only. So
> would you please try with latest code and give information regarding this issue.
>
> Thanks and waiting for reply!
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1131451
>
> Title:
> Error when try to print invoice
>
> Status in OpenERP Server:
> New
>
> Bug description:
> I get the following when try to print an invoice:
>
> 2013-02-21 22:35:52,404 18487 ERROR ? openerp.tools.safe_eval: Cannot eval "(o.address_invoice_id and o.address_invoice_id.street) or ''"
> Traceback (most recent call last):
> File "/opt/openerp-7.0-20130221-002146/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-7.0-20130221-002146/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, 9)'"
> 2013-02-21 22:35:52,404 18487 WARNING ? openerp.osv.orm.browse_record.account.invoice: Field 'address_invoice_id' does not exist in object 'browse_record(account.invoice, 9)'
> 2013-02-21 22:35:52,405 18487 DEBUG ? openerp.osv.orm.browse_record.account.invoice: File "/opt/openerp-7.0-20130221-002146/openerp/service/web_services.py", line 700, in go
> (result, format) = obj.create(cr, uid, ids, datas, context)
> File "/opt/openerp-7.0-20130221-002146/openerp/report/report_sxw.py", line 444, in create
> fnct_ret = fnct(cr, uid, ids, data, report_xml, context)
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/1131451/+subscriptions

I solved the problem for now.
I checked the fields in settings ad there is actually no address_invoice_id
I modify the report to use partner_id instead and now works.
I don't know if address_invoice_id shuld be there or not...

On Fri, Feb 22, 2013 at 7:06 AM, Jignesh Rathod(OpenERP)
<email address hidden> wrote:
> ** Changed in: openobject-server
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1131451
>
> Title:
> Error when try to print invoice
>
> Status in OpenERP Server:
> Incomplete
>
> Bug description:
> I get the following when try to print an invoice:
>
> 2013-02-21 22:35:52,404 18487 ERROR ? openerp.tools.safe_eval: Cannot eval "(o.address_invoice_id and o.address_invoice_id.street) or ''"
> Traceback (most recent call last):
> File "/opt/openerp-7.0-20130221-002146/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-7.0-20130221-002146/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, 9)'"
> 2013-02-21 22:35:52,404 18487 WARNING ? openerp.osv.orm.browse_record.account.invoice: Field 'address_invoice_id' does not exist in object 'browse_record(account.invoice, 9)'
> 2013-02-21 22:35:52,405 18487 DEBUG ? openerp.osv.orm.browse_record.account.invoice: File "/opt/openerp-7.0-20130221-002146/openerp/service/web_services.py", line 700, in go
> (result, format) = obj.create(cr, uid, ids, datas, context)
> File "/opt/openerp-7.0-20130221-002146/openerp/report/report_sxw.py", line 444, in create
> fnct_ret = fnct(cr, uid, ids, data, report_xml, context)
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/1131451/+subscriptions

Hello Marko ,

As per your comment no #3, I am closing this issue ....

Thanks for quick reply....

I have exactly the same problem. A clean install from today, I tried to edit the invoice using the Report Designer for v7.0 and now when I try to print an invoice nothing happens. In the log is the following error:

  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/utils.py", line 92, in _child_get
    eval(n.get('rml_except'), {}, self.localcontext)
  File "/usr/lib/pymodules/python2.7/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 "/usr/lib/pymodules/python2.7/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, 4)'"

It may be worth mentioning that I only changed the label "quantity" to "QTY" and sent the report back to the server.

I now can not print invoices.

Hello Marko ,

I agree with Darren , sxw file has a field address_invoice_id which is not change and problem
occurs due to sxw. Currently in invoice_print report rml ( Replaced address_invoice_id field with partner_id )
but not in sxw .So If you change in sxw file and send to server then it replace rml.

So problem occurs due to sxw and I am confirming this issue.

Thank you!