FW: BOM help

Manasa,

I finally found the code I posted a few years ago to list an indented
BOM. Message 10747. I've wanted to recover that code...

Hope it helps,
Lonnie

--- In vantage@yahoogroups.com, "Manasa Reddy" <mreddy@c...> wrote:
> 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@c...
> Phone: (850) 682-2746 x272
>
>
> -----Original Message-----
> From: Frank Zeigafuse [mailto:fzeigafuse@l...]
> 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@L...
>
>
>
> -----Original Message-----
> From: Manasa Reddy [mailto:mreddy@c...]
> 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@c...
> 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/.
> (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 Sponsor
>
> ADVERTISEMENT
>
>
>
<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
> lix.com/Default?mqso=60183350> click here
>
>
> <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/
>
>
> * 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/> .
>
>
>
> <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@L... 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/.
> (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 Sponsor
> ADVERTISEMENT
>
>
>
>
>
> --------------------------------------------------------------------
--------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> 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]
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/.
(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 Sponsor

ADVERTISEMENT


<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
lix.com/Default?mqso=60183350> click here


<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/


* 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/> .



<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/.
(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 Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
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]