I assume you don't want the configurator updating the method of the existing parts and the part that ends up on the sales order would not point to the configurator but to the part and method as it exists in the part master table. Interesting concept. While having the configurator replace the part number with one that is in the part master table is trivial, the part and its method would still be linked to the configurator and the configurated part you started with.
I've never tried it, but you might be able to use the UpdateTableBuffer program. I would set up my configurator not to change the part number, in the configurator logic set your new part number to MyNewPartNumber, and then on the OnLeave tab enter:
def var OrderNum as integer.
def var OrderLine as integer.
OrderNum = GetCurrentOrderNum().
OrderLine = GetCurrentOrderLine().
If OrderNum > 0 and OrderLine > 0 then do:
Find OrderDtl where OrderDtl.Company = "MyCompany" and Orderdtl.OrderNum = OrderNum and OrderDtl.OrderLine = OrderLine no-lock no-error.
Run lib\UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE, 'PartNum', MyNewPartNumber).
End.
Â
Substitute MyCompany with your own company ID. I can't guarantee this will work, but it is what I would try. The other solution would be not to use the configurator at all and go with a customization where you could select the options and have it update the part number.
________________________________
From: Norman Hutchins <nhutchins@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 28, 2009 4:34:47 PM
Subject: [Vantage] product-configurator question?
Quick question I haven’t played with the configurator in a while and I’m
being asked to do something slightly different than what I’ve done in the
past.  Normal the configurators I’ve done before have had a master MOM
where it selects which parts to keep based on the options selected and
create a new part number.
What I need to do now is have the configurator gather the options and based
on those option select an existing part in the system and put that on the
sales order. A simple example would be:
Configurable Part:Â widget
Part       OptionA              OptionB
123a          x
123b                                  x
123ab        x                      x
So if they enter widget on the sales order, configure it, and selected both
options. The configurator would replace the widget part number with 123ab.
Could someone quickly explain the best way to do this?
Thanks in advance.
Â
Norman Hutchins
Network Administrator
Howell Laboratories, Inc.
[Non-text portions of this message have been removed]
I've never tried it, but you might be able to use the UpdateTableBuffer program. I would set up my configurator not to change the part number, in the configurator logic set your new part number to MyNewPartNumber, and then on the OnLeave tab enter:
def var OrderNum as integer.
def var OrderLine as integer.
OrderNum = GetCurrentOrderNum().
OrderLine = GetCurrentOrderLine().
If OrderNum > 0 and OrderLine > 0 then do:
Find OrderDtl where OrderDtl.Company = "MyCompany" and Orderdtl.OrderNum = OrderNum and OrderDtl.OrderLine = OrderLine no-lock no-error.
Run lib\UpdateTableBuffer.p(input BUFFER OrderDtl:HANDLE, 'PartNum', MyNewPartNumber).
End.
Â
Substitute MyCompany with your own company ID. I can't guarantee this will work, but it is what I would try. The other solution would be not to use the configurator at all and go with a customization where you could select the options and have it update the part number.
________________________________
From: Norman Hutchins <nhutchins@...>
To: vantage@yahoogroups.com
Sent: Thursday, May 28, 2009 4:34:47 PM
Subject: [Vantage] product-configurator question?
Quick question I haven’t played with the configurator in a while and I’m
being asked to do something slightly different than what I’ve done in the
past.  Normal the configurators I’ve done before have had a master MOM
where it selects which parts to keep based on the options selected and
create a new part number.
What I need to do now is have the configurator gather the options and based
on those option select an existing part in the system and put that on the
sales order. A simple example would be:
Configurable Part:Â widget
Part       OptionA              OptionB
123a          x
123b                                  x
123ab        x                      x
So if they enter widget on the sales order, configure it, and selected both
options. The configurator would replace the widget part number with 123ab.
Could someone quickly explain the best way to do this?
Thanks in advance.
Â
Norman Hutchins
Network Administrator
Howell Laboratories, Inc.
[Non-text portions of this message have been removed]