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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

[Odoo12] Document details on every invoice report page

qweb reporting qweb-report Odoo12.0

5 Antwoorden

4225 Weergaven

Paulo Matos

Hello everyone,

I am using Odoo 12 and have a legal requirement regardless report invoice and sale report.
I have to show the document details (document type, number, date, etc.) on every report page (not just the first one).

So, core Odoo report invoice allows me to print this information only at the first page.
In Odoo we have (first page):

     Customer Name
     Customer Address
     ...
     Country
     VAT

Below we have document details with number, date, etc.

What I need to do is to show the document details on the top of the page (starting from page 2), like:

     Customer: Customer Name
     Document Type: Invoice
     Number: INV XXX/2020
     Issue Date: 10-10-2020

I was able to add the desired values to variables in qweb, but I don't now how to check if page >1 in order to show the desired values...

Can anyone help me include this information at the top of every page other than the first one?
I have searched and could not find any solution for this.

Thank you all in advance

Best regards

PM

Ermin Trevisan

Beste antwoord

You can get the idea or you even may want to forward port this module: https://apps.odoo.com/apps/modules/10.0/report_qweb_element_page_visibility/

Paulo Matos

Auteur

Hi @Ermin Trevisan,

Thank you very much.

I have tested the module (not complicated to port the desired part to 12), but found some problems on using it:

When I use the module, I can set the desired classes on "header" area of the report, for instance (as per module sample)...

</div>

</t>

</div>

</t>

It just work as desired..., problem is that the new content is put on the top of existing content starting from second.

Please refer to the pic: https://pasteboard.co/IU0Zv7c.png

Also noticed that the new created "classes" only works for header and footer areas of the report.

Where can I find the hard code for footer and header for Core Odoo? I can only find the templates...

Thank you

Oscar Alca

You can easily achieve this by using Odoo studio and editing the report related to the invoice, take a look at this video

https://www.youtube.com/watch?v=7G541x6dh_o

hope it helps

Paulo Matos

Auteur

Thank you @Oscar,

Unfortunately it did not help. It is only an overview of Odoo Studio. I have tried already but cannot find a way to "add visibility" based on page number...

Paulo Matos

Auteur

Hello everyone,

I finally solved my issue. With help of module referred by @ \Ermin Trevisan, I was able to choose values to show on first and later pages.

Unfortunately after this, another problem arises and was related with header_spacing.

I had to "fight" with "margin_top" and "header_space" and with the help of this module ( \https://apps.odoo.com/apps/modules/10.0/report_qweb_element_page_visibility/ ) I was able to design the desired structure to show document details on every page.

For those who will have the same issue (header spacing) keep in mind that it is "always" dependable on margin_top value.

Thank you all

Best regards

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
How can I display all tasks (including completed ones) in a QWeb report in Odoo? qweb reporting	2 sep. 24	3085
[SOLVED]How to remove currency symbol from Monetary field qweb report ? qweb qweb-report	7 okt. 25	29560
How do i create report in Qweb? Opgelost qweb reporting	5 aug. 19	47593
Use dot as thousands separator for integer value in Qweb reports Opgelost qweb-report Odoo12.0	2 mei 19	7098
How to force re-install custom report template on Odoo 12? Opgelost reporting Odoo12.0	1 mrt. 19	4305

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!