We wrote an access program that does this. One click and its done. If you want help with it please let me know. We also update any uncompleted job operations that match on any open jobs. I wrote an application that analyzes all of the Job history for each part and compares it to the current standard then lists the part operations by % of difference. Eng then goes through and looks at each one. They make any changes to the Production/Setup standard and then when finished run a query that updates the part master and the job tables. I also added the ability to lookup job production history by sequence and discount one job that might have been an anomaly. The program then recalculates the totals based on the new dataset. Seems to work well and we run it every 6 months or so.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Friday, April 09, 2004 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Standards/BOM Update
Anyone else frustrated by this problem?
call # 984498MPS
PROBLEM DESCRIPTION:
when a standard is changed it does not update all bom's
PROBLEM RESOLUTION:
you need to manually change standards in all bom's - it will not update
automatically
Today I have 360 parts to update the standards on. On each BOM I have
to check it out, open the operations one by one, and click the standard
to unused and then click it back to the correct standard to get it to
refresh. Fortunately, I only have 2 affected operations per BOM, but
imagine the time savings if when you updated a standard, it updated the
BOMs correctly.
Aaron Hoyt
Hittite Microwave Corporation
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Friday, April 09, 2004 9:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Standards/BOM Update
Anyone else frustrated by this problem?
call # 984498MPS
PROBLEM DESCRIPTION:
when a standard is changed it does not update all bom's
PROBLEM RESOLUTION:
you need to manually change standards in all bom's - it will not update
automatically
Today I have 360 parts to update the standards on. On each BOM I have
to check it out, open the operations one by one, and click the standard
to unused and then click it back to the correct standard to get it to
refresh. Fortunately, I only have 2 affected operations per BOM, but
imagine the time savings if when you updated a standard, it updated the
BOMs correctly.
Aaron Hoyt
Hittite Microwave Corporation
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links