콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다

Hi all. Like the title, I am wondering how I can get delivery orders from stock.picking based on the warehouse_id in Odoo 12. My code is currently like this:

delivery_orders = self.env['stock.picking'].search(['&', ('state', '=', 'assigned'), ('warehouse_id', '=', warehouse_id)]).mapped('id')

But of course it does not work because there is no warehouse_id field in stock.picking. If anyone knows the answer, please let me know and many thanks in advance.

아바타
취소
작성자

Thanks a lot

베스트 답변

Hello

warehouse id is available on the stock picking type.

so instead of use warehouse_id in stock picking use the picking_type_id.warehouse_id in your search.

like 

self.env['stock.picking'].search(['&', ('state', '=', 'assigned'), ('picking_type_id.warehouse_id', '=', warehouse_id)]).mapped('id')

Hope this will helps you.

아바타
취소
관련 게시물 답글 화면 활동
0
4월 19
2670
0
10월 23
1697
1
3월 23
2495
1
1월 25
1780
what is procurement 해결 완료
4
2월 25
18174