cancel
Showing results for 
Search instead for 
Did you mean: 

Dependency Formula for BOM qty

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

ok thanks i got it now

Former Member
0 Kudos

Dear Lalith,

You need to award the points to all involved if the solution is useful, all of us are putting some effort to solve your problem.

If solution here did not work and if you solved the problem then please share with us...this will be a learning for all of us.

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

hi,

u have mention that 'and in BOM u put qty of A as 1056 so it will give the required result' so i have to change qty in bom every time as it will change to 1200,1500.I want qty of A change as per my number of spindles.

Former Member
0 Kudos

hi

u have to identify some value so that u can use multipication function

or

if the spindle has less nos of values then u write the dependency for each value like

$self.BOMQTY=1200 if spindle='1056' or $self.BOMQTY=1500 if spindle='2000'

hope it will help

regards

ramakant

Former Member
0 Kudos

system giving error that 'E28021 Error: remaining part of expression cannot be interpreted'

Former Member
0 Kudos

hi

remove the OR and give comma in the place of OR

regards

ramakant

Former Member
0 Kudos

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..

please letme know..

regards

pradeep

Former Member
0 Kudos

HI,

NO,Number of spindles is my selection condition which will selected by customer and Material A and Material B quantities depend on that selection condition.

i.e Number of Spindle is my Characteristic and 1056,1200,1500 is Characteristic value.And dependind on this characteristic value Quantity of BOM materials changes i.e. Material A=523,600,750 (Number of Spindle/2) like this for all materials.

Hope you get it now.

Former Member
0 Kudos

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.