Adding / Reducing stock of multiple items

404 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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! :slightly_smiling_face:
Thank you very much for your help!

0 Replies 0