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

Hi, 

My company needs to be able to pull a report of all raw materials (BoM components) that are currently in process in a Manufacturing Order. I would like to export a list of Manufacturing Orders with available/reserved components and show the value of all the components to be consumed according to the manufacture quantity and BoM. 

Can someone direct me to the correct fields to use? I am not finding anything from a MO export that links to the cost of the components. For example: Bill of Materials/Component/Cost or a similar description. I hope my explanation is clear. 

아바타
취소
베스트 답변

Try this. Should give you what you are looking for:

Inventory->Reports->Stockmoves.  Filter = ToDO and Reference contains MO. 

아바타
취소
작성자

Hi Lars,
That could work for our purpose. Is there a way to export stock moves and include the inventory value of each line? Currently, I can only see the quantity in the stock move.

There is a unit price field at in the model. With the Studio app, it is easy to add in tje list view. But I cannot see a field with total value. You can add that field with an easy development.

To export, you must set in the user profile that export is allowed. Then there is a little arrow up in the left corner in every list view for export to Excel.

If your need is to know the value of work in progress, you might have another option: Set up a location in the warehouse for manufacturing consumption and picking to that location. An inventory report can give you the value directly. A few steps to configure it, but a standard function in Odoo.

The down side of that, is that you get a transfer to process for every manufacturing order, that you don't need. It might be possible to to process it automatic, but I think that would require development of an action.

관련 게시물 답글 화면 활동
3
10월 23
3260
1
5월 23
3977
1
5월 23
2329
2
12월 20
3520
3
7월 20
3844