Broader question: RE: BOM and Supplier Report

Hi Len,

> When we switch from M2K to E9, we are going to make our BOM's
> multi-level so we can issue groups of part with different
> dates. I note,
> from below, that V8 has "Sequence #" - I assume E9 will also.

It does.

> In M2K, we used the "Reference designator" field in BOM (PS) file to
> store a "section" number, so when sorted BOM is in 'section" order.
>
> I think we could leave the bill flat and do ISSUES based on "Section
> (Sequence#).

In V8 we used the BubbleNum and in E9 it's called the FindNum to sort on the
groups of parts that are assembled.

> Has anyone done anything like that? Or, more broadly, if you have a
> BOM with 3,000 parts and 40 sections, how do you get 'sections' to be
> required, and to pull, on different dates?
> Note: our sections are NOT sub-assemblies that get built and
> stocked.
>
> We want desperately to avoid having 40 WO's

Have you checked out Assembly Numbers? You can have multiple work orders
with the same work order number but different assembly numbers. All of the
costs roll into one work order but you still have the visibility of each
individual assembly with its own start dates, method of manfacturing, etc.

Mark W.
I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.



Thanks,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>






M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

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



Can you be a little more specific with what you need on the report,
field wise?



I have several reports that may be what you're looking for, but I want
to send the closest ones possible,



Ron Flynn



Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

www.cubicdesigns.com

262.789.1966

262.789.1970 fax







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 8:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BOM and Supplier Report





I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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





[Non-text portions of this message have been removed]
The fields that I'm looking for would be:



Level, Type, Sequence, Part Number, Revision, Description, Qty, IUM,
Price, Supplier.



Hoping do have parameters set as a Job number and a Part number. Is this
possible?







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of IT Support
Sent: Tuesday, December 22, 2009 9:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM and Supplier Report





Travis,

Can you be a little more specific with what you need on the report,
field wise?

I have several reports that may be what you're looking for, but I want
to send the closest ones possible,

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

www.cubicdesigns.com

262.789.1966

262.789.1970 fax

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 8:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BOM and Supplier Report

I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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

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






M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

[Non-text portions of this message have been removed]
God Day Travis:

Are you running the SQL or Progress version of V8.
I know you said it was a Progress report, but Progress is still part
of the SQL version.


len.hartka@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BOM and Supplier Report




I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
We are running Progress 8.03.405A



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Len Hartka
Sent: Tuesday, December 22, 2009 9:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM and Supplier Report





God Day Travis:

Are you running the SQL or Progress version of V8.
I know you said it was a Progress report, but Progress is still part
of the SQL version.


len.hartka@... <mailto:len.hartka%40sunautomation.com>

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BOM and Supplier Report

I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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






M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

[Non-text portions of this message have been removed]
Good Day:

When we switch from M2K to E9, we are going to make our BOM's
multi-level so we can issue groups of part with different dates. I note,
from below, that V8 has "Sequence #" - I assume E9 will also.

In M2K, we used the "Reference designator" field in BOM (PS) file to
store a "section" number, so when sorted BOM is in 'section" order.

I think we could leave the bill flat and do ISSUES based on "Section
(Sequence#).

Has anyone done anything like that? Or, more broadly, if you have a
BOM with 3,000 parts and 40 sections, how do you get 'sections' to be
required, and to pull, on different dates?
Note: our sections are NOT sub-assemblies that get built and
stocked.

We want desperately to avoid having 40 WO's



len.hartka@...
Leonard C. Hartka, IT Director\ERP Manager
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...

www.Sunautomation.com <http://www.sunautomation.com/>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BOM and Supplier Report




The fields that I'm looking for would be:

Level, Type, Sequence, Part Number, Revision, Description, Qty, IUM,
Price, Supplier.

Hoping do have parameters set as a Job number and a Part number. Is this
possible?

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of IT Support
Sent: Tuesday, December 22, 2009 9:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BOM and Supplier Report

Travis,

Can you be a little more specific with what you need on the report,
field wise?

I have several reports that may be what you're looking for, but I want
to send the closest ones possible,

Ron Flynn

Cubic Designs, Inc.

CUSTOM MEZZANINE SYSTEMS

www.cubicdesigns.com

262.789.1966

262.789.1970 fax

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Tuesday, December 22, 2009 8:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BOM and Supplier Report

I'm looking to create a report that displays just like and indented BOM
Listing report. The only information that I need to add is the supplier
for the particular part. Anyone have a report similar to this one
created? I know the BOM Listing report in Vantage is progress based ,
which makes it impossible for me to modify. Looks like Crystal is the
way to go. Any help is appreciated.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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

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

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively
for
the individuals and entities to which it is addressed. This
communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are
not
authorized to read,print,retain copy or disseminate this message or any
part
of it.If you have received this message in error, please notify the
sender
immediately by email.

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






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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