Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

[8.0] How can I create a custom report filename for Odoo (eg. SO039_2015_04_25.pdf)?

By
Luke Branch
on 4/24/15, 6:35 AM 1,339 views

I'd like to create a custom filename for reports (eg. Quotation/Sales Order) including the document number and a timestamp, for example:

SO039_2015_04_25.pdf

I can see some functionality that achieves this in the email templates for Sales Orders here:

Settings >> Email > Templates >> [Search for Sale] >> Open and Edit [Sales Order - Send by Email]

Just go to the Advanced Settings tab and look for the field Report Filename which contains the following python expression:

${(object.name or '').replace('/','_')}_${object.state == 'draft' and 'draft' or ''}

I would like to use exactly this functionality for the regular print functions on the Sales >> Quotation >> Print >> Quotation / Order, as well as other reports using Aeroo Reports, and Jasper Reports.

Has anyone managed to figure out a way to do this in Odoo 8.0, or any other version of Odoo for that matter?

for anyone looking to do the same thing I have come across a module built by Holger Brunn that makes it easier to do this:

https://github.com/OCA/reporting-engine/tree/8.0/report_custom_filename

Using the following example I can create output for a filename for Sales Order/Quotation:
${(object.name or '').replace('/','_')}_${object.state == 'draft' and 'draft' or '' +'.xls'}

That looks like this:

SO039_.xls

I'll update this thread with more information as I figure out how to use it.

Luke Branch
on 4/28/15, 4:03 AM

this forum thread may be useful for others interested in doing this:

https://www.odoo.com/forum/help-1/question/save-as-attachment-prefix-doesnt-work-26376

Luke Branch
on 4/28/15, 4:05 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 4/24/15, 6:35 AM
Seen: 1339 times
Last updated: 8/31/15, 3:23 AM