Skip to Content
Menu
This question has been flagged
2 Replies
1692 Views

We are a restaurant business working closely with Inventory Management and manufacture. As a restaurant we have 2 types of products:

1 - Manufacture Products (for ex: Burger, Burrito, Pizza etc)

2 - Bill of Materials (for ex: Tomato, Cheese, Onion and everything that is used for manufacture)


For now on Inventory-Report-Product Moves we are able to see the product moves for Manufacture Products, but not for BoM. Notice that lately we have had a problem with Manufacture Module and MO are not completed.


What we are looking for, is a report that shows Bill of Materials moves (for ex from inventory-to manufacture, or inventory - to customer location), where MO are not marked as done?


Thanks in advance

Avatar
Discard
Best Answer

Hi,

Let's say you have to manufacture a sandwich and for this BOM is 1tomato, 1cucumber, 2 slices of bread and 1 slice of cheese. In Odoo, you would have created all these as products and a BOM for sandwich product.

Lets consider a scenario here - you store all the raw materials (tomato, cucumber, bread and cheese) in "Raw Material" location. Now, you have to manufacture the sandwich and after manufacturing, it goes to a location called "Finished Goods" where your sandwich will be stored finally. Keeping this in mind, lets check the transactions that happen in the product moves below - 

When you create and validate manufacturing order for Sandwich, the following product moves will be recorded - 

1> There will be 4 product moves created each for tomato, cucumber, bread and cheese from "Raw Material" location to "Virtual Location/Production" indicating that these materials are consumed in the operation. You can see the MO number in the reference column of product move

2> There will be 1 product move line created for sandwich from "Virtual location/Production" to "Finished Goods" location indicating that this was manufactured post the operation.

Refer the screenshot below for a random example of product move analysis. In this screenshot, "FURN_7023" 2 qty is consumed to produce 1 qty of "FURN_8522". You have to use the grouping and filtering options as per your requirement and convenience. 

In your case, if you want to see the moves for MO's which are not completed, just remove the "Done" filter in the product moves report.

*(There is nothing like BOM moves because BOM is Master data and not transactional data. So, to get a clear picture of consumption of raw materials / production of finished goods, you have to refer the product moves report only and you have to infer the nature of transaction based on source and destination locations.)

Hope this clarifies.



Avatar
Discard
Best Answer

You could add filters to the Product Moves report .. for example you could select custom filter as "To" contains 'prod' or Operation type contains 'manufacture' and this would list all the product (component moves, which I believe is what you mean by BOM moves) with the status as Done; available etc, you could further filter using 'To Do' filter.

If you using multi-step manufacturing you could check the stock to pre-production transfers.

Inventory to customer would be a delivery operation which would be the product (not the component of BOM)

Not sure if this addresses your question.

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 15
3174
0
Dec 24
53
1
Nov 24
191
1
Jul 23
1310
2
Mar 23
1001