Configured parts with Subassemblies

--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:

Just as a follow-up, I was able to write a Progress routine, run
from a button on the VB Form ( QuoteDtl VB Form), that will update
those part numbers ,changing the last 3 digits to comply with a
particular configured part , without losing the 'children' Ops and
Mtls.
>
> Thanks Bob.
>
> This is the idea, except I'm changing the Part Numbers
for 'Subassy's' in 'Set Rules' , resulting in loss of the Mtls and
Ops for those subassys, since at 'get Details', the Subassy has a new
Part Num.
>
> I've tried routines that go into the 'QuoteAsm' table to update
Part Numbers, no problem, but they will not run in 'Set Rules' ,
compile just fine, I believe it is a 'timing' issue in 'get details',
since the routine is trying to update a part number in a table record
that may not yet be established.
>
> I'm going to try it from a VB form, after 'get Details', open
the VB Form and run the routine that will update part Numbers for
that particular Quote LIne.
>
> Bob Booth <bbooth@...> wrote:
> We do this all the time we have parts that change -
depends on what is
> chosen in the configurator. We change the last 2 digits of the
> material part.
>
> One example of one of the rule is below
>
> JobMtl.PartNum = If JobMtl.PartNum = "SH":U THEN JobMtl.PartNum
>
> ELSE IF JobMtl.PartNum BEGINS "S20DW" THEN
>
> IF (Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,10)) +
> (SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))
>
> Else (JobMtl.PartNum)
>
> ELSE IF(Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,8))
+
> (SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))
>
> ELSE (JobMtl.PartNum)
>
> After the configuration is done - we run mrp which does the get
> method/detail and creates the unfirm job with the right details
>
> Vantage 6.1
>
> bob
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of fujijapman
> Sent: Friday, August 17, 2007 1:07 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Configured parts with Subassemblies
>
> Vantage ver 6.11:
>
> WE have a configured part( let's say "001-Safety_Chuck") that has
> subassemblies whose part number will change , based on
> inputs/conditions, thru 'set Rules'. For example, we have (6)
complete
> subassy's , let's say "001-66000-XXX" , or similar, that contain
> materials and operations.
> The "XXX" portion of the part number will be replaced by a decimal
> value at 'set rules'.
> However, we lose the 'materials and operations' of those subassy's
> ( when 'getting deatails' thru Quote or Sales Order or Jobs), I
believe
> because the sub 'parent ' part number has changed.
>
> If I take off the rule that changes the sub part number, the matl's
> and operations come in just fine.
> Is there something I'm missing , or is this just the way it works?
>
> I read a small blurb about 'configured parts with-in configured
> parts' in an Epicor 'Answerbook' but could not make that work.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> ---------------------------------
> Moody friends. Drama queens. Your life? Nope! - their life, your
story.
> Play Sims Stories at Yahoo! Games.
>
> [Non-text portions of this message have been removed]
>
Vantage ver 6.11:

WE have a configured part( let's say "001-Safety_Chuck") that has
subassemblies whose part number will change , based on
inputs/conditions, thru 'set Rules'. For example, we have (6) complete
subassy's , let's say "001-66000-XXX" , or similar, that contain
materials and operations.
The "XXX" portion of the part number will be replaced by a decimal
value at 'set rules'.
However, we lose the 'materials and operations' of those subassy's
( when 'getting deatails' thru Quote or Sales Order or Jobs), I believe
because the sub 'parent ' part number has changed.

If I take off the rule that changes the sub part number, the matl's
and operations come in just fine.
Is there something I'm missing , or is this just the way it works?

I read a small blurb about 'configured parts with-in configured
parts' in an Epicor 'Answerbook' but could not make that work.
I have always understood that if you are trying to get details of a
part that hasn't previously been defined with a method, the system
cannot get a method that does not exist. If you are altering the
part # within your configurator and then trying to get details, I
cannot see how that would work - because the next step AFTER
configuration rules are applied is to get details at which point you
have renamed your sub assy part (or any part within the
configuration) and it looks for that new part not the old part in the
methods. What I did is to define a part FTPJX - Description "Floor,
Tread, Phoenix, 3/16" x (to be configured). The configurator does
not define a new part #, instead it keeps the FTPJX as the part to
get the method from but I add the configurated specs to the
description, material comments and thus it the specifics show up on
the job traveler so the guys in the shop know what they are making.

--- In vantage@yahoogroups.com, "fujijapman" <fujijapman@...> wrote:
>
> Vantage ver 6.11:
>
> WE have a configured part( let's say "001-Safety_Chuck") that has
> subassemblies whose part number will change , based on
> inputs/conditions, thru 'set Rules'. For example, we have (6)
complete
> subassy's , let's say "001-66000-XXX" , or similar, that contain
> materials and operations.
> The "XXX" portion of the part number will be replaced by a
decimal
> value at 'set rules'.
> However, we lose the 'materials and operations' of those
subassy's
> ( when 'getting deatails' thru Quote or Sales Order or Jobs), I
believe
> because the sub 'parent ' part number has changed.
>
> If I take off the rule that changes the sub part number, the
matl's
> and operations come in just fine.
> Is there something I'm missing , or is this just the way it
works?
>
> I read a small blurb about 'configured parts with-in configured
> parts' in an Epicor 'Answerbook' but could not make that work.
>
Thanks JohnBob.

My plan is to keep the subassy part numbers the same thru 'get details' ( in order to preserve the Methods), then use a custom routine to alter the subassy part numbers in the 'Quote Assy' and 'Job Assy' tables.This should work fine for our needs, and prevent our Manufacturing/Scheduling folks from having to alter subassy part numbers.For most of our configured parts we won't be automatically creating new parts in the 'part' table, we will quote and schedule/manufacture from the 'quote assy' and 'job assy' tables.


JohnBob <jholden@...> wrote:
I have always understood that if you are trying to get details of a
part that hasn't previously been defined with a method, the system
cannot get a method that does not exist. If you are altering the
part # within your configurator and then trying to get details, I
cannot see how that would work - because the next step AFTER
configuration rules are applied is to get details at which point you
have renamed your sub assy part (or any part within the
configuration) and it looks for that new part not the old part in the
methods. What I did is to define a part FTPJX - Description "Floor,
Tread, Phoenix, 3/16" x (to be configured). The configurator does
not define a new part #, instead it keeps the FTPJX as the part to
get the method from but I add the configurated specs to the
description, material comments and thus it the specifics show up on
the job traveler so the guys in the shop know what they are making.

--- In vantage@yahoogroups.com, "fujijapman" <fujijapman@...> wrote:
>
> Vantage ver 6.11:
>
> WE have a configured part( let's say "001-Safety_Chuck") that has
> subassemblies whose part number will change , based on
> inputs/conditions, thru 'set Rules'. For example, we have (6)
complete
> subassy's , let's say "001-66000-XXX" , or similar, that contain
> materials and operations.
> The "XXX" portion of the part number will be replaced by a
decimal
> value at 'set rules'.
> However, we lose the 'materials and operations' of those
subassy's
> ( when 'getting deatails' thru Quote or Sales Order or Jobs), I
believe
> because the sub 'parent ' part number has changed.
>
> If I take off the rule that changes the sub part number, the
matl's
> and operations come in just fine.
> Is there something I'm missing , or is this just the way it
works?
>
> I read a small blurb about 'configured parts with-in configured
> parts' in an Epicor 'Answerbook' but could not make that work.
>






---------------------------------
Shape Yahoo! in your own image. Join our Network Research Panel today!

[Non-text portions of this message have been removed]
We do this all the time we have parts that change - depends on what is
chosen in the configurator. We change the last 2 digits of the
material part.



One example of one of the rule is below

JobMtl.PartNum = If JobMtl.PartNum = "SH":U THEN JobMtl.PartNum


ELSE IF JobMtl.PartNum BEGINS "S20DW" THEN


IF (Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,10)) +
(SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))


Else (JobMtl.PartNum)

ELSE IF(Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,8)) +
(SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))


ELSE (JobMtl.PartNum)



After the configuration is done - we run mrp which does the get
method/detail and creates the unfirm job with the right details



Vantage 6.1



bob







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of fujijapman
Sent: Friday, August 17, 2007 1:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Configured parts with Subassemblies



Vantage ver 6.11:

WE have a configured part( let's say "001-Safety_Chuck") that has
subassemblies whose part number will change , based on
inputs/conditions, thru 'set Rules'. For example, we have (6) complete
subassy's , let's say "001-66000-XXX" , or similar, that contain
materials and operations.
The "XXX" portion of the part number will be replaced by a decimal
value at 'set rules'.
However, we lose the 'materials and operations' of those subassy's
( when 'getting deatails' thru Quote or Sales Order or Jobs), I believe
because the sub 'parent ' part number has changed.

If I take off the rule that changes the sub part number, the matl's
and operations come in just fine.
Is there something I'm missing , or is this just the way it works?

I read a small blurb about 'configured parts with-in configured
parts' in an Epicor 'Answerbook' but could not make that work.





[Non-text portions of this message have been removed]
Thanks Bob.

This is the idea, except I'm changing the Part Numbers for 'Subassy's' in 'Set Rules' , resulting in loss of the Mtls and Ops for those subassys, since at 'get Details', the Subassy has a new Part Num.

I've tried routines that go into the 'QuoteAsm' table to update Part Numbers, no problem, but they will not run in 'Set Rules' , compile just fine, I believe it is a 'timing' issue in 'get details', since the routine is trying to update a part number in a table record that may not yet be established.

I'm going to try it from a VB form, after 'get Details', open the VB Form and run the routine that will update part Numbers for that particular Quote LIne.

Bob Booth <bbooth@...> wrote:
We do this all the time we have parts that change - depends on what is
chosen in the configurator. We change the last 2 digits of the
material part.

One example of one of the rule is below

JobMtl.PartNum = If JobMtl.PartNum = "SH":U THEN JobMtl.PartNum

ELSE IF JobMtl.PartNum BEGINS "S20DW" THEN

IF (Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,10)) +
(SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))

Else (JobMtl.PartNum)

ELSE IF(Steel <> "G40 33KSI") THEN ((SUBSTRING(JobMtl.PartNum,1,8)) +
(SUBSTRING(Steel,2,1))) + (Substring(Steel,5,1))

ELSE (JobMtl.PartNum)

After the configuration is done - we run mrp which does the get
method/detail and creates the unfirm job with the right details

Vantage 6.1

bob

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of fujijapman
Sent: Friday, August 17, 2007 1:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Configured parts with Subassemblies

Vantage ver 6.11:

WE have a configured part( let's say "001-Safety_Chuck") that has
subassemblies whose part number will change , based on
inputs/conditions, thru 'set Rules'. For example, we have (6) complete
subassy's , let's say "001-66000-XXX" , or similar, that contain
materials and operations.
The "XXX" portion of the part number will be replaced by a decimal
value at 'set rules'.
However, we lose the 'materials and operations' of those subassy's
( when 'getting deatails' thru Quote or Sales Order or Jobs), I believe
because the sub 'parent ' part number has changed.

If I take off the rule that changes the sub part number, the matl's
and operations come in just fine.
Is there something I'm missing , or is this just the way it works?

I read a small blurb about 'configured parts with-in configured
parts' in an Epicor 'Answerbook' but could not make that work.

[Non-text portions of this message have been removed]






---------------------------------
Moody friends. Drama queens. Your life? Nope! - their life, your story.
Play Sims Stories at Yahoo! Games.

[Non-text portions of this message have been removed]