I have a question how to set up my inventory.
I produce and sell chocolates, so I have Inventory of the single ingredients, Inventory of the produced chocolates and Inventory of packed chocolates.
When I produce 1 mould of chocolates (40 pieces) I would need that the amount of different ingredients that is used to produce 1 mould is reduced from the inventory of single ingredients, and added to the inventory of produced chocolates.
Lets say I have 1kg of sugar and 500g of cocoa beans (inventory of ingredients) & now I produce 1 mould (40 chocolates) and I need 50g of sugar and 10g of cocoa beans.
in the “production table” I would select the kind of choclate I produce and the amount (1 mould) - is there any way that then the inventory of the ingredients is reduced by the exact amounts that I needed?
Hope I could explain it properly!
Thank you very much for your help!