Let me start at the beginning - perhaps there is an easier way to do this. Here is what I need.
When a customer places an order, we invoice it immediately for payment. Let say they order 24 Pink Lemonade Cordials and 24 Strawberry Cordials.
When I invoice 24 bottles Pink Lemonade and 24 bottles Strawberry, I need the system to give me a report summary of what I need to purchase in raw materials in total to manufacture these cordials ie 48 Bottles, 24 Pink Lemonade labels, 24 Strawberry labels, 48 caps, 5kg Xylitol, 30grams Stevia, 3 litres lemon juice, 300 ml strawberry flavour, etc