Skip to Content
author's profile photo
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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    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..

    please letme know..

    regards

    pradeep

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

  • author's profile photo
    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

    Add comment
    10|10000 characters needed characters exceeded