I need invoice template 3 copies at one page

Using my Dolibarr
1

Dear friends,
I customized an invoice odt file to make 1 landscape page 3 copies of the same invoice. But when 1 design copy it is ok. But when i add the second copy to the same page it produces 4 invoices and generates second page. Any suggestions? file is attched

Pièces jointes :

2

Hello,
this is known issue with common doc generator from the beginning of developing Dolibarr - The problem is tha in one .ODT you should have ONLY one cycle BEGIN ROW.lines - END ROW.lines.
This is very unbelievable that for all these years development no one try to fix or solve it.
It will be very useful to have cycles as much as you want - not only for copies, but for tables with filters, reports, etc…

1 Like
3

Hello Dido,

Is there any hope i can fix my invoice problem?

4

Hi paradox78,

see my odt

template_odtopdf.odt (65.5 KB)

5

And for 3 pages

template_odtopdf_2015-07-25.odt (66.5 KB)

6

Hi Ndrosis,
Thank you for your kind reply.
I would like to have three invoices at the same page, will cut later.
These pages seem to be seperate pages.

7

This is an invoice with 3 copies.

Check who starts

[!-- BEGIN lines --]

and who ending

[!-- END lines --]

1 Like
8

i also emailed your company mail about my project. Can you add me via skype ?

9

Hi ndrosis,
Did you test your sample fot 3 pages ?
Its not working
This template generates 3x row.lines pages. If you have in the invoice 5 products it will generate 3*5=15 pages

The problem is in a ONLY one BEGIN ROW LINES operator in common doc generator.

@ paradox78,
unfortunately without development no hope :wink:
There is a workaround for Turkey tax invoice system with 1 original+3 copies which will post you later.

10

Hi Dido,

You’re absolutely right does not try it with more products.

11

Dear Dido,
Can you send me workaround for Turkish invoice 3 copies?

12

Hi,
Ok, the solution is with OpenOffice functionalities - not with Dolibarr .ODT Generator.

So, firrst you have to use one big table on a whole page and in this MAin table to have 4 major Columns:
1 column - Original
2,3,4 columns - Copies

In OpenOffice Writer tables you have functions for cells similar as in Calc/Excel -
The idea is the following - your model for ODT is put in First column - and when Dolibarr generate it - all is done there - but in 2,3,4 columns content of cells is like
B1=A1
C1=A1
D1=A1

In this case you will have all cells filled with content of your original template in a First Column - A.

You have to use Table->Formula or (F2) to assign the formula for each cells in Column B and after that with copy/paste create column C and D.

See the short sample.

Good luck

Paradox.odt (68.2 KB)

Paradox.odt (68.2 KB)