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.
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:
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/21/14, 9:57 AM|
|Seen: 977 times|
|Last updated: 3/16/15, 8:10 AM|