Odoo Help


Merge multiple Sales Orders into one print

Dave Ellison
on 7/21/14, 9:57 AM 1,711 views


We have three sales orders per customer, due to the type of orders. But we want to summerise these orders on one print (using OpenOffice reports ) with one signature field on the last page. Is there any way to merge the header information (company information etc) once, three lines blocks for each order, plus their respective totals. Then with the footer information including a signature block?

Example below, thanks.

For example:

Customer Info                    Date           

Line 1 of sales order 30

Line 2 of sales order 30

A blank line with a title then:

Line 1 of sales order 31

Line 2 of sales order 31

Then blank line with a title then:

Line 1 of sales order 32

Line 2 of sales order 32

Then a footer:






Michael St-Georges
On 7/21/14, 6:25 PM


There might be a way to achieve this by editing the RML reports. I don't know if the OpenOffice editor will let you do that much editions.

You could remodel the whole report, putting column headers outside of the foreach and remodeling the current sales order title to be smaller and inline with the items.

I don't know if the OpenERP RML engine supports it but RML should also support the summation of all your items using a few tricks. If it doesn't you could always override the report function to pass a grand total to the RML report which should be an easy edit.

You could then use the multiple printing functions of the Sales Order view (Select multiple sales order then print).

Keep in mind that these kind of changes would be global and would affect all sales order printouts. If you need it separate, you would have to create new report functions and everything that goes with it.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/21/14, 9:57 AM
Seen: 1711 times
Last updated: 3/16/15, 8:10 AM