cancel
Showing results for 
Search instead for 
Did you mean: 

Variant Configuration based B.o.M Component Qty Explosion

Former Member
0 Kudos

Hi Experts,

At time of sales order creation material would be specified against length ,width & weight.So sales order unit =weight & characteristics1 =length & characteristics2=width based on these we calculate number of rolls required ie characteristics3=rolls.Now client has some standard packing styles like

Eg:

Material code=Film if Length=18000mt,width=650mm,rolls=3rolls then B.o.M component =pallet650*680--1ea here 3rolls in 1pallet is their standard packing for specified length & width.In these same manner they have n packing styles specific to length & width.

now when we create a sales order of length 18000mt,width=650mm,rolls=30 then system should explode B.o.M as pallet650*680--10ea.since we have 3 rolls in 1 pallet as per their standard packing style.

In these case i have created a reference characteristics as RM_COMP_Quantity where table as STPO & field as MENGE.

for B.o.M of Film i have maintained pallet650*680 as component & object dependies first with selection condition.Now based on selection condition B.o.M component is getting exploded but Qty as per formula not able to explode.

Please suggest how procedure need to be written specific to the formula.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Smoke,


Greetings!!!

So can we consider that for 1 Pallet 3 Rolls can be considered. Please try the following

1. In BOM assign the qty of the Palette as 999 EA

2. Provide a Procedure for the Component Palette where the RM_COMP_Quantity = characteristics3/3

So when the Component Palette is selected, it always have a Procedure which calculates the Qty as Rolls/3.

Please try and provide your feedback.

Thank you.

Regards,

Gopalakrishnan.S

Former Member
0 Kudos

Hi Gopal,

I have tried RM_COMP_Quantity = rolls/3(Characteritics3=rolls),But i am getting syntax error.Please find the attachment of screen shot.

Former Member
0 Kudos

Hi,

I have checked by keeping $Self.RM_COMP_Quantity = ROLLS/3 & found OK .But B.o.M Explosion based on specified logic as Rolls/3 Not exploding.Please help in B.o.M how these component quantity could be exploded as desired.

Header material            XXX-variant-----Base quantity-----------1kg

Component material      Pallet------------Component quantity--999Ea

Dependencies for Component:

Selection condition---packingmode='PL'

Procedure----------------$Self.RM_COMP_Quantity = ROLLS/3.

In sales order rolls =30 & Sales order Quantity=5473.44kg

Now MRP run sucessful with B.o.M explosion as per selection condition but in MD04---PALLET quantity is populated as Base quantity= 54,735EA.(Here pallet quantity should explode as Rolls/3=30=10EA as per procedure written in B.o.M) System not considering procedure at all.


Regards,

Smoke

Former Member
0 Kudos

Hello Smoke,

Please use the following Syntax in the Procedure

$Self.RM_COMP_Quantity = $Parent.ROLLS/3

Then please test it again through CU50 and confirm if the Quantity is calculated correctly?

Also please release the Procedure. As the status of the Procedure is 2 in the attachments. Kindly set it as 1 and check.

Thank you.

Regards,

Gopalakrishnan.S

Former Member
0 Kudos

Hi Smoke,


At time of sales order creation material would be specified against length ,width & weight.So sales order unit =weight & characteristics1 =length & characteristics2=width based on these we calculate number of rolls required ie characteristics3=rolls.


Here you have written that based on based on length and width, number of rolls required in getting calculated, can you share the syntax for the same?



Eg:

Material code=Film if Length=18000mt,width=650mm,rolls=3rolls then B.o.M component =pallet650*680--1ea here 3rolls in 1pallet is their standard packing for specified length & width.In these same manner they have n packing styles specific to length & width.

now when we create a sales order of length 18000mt,width=650mm,rolls=30 then system should explode B.o.M as pallet650*680--10ea.since we have 3 rolls in 1 pallet as per their standard packing style.

As per your above example, rolls should be 3 rolls, but how it has become 30 rolls with same length & width (compare with example in red fonts)?

Moreover, please share the selection condition written for quantity alteration. Kindly provide the screenshots of the following, if possible:

1. Characteristics

2. BOM

3. Above mentioned dependencies (for rolls calculation as well as selection condition for quantity alterations)

Regards

SD

Former Member
0 Kudos

Hi,

I have checked by keeping $Self.RM_COMP_Quantity = ROLLS/3 & found OK .But B.o.M Explosion based on specified logic as Rolls/3 Not exploding.Please help in B.o.M how these component quantity could be exploded as desired.

Header material            XXX-variant-----Base quantity-----------1kg

Component material      Pallet------------Component quantity--999Ea

Dependencies for Component:

Selection condition---packingmode='PL'

Procedure----------------$Self.RM_COMP_Quantity = ROLLS/3.

In sales order rolls =30 & Sales order Quantity=5473.44kg

Now MRP run sucessful with B.o.M explosion as per selection condition but in MD04---PALLET quantity is populated same as Base quantity= 54,735EA.(Here pallet quantity should explode as Rolls/3=30=10EA as per procedure written in B.o.M) System not considering procedure at all.


Regards,

Smoke