Former Member

# Dependency Formula for BOM qty

Hi,

I want to set formula for certain material quantities in BOM.i.e. when my customer select Number of Spindles 1056 ceratin material e.p A=1056/2=528Pieces,B=1056/4=123Pieces.

If he select Number of Spindles 1200 then Material A =1200/2=600 Pieces,B=1200/3=300Pieces

Then how to it through dependency?

10|10000 characters needed characters exceeded

Former Member
Posted on Sep 22, 2007 at 04:24 PM

You need to create a reference characteristics to calculate the formula.

Proceed as below

Create a Characteristic called BOMQTY,

Give required fields and then goto additional data tab page

Enter table name as STPO, filed name as MENGE.

Save it.

Let us say you have a characteristic called SP for spindle selection

Now in the item A(maintain item qty as 1), in the dependency editor enter the following formula

\$self.BOMQTY = 528 if SP = 1056

Now in the item B(maintain item qty as 1), in the dependency editor enter the following formula

\$self.BOMQTY = 123 if SP = 1056

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi,

Thanks for your efforts but I have already given reward points may be i have done something wrong.please check that have you get points or not

• Former Member
Posted on Sep 22, 2007 at 06:30 AM

Hi,

what i understood is,you are using spindle as components for number of Material like A, B.... suppose u select material A means , the spindl requirement is 528 pices and for B u need 123 pices of spindle .. Am i correct..

regards

10|10000 characters needed characters exceeded
• Former Member Former Member

And Materials A AND B are different materials i.e spindle are not required to manufacture them.But there quantity depend on number of spindles selected.

• Former Member
Posted on Sep 22, 2007 at 08:55 AM

Hi Lalit,

create one charctristic( for eg BOMQTY) do not enter any value and in addnl data tab enter the table name as STPO and field name as MENGE and save this charctristc.

then in BOM write the dependency for items A & B as \$self.BOMQTY=MDATA \$self.BOMQTY/2( as required factor for multipication) if spindle='1056'

and in BOM u put qty of A as 1056 so it will give the required result.

hope this will solve ur problem

regards

ramakant