Skip to Content
0
Former Member
Oct 30, 2012 at 06:04 PM

Material Quantity Calculation

1158 Views

I have a material " X" which has potency as a characteristic. I did all configuration for active ingredient and received multiple batches of this this material "X" to my stock. Each batch has different potency.

Now I need to use this material "X" for making anothe product "Y". So I defined this material in the BOM of material "Y".

Let us say that for making 100 kg of material "Y" , I need 130 kg of material "X" when the potency of material " X" is 70%. (In the material master of material "X" I defined that planned potency of material "X" is "70" %). When ever I create a order for material "Y" the quantity of component material "X" should be automatically calculated. Potency of material "X" varias from batch to batch. Hence while executing the process order system should automatically calculate the required quantity of material "X" based on potency.

What is the formula that I should use. How should I set up this formula.

Thx in advance for the help.