Thank you, Sean.

Dates are just examples. Of course nobody needs to know if I can produce something in the past.

The BOM you see is already exploded, these are the quantity needed to make a certain product in a certain quantity.

My process could be flawed, of course, but in this case what would you do?

Let's suppose that I need to make a dish of spaghetti.

I will need:

itemid 1: water qty: 10

itemid 2: spaghetti qty: 10

itemid 3: salt qty: 5

quantities will vary in function of the number of dishes I need to cook.

My question is: if today is february the 1st, when will I be able to cook 4 dishes of spaghetti, considering that my ingredients moves as depicted in the movement table?