How can obtain the report file from the invoice report cache

[luis.vargas (Luis)]

Greetings.

Is it possible to get the .odt file from the cache?

Thanks.

[nicoe (Nicolas Évrard)]

Just like you can retrieve any other report.
What is your question exactly?

[luis.vargas (Luis)]

I need to send an email when the invoice is posted with the report as an attachment. Sorry if the question is very basic.

[nicoe (Nicolas Évrard)]

@luis.vargas

I need to send an email when the invoice is posted with the report as an attachment.

Then you should use the notification email module.

There you can define the report to use to generate the email, the attachments added to the email (which would be the invoice report) and a trigger that will be used to define when to send it (state is posted).

@luis.vargas

Sorry if the question is very basic.

There is no stupid question .

[pokoli (Sergi Almacellas Abellana)]

@nicoe

There you can define the report to use to generate the email, the attachments added to the email (which would be the invoice report) and a trigger that will be used to define when to send it (state is posted ).

Just one consideration here: Take care to set a limit of 1 to the trigger, otherwise when the invoice goes back to posted state (for example when unreconciling it’s payment lines) the invoice will be resend to the customer.

[ced (Cédric Krier)]

@pokoli

Just one consideration here: Take care to set a limit of 1 to the trigger, otherwise when the invoice goes back to posted state (for example when unreconciling it’s payment lines) the invoice will be resend to the customer.

Or you can just use a trigger like: Eval('self', {}).get('state').in_(['posted', 'paid'])

[luis.vargas (Luis)]

Thanks, it helped me a lot.