Odoo Help


read database value in report

on 7/26/16, 10:02 AM 256 views


when I print my invoice report, I has on each line with line.origin the value for the delivery report:

Example: "WH/OUT/00215"
It takes from account_invoice_line

Now I want to add in this report, the date of the delivery.
stock_picking.date_done with ID stock_picking.name

How can I add this database value?

As SQL is "Select date_done from stock_picking where name = 'line.origin'

Thank you

Your Answer

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

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/26/16, 10:02 AM
Seen: 256 times
Last updated: 7/26/16, 10:02 AM