s_amrutkar7
6th November 2009, 17:32
Dear All,

I have a scenario where based on height & width of main item, components item net quantity is calculated.

Suppose item height & width is 2000X1000 then Bill of material items such as spring required is 3 pcs (based on formula in respect to height & width)

In PCF module help it is explained that net quantity of components is calculated by parameter substitution section.

If anybody worked on this then please let me know how to set product model for execution.


Thanks & Regards,

Sandip

EdHubbard
6th November 2009, 18:44
We have 4c4 so I'm not sure how similar LN is.....

In the generic BOM for your generic item, parameter substitution section of its constraint for item "SPRING". .

Sounds reasonably straight-forward to just have an if...then formula. But I don't know how complicated your formula is!

e.g. if width * length > 2000 then
quantity = 3
else
quantity = 2
endif

You may need to put "!" exclamation marks at the beginning of each line.

Hope I have understood your question.

Ed