Skip to Content

Template Report

by

60.81

18.0 0
Live Preview
Required Apps 1152
Technical Name report_extend_bf
License OPL-1
Also available in version 18.0 17.0 14.0
You bought this module and need support ? Click here!
Technical Name report_extend_bf
License OPL-1
Also available in version v 17.0 v 14.0 v 18.0

1. Introduction

Template Report is a versatile Odoo module that allows users to design and export custom reports using LibreOffice or OpenOffice tools. It supports multiple output formats and is ideal for crafting contracts, invoices, and other document types with a professional layout.

2. Key Features

  • Create report templates using editable formats like .odt, compatible with LibreOffice or OpenOffice

  • Export data from any Odoo object to a variety of formats, including .pdf, .doc, .docx, .rtf, and .ods

  • Include example templates and design helpers for quick setup and customization

  • Support for compressing output files when exporting multiple records

  • Compatible across standard operating systems, particularly Linux distributions

3. Benefits

  • Flexible report creation: Users can leverage familiar LibreOffice/OpenOffice tools to craft templates without learning new systems

  • Multiple export options: Broad support for popular document formats increases adaptability for different use cases

  • Professional document generation: Ideal for polished presentations such as contracts, sales orders, and quotations

  • Ease of use: Includes ready-to-use examples and straightforward workflows for template setup

4. Compatibility & Technical Details

  • Compatible with Odoo (both Enterprise and Community editions) using Odoo as the base platform

  • Technical name for installation: report_extend_bf

  • Distributed under Odoo Proprietary License v1.0 (OPL-1) with usage restrictions regarding redistribution

  • Designed with modular architecture to simplify maintenance and future enhancements

Is Easy an elegant and scalable solution to design reports using LibreOffice.

Export data all objects odoo to LibreOffice output files odt, pdf, doc, docx, ods, rtf.

File in. (Template example)
File out [odt, pdf, doc, docx, ods, rtf]
File in. (Template example)
File out [odt, pdf, doc, docx, ods, rtf]
Other example file in.
File out.

Ideal for creating contracts and other documents.

Report templates can be created directly in of following format:

*.odt Using the word processor LibreOffice

Example templates in module report_extend_bf_examples .

Note: LibreOffice (Version: 4.4.6.3 or better). tested with LibreOffice write version: 4.4.6.3 or 6.0 (Optional for create templates).

Example create report

Settings/Technical/Reporting/Reporting

New extra functionality

Apply templates according to domain

You can apply a template according to the company, according to the client, according to the status of the document, according to some category, depending on the country, language, etc.
You can apply a template according to the conditions you want. Video demo
Note: the condition is applied according to the sequence, If in the first sequence it finds a match, this condition will apply

Output formats:

  • ODF Text Document [.odt]
  • Portable Document Format [.pdf]
  • Microsoft Word 97/2000/XP [.doc]
  • Microsoft Office Open XML [.docx]
  • ODF Spreadsheet [.ods]
  • Microsoft Word Text Rich [.rtf]

If report config out file pdf return file merge pdf

Return file *.pdf

If report config out file not pdf return an file compress

Return file *.zip

Now with preview of the document PDF

Template report

Preview report

http://localhost:8069/report/pdf/template_name/id

Print format fields

To print the fields with their respective format put the prefix bf_ followed by the name of the field. Show documentation technical: https://bit.ly/2SypPMB

References

  • Manual videos: https://bit.ly/3fxxHXS
  • Demo (User: demo pass: demo): https://bit.ly/3G8gAGn
  • Repository demo template: https://bit.ly/3fx7mZZ
  • Documentation py3o.template: https://bit.ly/3hXi3qi
  • Documentation: https://bit.ly/2SypPMB

Note

  • If the module is installed in a windows operating system, the output report will not convert into pdf
  • This module has been tested in Community Version
  • Run in odoo.sh

Global Values & Icons

Value Name in report Description Out (Example)
user py3o.user.* Record res.users Defined by the user
company_id py3o.company_id.* Record res.company Defined by the user
lang py3o.lang Lang user login es
time py3o.time Function time
company_vat_label py3o.company_vat_label Company vat label TIN (Default TIN)
company_vat_label_full py3o.company_vat_label_full Concatenate Vat label + vat TIN: 32412423423
company_display_address py3o.company_display_address Field company.partner_id.display_address
with format LibreOffice
YourCompany
1725 Slough Ave.
Scranton PA 18540
United States
company_name py3o.company_name Company name YourCompany
company_footer_line py3o.company_footer_line Initials line dates & separate per tab. P. +1 555 123 8069 E. [email protected] W. http://www.example.com TIN: 32412423423
company_footer_line_break py3o.company_footer_line_break Initials dates & line break P. +1 555 123 8069
E. [email protected]
W. http://www.example.com
TIN: 32412423423
company_footer_line_icon py3o.company_footer_line_icon Line dates icons & separate per tab 📞 +1 555 123 8069 ✉ [email protected] 🌐 http://www.example.com TIN: 32412423423
company_footer_line_break_icon py3o.company_footer_line_break_icon Icons dates & line break 📞 +1 555 123 8069
[email protected]
🌐 http://www.example.com
TIN: 32412423423
company_header py3o.company_header Company Tagline with format LibreOffice line break Header Company
company_footer py3o.company_footer Report Footer with format LibreOffice line break Footer Company
iphone py3o.iphone Icon phone 📞
imobile py3o.imobile Icon mobile 📱
iemail py3o.iemail Icon email
iwebsite py3o.iwebsite Icon website 🌐
imoney py3o.imoney Icon money 💰
idolar py3o.idolar Icon dolar 💵
ilabel py3o.ilabel Icon label 🏷
inote py3o.inote Icon note 🗈
iimg py3o.iimg Icon image 🖵
ilist py3o.ilist Icon list
iqty py3o.iqty Icon qty
ipushpin py3o.ipushpin Icon pushpin 📌
ioffice py3o.ioffice Icon office 🏢

Extra fields in res.partner

Field name Type field Description Out example Out example prefix bf_
(Out format report)
display_address Text Call function _display_address() China Export ChinaShanghai52 Chop Suey street 200000 China Export
ChinaShanghai52 Chop Suey street 200000
display_address_without_company Text Without company ChinaShanghai52 Chop Suey street 200000 ChinaShanghai52 Chop Suey street 200000
display_address_without_company_line Text Without company inline separate per | ChinaShanghai52 Chop Suey street 200000 ChinaShanghai52 Chop Suey street 200000
vat_label Char Vat label (Default TIN label) TIN TIN
vat_label_full Char Concatenate vat label + vat number TIN: 32412423423 =
data_line Text Line data initials P. +86 21 6484 5671 E. [email protected] W. http://www.chinaexport.com/ =
data_line_break Text Line break data initials P. +86 21 6484 5671 E. [email protected] W. http://www.chinaexport.com/ P. +86 21 6484 5671
E. [email protected]
W. http://www.chinaexport.com/
data_line_icon Text Line data icons 📞 +86 21 6484 5671 ✉ [email protected] 🌐 http://www.chinaexport.com/ =
data_line_break_icon Text Line break data icons 📞 +86 21 6484 5671 ✉ [email protected] 🌐 http://www.chinaexport.com/ 📞 +86 21 6484 5671
[email protected]
🌐 http://www.chinaexport.com/
data_line_abbr Text Line data abbreviation Tel: +86 21 6484 5671 Mail: [email protected] Web: http://www.chinaexport.com/ =
data_line_break_abbr Text Line break data abbreviation Tel: +86 21 6484 5671 Mail: [email protected] Web: http://www.chinaexport.com/ Tel: +86 21 6484 5671
Mail: [email protected]
Web: http://www.chinaexport.com/

Extra fields in res.company

Field name Type field Description Out example Out example prefix bf_
(Out format report)
display_address Text Call function _display_address() China Export ChinaShanghai52 Chop Suey street 200000 China Export
ChinaShanghai52 Chop Suey street 200000
display_address_without_company Text Without company ChinaShanghai52 Chop Suey street 200000 ChinaShanghai52 Chop Suey street 200000
display_address_without_company_line Text Without company inline separate per | ChinaShanghai52 Chop Suey street 200000 ChinaShanghai52 Chop Suey street 200000
vat_label Char Vat label (Default TIN label) TIN TIN
vat_label_full Char Concatenate vat label + vat number TIN: 32412423423 =
footer_line Text Line data initials P. +86 21 6484 5671 E. [email protected] W. http://www.chinaexport.com/ =
footer_line_break Text Line break data initials P. +86 21 6484 5671 E. [email protected] W. http://www.chinaexport.com/ P. +86 21 6484 5671
E. [email protected]
W. http://www.chinaexport.com/
footer_line_icon Text Line data icons 📞 +86 21 6484 5671 ✉ [email protected] 🌐 http://www.chinaexport.com/ =
footer_line_break_icon Text Line break data icons 📞 +86 21 6484 5671 ✉ [email protected] 🌐 http://www.chinaexport.com/ 📞 +86 21 6484 5671
[email protected]
🌐 http://www.chinaexport.com/
footer_line_abbr Text Line data abbreviation Tel: +86 21 6484 5671 Mail: [email protected] Web: http://www.chinaexport.com/ =
footer_line_break_abbr Text Line break data abbreviation Tel: +86 21 6484 5671 Mail: [email protected] Web: http://www.chinaexport.com/ Tel: +86 21 6484 5671
Mail: [email protected]
Web: http://www.chinaexport.com/

Contact us for support, consultation, customization

Contact by email

  • Repository demo template
  • Documentation py3otemplate
Odoo Proprietary License v1.0
This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.