Dear All,
I have a scenario where a component quantity during batch determination is calculated based on the
Order Quantity / (ASSAY of component * (100 - Water Content)).
The component is maintained with Batch Characteristics / Batch Class assigned and Batch Classification maintained for the BOM item of the component.
When I do batch determination and want to deduct the increased quantity with filler quantity, I get a message as the formula is looping.
Example:
Order Quantity : 540
Batch Characteristic
ASSAY : 100 (Ideal Situation)
Water Content : 0% (Ideal Situation)
Component quantity : 540 / (100 * (100-0)) *100*100 = 540KAI or 540KG
Actual Batch Values are:
ASSAY : 96.45%
Water Content : 4.76%
Component Quantity : 540/(96.45 *(100-4.76)) *100*100 = 587.858 KG
But I get the value as: 559.876 which is (540/96.45)*100. So the water content Batch Characteristic is not considered at all during batch determination, though the formula is set as such.
Any guidance in this regard please.
Thanks
Giri