I understand that Ashley likely already resolved the issue, so this answer is aimed more at Yannick, as I assume you are not satisfied with the original answer.
It appears that 1,125 cans per batch are produced. I can think of 2 ways to set it up (I'd choose option 2).
Alternative 1: You can try to emulate "batching" by setting up a new "unit" (Inventory > UOM) naming it something like "Batch of 1125" and making "Batch of 1125" equal to x1125 of the based "Unit".
Set all the raw materials as individual items that are tracked (units of measure) in grams or kilograms. These would be purchased (or manufactured through sub-operations)
Make your final product - "Can of powdered product", units of measure for it would be "Unit"
For the "Can of powdered product" - setup a BOM, make it a manufactured item, and in the "Quantity" field set it as 1 "Batch of 1125". Then, select the quantities for all components that are needed in producing the 450 kg batch.
This would let you keep conversions on the scale of the full batch. But it would still count individual cans as the produced units, so I think your users would need to always remember the quantity per batch.
Alternative 2: you can set up the production as 2 separate manufacturing operations (assembly and subassembly):
Set all the raw materials as individual items that are tracked (units of measure) in grams or kilograms. These would be purchased (or manufactured through sub-operations
Make an intermediary product - "Batch of powdered product", units of measure for it would be "Unit"
Make a BOM for it - 1 "batch" consists of the proper mix of the 10 ingredients so it adds up to 450 kg (or however your recipe requires, if standard "loss" is included or if some material evaporates or otherwise changes mass).
This will allow you to have a step where you create 1 "batch" and would make it easier to keep the counts straight - just make them 1 unit at a time (though the system can still auto-generate a manufacturing order with something like 0.345 for you, it would be easy to catch it and just adjust it to 1)
Make your final product - "Can of powdered product", units of measure for it would be "Unit"
Make a BOM for it - 1,125 cans consists of 1 "Batch of powdered product" (and the cans themselves)
This will produce the "final" goods
In this setup, you'd have an extra step, but you'd be able to count "batches" (just under 89 batches to process 100,000 cans) and would also count the "cans". It may work depending on what your actual production process is.
To fulfill an order for 100,000 cans, you can simply run 89 batches and make 100,125 cans, 125 of which would stay in stock (though not as easy if using "make to order" route). Or you can process 88 full batches, and the 0.889 fraction for the last batch. The system should let you produce fractions of a batch and use up fractions of "component" products.
In setting up, you can consider using real or periodic inventory counts. If you do monitor inventory, perhaps "real" inventory with FIFO makes sense. Depending on your accounting reporting/monitoring needs, you have multiple options for internal Product Categories and stock account overrides on the products themselves. Make to order vs reorder rules or manual production management are also the options on the table.
You can also go with Work Orders (using routings) to setup multiple work centers. Depending on the real setup, it may or may not be a better choice.
I hope this helps.
Andrey @ Steersman Company
Hello Ashley,
Looks like can is your key unit of measure for the powdered product, as you say you are taking in orders in terms of number of cans. So you can try creating BoM in terms of number of cans getting produced. You would then know the amount of raw materials you would need to consume. For your question of over production Manufacturing in odoo does take care of the stock inventory well so that shouldn't be a problem.
Take an alternative view ie if you manufacture in terms of kg, try creating a manufacturing order in kgs and ensure that if the packaging in cans is a step in manufacturing you can make it as a one of the work operations. This should also be possible.
You would just need to map your manufacturing process in the Odoo documents like BoMs, work orders etc. well and make sure your units cans and kgs are set up properly.
Thanks
Vishal