Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Schvalovania
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Estate Managament
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Účtovníctvo
  • Sklady
  • PoS
  • Projektové riadenie
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

Invoice number into the pdf file name

Odoberať

Get notified when there's activity on this post

This question has been flagged
pdfinvoicefilename
27 Replies
41884 Zobrazenia
Avatar
Christian Douville

On Print Invoice action, the .pdf file name is not, by default, completed with the invoice number. Is there any variable i can put into the Report name header that would retrieve the Invoice number ?

24
Avatar
Zrušiť
Christian Douville
Autor

Thanks. The pdf content does report the invoice number. My aim is to have the file name with the invoice number. Something like "Invoice IN-FR-1303-0008.pdf"

Ahmet Altinisik

I also need this so tired of renaming filenames for every report.

Christian Douville
Autor

Additional information, the xml for creating the report contains attachment="(object.state in ('open','paid')) and ('INVOICE_'+(object.number or '').replace('/','')+'.pdf')", so the assumption is that the number should be available into the file name

Christian Douville
Autor

Implementing/activating the Knowledge module provides the solution, as the pdf document is attached to the Account with the accurate file name (ie INVOICE + invoice number+.pdf)

Ahmet Altinisik

@Christian You have to download again the file so it is a workaround but not the solution you have to download it again after downloading the file.

Michael Karrer

The same problem for me!

I really want to have the same functionality as for "save as attachment" for all of the print buttons! Drives me nuts to always download the document twice just for the right file name...

Any idea?!?

Avatar
AJ Schrafel Paper Corp
Best Answer

You must edit the account/report/account_print_invoice.rml filename dynamically.

<document filename="Invoices.pdf">

is one of the first lines. I am not exactly sure how to do this, but I would love to know the answer.

2
Avatar
Zrušiť
Christian Douville
Autor

Not sure i have to do it, as the Settings-Technical/Actions/Reports and Settings-Technical/Actions/Action Bindings look like doing this (with the optional parameters)

AJ Schrafel Paper Corp

Yes, i agree, but that action is not applied to files created when you hit the print button, just the file that is attached to the invoice after you hit the print button. There must be a way to apply that same action to the file that is automatically downloaded when you hit print.

Avatar
Nikunj Nakum
Best Answer

yes you can give 'name': 'Invoice ' + 'today date' in return from wizard to print report.

for example: this is function is call from print button in wizard.

def print_report(self,cr, uid, ids, context=None):
        if context is None:
           context = {}
        data = self.read(cr, uid, ids)[0]
        self_browse = self.browse(cr, uid, ids)
        
        datas = {
            'ids': [data.get('id')],
            'model': 'sale.order',
            'form': data
            }
        return {
            'type': 'ir.actions.report.xml',
            'report_name': 'custom.invvoice.report',
            'datas': datas,
            'name': 'Invoice ' + self_browse[0].start_date + ' To ' + self_browse[0].end_date  
            }

 

 

 

4
Avatar
Zrušiť
Ankit H Gandhi(AHG)

Thanks @ Nikunj Nakum Your code is working

Avatar
Lara Freeke
Best Answer

I think you can use this module

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

Kind regard, 


3
Avatar
Zrušiť
Sakli

Thanks @Lara

Avatar
Jérôme Thériault
Best Answer

For Odoo 9+:

Go to configuration, reports, look for the report you want, then use the Printed Report Filename field which can contain python expressions. Two variables can be used inside: object which is the object being printed, and time which is python time module. So you can input "object.name" without the quotes.

No need for extra module or code.

More here: http://gitlab.opengest.solutions/opengest/odoo/commit/da3d2fb1dc76654e630fba27ca3dcf03002d9431

Look for print_report_name

2
Avatar
Zrušiť
Avatar
Michael Karrer
Best Answer

The same problem for me!

I really want to have the same functionality as for "save as attachment" for all of the print buttons! Drives me nuts to always download the document twice just for the right file name...

Any idea?!?

0
Avatar
Zrušiť
Prakash

Hi to all, I updated my answer to shows invoice-number-into-the-pdf-file-name

Avatar
Pascal Tremblay
Best Answer

Here is our solution to customize the sale order report PDF name with the « print » buttons.

https://www.odoo.com/forum/help-1/question/change-printed-file-name-in-webkit-report-in-odoo-59901

0
Avatar
Zrušiť
Avatar
Pravitha
Best Answer

Hello,

I too faced the same problem of printing invoice pdf with Invoice number.pdf as its name.

I modified @Nikunj Nakum  answer and I got the result. Below given is the code

  #=================================================
  # Class             :    account_invoice (inherited)
  # Method          :    custom_invoice_print button
  # Description   :    This function prints the invoice and mark it as sent, so that
  #                            we can see more easily the next step of the workflow. 

  #                            Prints Invoice with invoice number as its name
  #================================================

  def custom_invoice_print(self, cr, uid, ids, context=None):
        self.write(cr, uid, ids, {'sent': True}, context=context)
        data = self.read(cr, uid, ids)[0]
        self_browse = self.browse(cr, uid, ids)
        datas = {
             'ids': ids,
             'model': 'account.invoice',
             'form': self.read(cr, uid, ids[0], context=context)
        }
        return {
            'type': 'ir.actions.report.xml',
            'report_name': 'account.invoice2',
            'datas': datas,
            'name': 'Invoice ' + self_browse[0].number  ,
            'nodestroy' : True
        }

Result:  Invoice INV14-09_018.pdf

0
Avatar
Zrušiť
sengottuvel

Thanks.. It's woking well..

PY

Can we use this in place of the standards print buttons ? (the one in the bar and th one in the drop down menu) If yes, how ?

Pascal Tremblay

I'm not sure of the place to put it...

Pascal Tremblay

Should it works in Odoo V8 too?

Avatar
Prakash
Best Answer

In Existing Report Module after adding the below code able to generate Invoice Number in PDF File.

server\openerp\report\report_sxw.py in the create_single_pdf method.


    def create_single_pdf(self, cr, uid, ids, data, report_xml, context=None):
        if not context:
            context={}
        logo = None
        context = context.copy()
        title = report_xml.name
        rml = report_xml.report_rml_content
        model = context.get('active_model')
        record_id = context.get('active_id')    
        pool = pooler.get_pool(cr.dbname)

        invoice_obj = pool.get('account.invoice')
        type = report_xml.report_type
        if model == 'account.invoice' and record_id:
            invoice_val = invoice_obj.browse(cr, uid, record_id)     
            orderreference_type = invoice_val.reference or invoice_val.origin + report_xml.report_type
            type = orderreference_type.replace("pdf", ".pdf");        

        # if no rml file is found
        if not rml:
            return False
        rml_parser = self.parser(cr, uid, self.name2, context=context)
        objs = self.getObjects(cr, uid, ids, context)
        rml_parser.set_context(objs, data, ids, report_xml.report_type)
        processed_rml = etree.XML(rml)
        if report_xml.header:
            rml_parser._add_header(processed_rml, self.header)
        processed_rml = self.preprocess_rml(processed_rml,report_xml.report_type)
        if rml_parser.logo:
            logo = base64.decodestring(rml_parser.logo)
        create_doc = self.generators[report_xml.report_type]
        pdf = create_doc(etree.tostring(processed_rml),rml_parser.localcontext,logo,title.encode('utf8'))
        return pdf, type
        #return pdf, report_xml.report_type
      

Note: Core Report Module added extra code (Invoice Number in PDF File). But Better way to override  create_single_pdf method in a custom module.

 

0
Avatar
Zrušiť
Avatar
Renaud Dubois
Best Answer

I have also the same problem..

0
Avatar
Zrušiť
Gunther Kohn

The problem seems to be unsolved. Is there possibly an easy solution? When I send the invoice or sale order via email, everything is well. The file name have the number included. But when I only print the invoice, I have no number in the file name. Thanks for any help

Avatar
harsh jain
Best Answer

# -*- coding: utf-8 -*-

import ast
import base64
import csv
import glob
import itertools
import logging
import operator
import datetime
import hashlib
import os
import re
import simplejson
import time
import urllib
import urllib2
import urlparse
import xmlrpclib
import zlib
from xml.etree import ElementTree
from cStringIO import StringIO

import babel.messages.pofile
import werkzeug.utils
import werkzeug.wrappers
try:
    import xlwt
except ImportError:
    xlwt = None

import openerp
import openerp.modules.registry
from openerp.tools.translate import _
from openerp.tools import config


from openerp.addons.web import http
openerpweb = http
from openerp.addons.web.controllers.main import Reports

def content_disposition(filename, req):
    filename = filename.encode('utf8')
    escaped = urllib2.quote(filename)
    browser = req.httprequest.user_agent.browser
    version = int((req.httprequest.user_agent.version or '0').split('.')[0])
    if browser == 'msie' and version < 9:
        return "attachment; filename=%s" % escaped
    elif browser == 'safari':
        return "attachment; filename=%s" % filename
    else:
        return "attachment; filename*=UTF-8''%s" % escaped

 

class change_main(Reports):

    @openerpweb.httprequest
    def index1(self, req, action, token):
        
        action = simplejson.loads(action)

        report_srv = req.session.proxy("report")
        context = dict(req.context)
        
        context.update(action["context"])

        report_data = {}
        report_ids = context["active_ids"]
        if 'report_type' in action:
            report_data['report_type'] = action['report_type']
        if 'datas' in action:
            if 'ids' in action['datas']:
                report_ids = action['datas'].pop('ids')
            report_data.update(action['datas'])

        report_id = report_srv.report(
            req.session._db, req.session._uid, req.session._password,
            action["report_name"], report_ids,
            report_data, context)

        report_struct = None
        while True:
            report_struct = report_srv.report_get(
                req.session._db, req.session._uid, req.session._password, report_id)
            if report_struct["state"]:
                break

            time.sleep(self.POLLING_DELAY)

        report = base64.b64decode(report_struct['result'])
        if report_struct.get('code') == 'zlib':
            report = zlib.decompress(report)
        report_mimetype = self.TYPES_MAPPING.get(
            report_struct['format'], 'octet-stream')
        file_name = action.get('name', 'report')
        if 'name' not in action:
            reports = req.session.model('ir.actions.report.xml')
            res_id = reports.search([('report_name', '=', action['report_name']),],
                                    0, False, False, context)
            if len(res_id) > 0:
                file_name = reports.read(res_id[0], ['name'], context)['name']
            else:
                file_name = action['report_name']
        file_name = '%s.%s' % (file_name, report_struct['format'])
        
        ########################################################
        # PATCH TO PRINT PARTNER-ID AND INVOICE NO IN FILE NAME
        if context['active_model'] in ['sale.order','purchase.order','account.invoice']:
            model1 =req.session.model(context['active_model'])
            read=model1.read(context['active_id'],[],context)
            if read['name']!=False:
                file_name = read['name'] + ' ' + read['partner_id'][1]
                print file_name
                file_name = '%s.%s' % (file_name, report_struct['format'])
            # PATCH END
        #########################################################
        
        return req.make_response(report,
             headers=[
                 ('Content-Disposition', content_disposition(file_name, req)),
                 ('Content-Type', report_mimetype),
                 ('Content-Length', len(report))],
             cookies={'fileToken': token})
        
        
    Reports.index=index1

0
Avatar
Zrušiť
harsh jain

DO NOT CHANGE THE BASE CODE JUST MAKE A MODULE AND INSTALL IT

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrácia
Related Posts Replies Zobrazenia Aktivita
PDF Invoice line overflow
pdf invoice
Avatar
Avatar
Avatar
2
júl 25
1805
Quote PDF Spacing & Layout
pdf invoice
Avatar
Avatar
1
aug 25
2281
How to apply a customized invoice pdf to an email template
pdf invoice
Avatar
Avatar
1
jún 24
3559
combine several lines into 1 row in print pdf odoo 15
pdf invoice odoo15
Avatar
0
jan 25
1894
Odoo Invoice PDF download from External API
pdf invoice odoo17
Avatar
0
okt 24
3106
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now