Manufacturing, Distribution, and Internet Applications

[John_Mitchell]

Anyone ever use a script or other tool to change the material per piece for all the routing steps for a given item? Here's my situation - made improvments and need to reduce the mat req pc value by 10% for a particular material item in all routing steps calling for that item. Unfortunately its a little over 11,000 routings and my fingers get tired... Any help would be appreciated...

John

[trodman · Accepted solution]

How about this?

UPDATE tmfRoutDetl_HAI SET tmfRoutDetl_HAI.MatReqPc=<New Quantity>
FROM tmfRoutDetl_HAI
JOIN timItem ON tmfRoutDetl_HAI.MatItemKey=timItem.ItemKey
WHERE timItem.ItemID='<Item ID>'

[John_Mitchell]

Like magic pixie dust...

Thanks!