Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
qwebreportingqweb-reportOdoo12.0
5 Vastaukset
4123 Näkymät
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
Hylkää
Avatar
Ermin Trevisan
Paras vastaus

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
Hylkää
Paulo Matos
Tekijä

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
Paras vastaus

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
Hylkää
Paulo Matos
Tekijä

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
Tekijä Paras vastaus

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
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How can I display all tasks (including completed ones) in a QWeb report in Odoo?
qweb reporting
Avatar
Avatar
2
syysk. 24
2853
[SOLVED]How to remove currency symbol from Monetary field qweb report ?
qweb qweb-report
Avatar
Avatar
Avatar
Avatar
7
lokak. 25
29312
How do i create report in Qweb? Ratkaistu
qweb reporting
Avatar
Avatar
Avatar
Avatar
Avatar
5
elok. 19
47367
Use dot as thousands separator for integer value in Qweb reports Ratkaistu
qweb-report Odoo12.0
Avatar
Avatar
2
toukok. 19
6903
How to force re-install custom report template on Odoo 12? Ratkaistu
reporting Odoo12.0
Avatar
1
maalisk. 19
4168