BOM help

Yahoo Archive
1
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
>


/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
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]
2
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]
3
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]
4
What's the real reason for the snapshot?
Make a training copy of the data base each day for use with part
tracker.

What version are you on?
Items 1,2,3,4 are standard lookups in Part Tracker.

You have revision tracking, change maintenance, memos tracking changes
should be no problem.

Seems like you trying to recreate something you all ready have, Part
Tracker.


Patrick Winter


-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 3: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]



------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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
5
Can't you get most of the way there by using Mtl Status button in Job
Tracker?

Gail M. Grillo
Manager, Corporate Administration
Allegheny Bradford Corporation (814) 362-2593 x228

-----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=gr
oups/S=1705007183:HM/EXP=1086986362/A=2164330/R=0/SIG=11eamf8g4/*http://
www.netflix.com/Default?mqso=60183350> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/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/> .




[Non-text portions of this message have been removed]
6
Manasa,

This is an over simplistic answer and forgive me if I interpret your intent
wrong But why can't they use job or order tracker for this.

I do this all the time with customers on the phone. I can see what parts
are issued, I can check inventory and all purchase advisor to check the
status of all purchased and manufactured items.

This works for customer supplied material too. We treat our customers in
this case as a vendor and cut them a PO to track delivery status.

Wayne

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 3: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 Links








[Non-text portions of this message have been removed]
7
Manasa,

I remember about 2 - 3 years ago I wrote and posted a small recursive
Progress procedure that listed, and indented accordingly, a part's
BOM. I tried to find it on my PC but no luck. I believe I posted it
for Thad Jacobs. It took a bit of experimentation for me to get it
to work, so I haven't tried to duplicate. If you find it in the
archives, send me a copy.

Lonnie



--- In vantage@yahoogroups.com, "Manasa Reddy" <mreddy@c...> wrote:
> 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]
8
Manasa,

I have a report on Crystal that does part of the job you are looking for.
We also have enormous BOMS. We mostly use it for expediting PO's but during
a rush job occasionally shop supervisors will ask for a copy. It lists
materials not issued to the job, the PO#, the PO Due date and the Required
date on the job. At this point it doesn't include material that isn't
ordered or material that is on hand, but not issued yet. If you have
Crystal you should be able to modify it (it's not as simple as it sounds,
I've tried and I think the best way is to have a sub report). It shouldn't
be too difficult to add the lead times (if you have them loaded into
Vantage).

Liz
G&Z

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 10, 2004 2: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]
9
At the moment, we have .net, crystal, report builder, asp, xml....we are
thinking about getting CorVu

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]
10
An "all encompassing snapshot." That's a new one for the books.

Seriously, have you looked into using the Job Pick List report? You should be able to modify it to pull in all the fields you need plus add exception messages (like "too late to order, you're doomed"). You can choose which of the 100s of subassemblies in a job to print.

HTH,
Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Friday, 11 June 2004 7:46 AM
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/.
(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]



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=129mo23ab/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1086992610/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164330/rand=206514793>


_____

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




[Non-text portions of this message have been removed]
11
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/.
(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]



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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
12
Manasa,

I am in a similar project and recognized that I needed to compress the BOM
into one column to easily bring more information into it. First, I took the
partmtl table and merged all the assemblies into one column. Then, brought
the partopr table and added the operations that had/not had material related
to it. Now, you have a BOM with all your materials in one column and then
you can bring partwhse, or whatever table to get inventory, purchasing
requirements, etc.

Access takes about 3 minutes to import tables and do all the queries to
convert to the one column BOM. Just make sure you include your next assembly
and part number (i.e. Company, FGPart, Revision, Desc, Next ASM, Next Part,
ASM, Mtl Seq, Mtl Part, MtlPartRev, QtyPer, Rel Opr, WorkCtr, etc.) to tight
everything together. It took me like a week to play around and see how for
example revisions in Access are a bit difficult to do (especially when the
revision num is null or why the revision has a space in the partrev and
partmtl and not space in the partopr).

Good luck!

Mario Aguirre
Lakin General

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


ADVERTISEMENT

<http://rd.yahoo.com/SIG=129mo23ab/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086992610/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=206514793>

_____

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]
13
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/.
(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]




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






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]