Odoo Help


This community 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.


How can i get the warehouse address on Report request_quotation.rml ?

on 3/1/13, 9:23 AM 1,760 views

I created a warehouse with a seperate address, but the partner_id is not set in stock_warehouse tabelle.

I use OpenERP Version 7. How can i output the warehouse address on request_quotation Report?

code from Version 6.1 order.dest_address_id.street or order.warehouse_id.partner_address_id.street

expected code for v7 order.warehouse_id.partner_id.street (but partner_id not set in stock_warehouse)

I have the same problem with Purchase Request for Quotation. Expected Delivery Address on the RFQ printout has the name of the warehouse but doesn't display the address of the warehouse.

The section causing the problem is noted below.

Can anyone suggest the best way to amend the report in OpenOffice so that it will display the Warehouse name and Address correctly ?

Expected Delivery address: [[ (order.dest_address_id and order.dest_address_id.name) or (order.warehouse_id and order.warehouse_id.name) or '']] [[ order.dest_address_id and display_address(order.dest_address_id) ]]

Billy Watt
on 4/5/13, 6:34 AM

We have also had this problem. We've copied the similar line from the Purchase Order's report (order.rml), but it isn't working. Is it possible the the request_quotation context is not passed the value of the warehouse_id field?

Atte Isopuro
on 5/12/16, 3:26 AM

Andreas Brueckl

--Andreas Brueckl--
| 7 8 7
Vienna, Austria
--Andreas Brueckl--
OpenERP Consulting and Development
Andreas Brueckl
On 3/1/13, 9:37 AM

If you want the address of the Sale Order's Warehouse, then you can use order.shop_id.warehouse_id.partner_id.street

The Sale Order is always related to a shop and for each shop a warehouse is assigned.

I have a same problem and we are looking for a purchase order, not a sale order.

Victor Major
on 9/3/13, 6:21 AM

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 3/1/13, 9:23 AM
Seen: 1760 times
Last updated: 5/12/16, 3:24 AM