Overhead Cost with Template allocation - Formula for BOM quantities in KG

[ddimitrov]

Hello,

At the moment for cost estimate calculation, we are using template allocation formula based on the Order Quantity

OrderTotalQuantity

/ AltQtyFactorFromMaterial( AlternativeQuantityUnit = 'KG',

Material = OrderMaterialNumber )

Which is working fine and return the Finish Product Total Quantity in KG.

Now there is requirement to update the formula to calculate the components total in KG.

Issues is that in the BOM only half of the components have wight in KG, rest are included as PC pieces which we don't need to be included in the calculation.

Unfortunately, so far I couldn't manage to update the formula to consider only components with main unit of measure = KG.

Formula below calculate all BOM components quantities no matter what their main unit of measure is.

TotalOfBomItems( FlexibleFunction = 'BomItemRequiredQuantity' )

/ AltQtyFactorFromMaterial( AlternativeQuantityUnit = 'KG',

Material = Material )

If you could help me how to update my formula it calculates the correct amount of component quantities?

[ddimitrov · Accepted solution]

Issue solved using together with flexible formula and flexible condition.