Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
qwebreportingqweb-reportOdoo12.0
5 Odpovědi
4216 Zobrazení
Avatar
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


Avatar
Zrušit
Avatar
Ermin Trevisan
Nejlepší odpověď

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/

Avatar
Zrušit
Paulo Matos
Autor

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)...

<t t-if="o._table=='account_invoice'">

<div class="not-first-page">

<span t-esc="o.number"/>

</div>

</t>

<t t-if="o._table=='sale_order'">

<div class="not-first-page">

<span t-esc="o.name"/>

</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

Avatar
Oscar Alca
Nejlepší odpověď

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

Avatar
Zrušit
Paulo Matos
Autor

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...

Avatar
Paulo Matos
Autor Nejlepší odpověď

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

PM

 

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
How can I display all tasks (including completed ones) in a QWeb report in Odoo?
qweb reporting
Avatar
Avatar
2
zář 24
3058
[SOLVED]How to remove currency symbol from Monetary field qweb report ?
qweb qweb-report
Avatar
Avatar
Avatar
Avatar
7
říj 25
29526
How do i create report in Qweb? Vyřešeno
qweb reporting
Avatar
Avatar
Avatar
Avatar
Avatar
5
srp 19
47549
Use dot as thousands separator for integer value in Qweb reports Vyřešeno
qweb-report Odoo12.0
Avatar
Avatar
2
kvě 19
7088
How to force re-install custom report template on Odoo 12? Vyřešeno
reporting Odoo12.0
Avatar
1
bře 19
4274