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?

View Entire Topic
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