Mine are 6 to 8 levels deep.
Mario Aguirre
Lakin General
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, June 11, 2004 7:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I've seen some go as far as maybe 5 levels.
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, June 11, 2004 7:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I'm beginning to see your point.
How many levels deep is your BOM?
It's like you want a time phase exception report for a job not a part
class.
Patrick Winter
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 4:46 PM
To: Vantage@Yahoogroups. Com
Subject: FW: [Vantage] BOM help
To answer the question to everyone about using job tracker or part tracker
or anything in Vantage:
You missed the part where I mentioned that the typical BOM for this
division
could have 1500 line items - or more - on it (the area where I mentioned
the
100 subassemblies with 3-5 parts or more - maybe I forgot to put the 'or
more' part).
Would you want to look up 1500 line items in Vantage?
At least this is what I hear from them when I mentioned this very thing to
them. This is the reason for the 'snapshot' report. Time phase does not
cut it for them, job tracker would not cut it for them, part tracker would
not cut it for them....trust me, I mentioned all of this to them as well.
Please help......
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, June 10, 2004 3:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I would base it on what resources you have at your company. At
Innovative
we would use Visual Basic and ODBC
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 4:36 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] BOM help
Any light anyone can shed for me on this is GREATLY appreciated!
One thing you need to keep in mind are how big our BOMs are over here.
We
can have 100 subassemblies with 3-5 different parts in each subassembly
going into a top-level finished part.
We have a division that is in desperate need of an ALL ENCOMPASSING
report.
Starting with a BOM, they would like to:
1) See if each part in the BOM is Mfg. or Purchased (I know reports
exist
for this, but read on)
2) Then click on a part, within the BOM, and see if Vantage has it
in-house
already for this BOM.
3) Then if the parts are not in-house, are they on order (if they are
to
be
purchased or customer supplied), and if so, when they are supposed to be
in
house.
4) If these parts are not on order, is there enough time to purchase
them
and get them in-house BEFORE the top-level assembly is due to be
shipped.
Once that is accomplished, can we track the changes to the BOM. Because
from the time a customer first issues a PO to us, they could literally
change the whole thing 10 times. So the changes need to be tracked.
My question is this: can this scenario be accomplished with progress
programming, or thru CorVu? Or even get into a huge spreadsheet?
I know I can write multiple excel reports for this and dump into an
access
database, etc., etc. They DO NOT want to go through 5 different
reports,
or
go through 15 different screens to get their answer.
What they want is a snapshot.
Just want to know if this can be accomplished and which tools to use.
Thanks in advance, again!
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129sjgit4/M=298184.5022502.6152625.3001176/D=groups
<http://rd.yahoo.com/SIG=129sjgit4/M=298184.5022502.6152625.3001176/D=groups
<http://www.netf>
lix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email
and any files transmitted with it are confidential to the intended
recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied
in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sent
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by
the
author to be reliable and accurate. Unless expressly stated otherwise,
this
e-mail does not form part of a legally binding contract or agreement
between
recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments (if
any).
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
--------------------------------------------------------------------------
--
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12932eucc/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1087051858/A=2164330/R=0/SIG=11eamf8g4/*http:/www.netfl
ix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164330/rand=743796252>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]
Mario Aguirre
Lakin General
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, June 11, 2004 7:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I've seen some go as far as maybe 5 levels.
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, June 11, 2004 7:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I'm beginning to see your point.
How many levels deep is your BOM?
It's like you want a time phase exception report for a job not a part
class.
Patrick Winter
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 4:46 PM
To: Vantage@Yahoogroups. Com
Subject: FW: [Vantage] BOM help
To answer the question to everyone about using job tracker or part tracker
or anything in Vantage:
You missed the part where I mentioned that the typical BOM for this
division
could have 1500 line items - or more - on it (the area where I mentioned
the
100 subassemblies with 3-5 parts or more - maybe I forgot to put the 'or
more' part).
Would you want to look up 1500 line items in Vantage?
At least this is what I hear from them when I mentioned this very thing to
them. This is the reason for the 'snapshot' report. Time phase does not
cut it for them, job tracker would not cut it for them, part tracker would
not cut it for them....trust me, I mentioned all of this to them as well.
Please help......
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, June 10, 2004 3:45 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM help
I would base it on what resources you have at your company. At
Innovative
we would use Visual Basic and ODBC
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 4:36 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] BOM help
Any light anyone can shed for me on this is GREATLY appreciated!
One thing you need to keep in mind are how big our BOMs are over here.
We
can have 100 subassemblies with 3-5 different parts in each subassembly
going into a top-level finished part.
We have a division that is in desperate need of an ALL ENCOMPASSING
report.
Starting with a BOM, they would like to:
1) See if each part in the BOM is Mfg. or Purchased (I know reports
exist
for this, but read on)
2) Then click on a part, within the BOM, and see if Vantage has it
in-house
already for this BOM.
3) Then if the parts are not in-house, are they on order (if they are
to
be
purchased or customer supplied), and if so, when they are supposed to be
in
house.
4) If these parts are not on order, is there enough time to purchase
them
and get them in-house BEFORE the top-level assembly is due to be
shipped.
Once that is accomplished, can we track the changes to the BOM. Because
from the time a customer first issues a PO to us, they could literally
change the whole thing 10 times. So the changes need to be tracked.
My question is this: can this scenario be accomplished with progress
programming, or thru CorVu? Or even get into a huge spreadsheet?
I know I can write multiple excel reports for this and dump into an
access
database, etc., etc. They DO NOT want to go through 5 different
reports,
or
go through 15 different screens to get their answer.
What they want is a snapshot.
Just want to know if this can be accomplished and which tools to use.
Thanks in advance, again!
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129sjgit4/M=298184.5022502.6152625.3001176/D=groups
<http://rd.yahoo.com/SIG=129sjgit4/M=298184.5022502.6152625.3001176/D=groups
>/S=1705007183:HM/EXP=1086986362/A=2164330/R=0/SIG=11eamf8g4/*http://www.netf
<http://www.netf>
lix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
>:HM/A=2164330/rand=457287790>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
<http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
and any files transmitted with it are confidential to the intended
recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied
in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sent
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by
the
author to be reliable and accurate. Unless expressly stated otherwise,
this
e-mail does not form part of a legally binding contract or agreement
between
recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments (if
any).
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
--------------------------------------------------------------------------
--
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12932eucc/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1087051858/A=2164330/R=0/SIG=11eamf8g4/*http:/www.netfl
ix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164330/rand=743796252>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.
[Non-text portions of this message have been removed]