Has anyone created a Crystal BOM listing

Below is an HTML page and ASP script that you can run on a Windows
IIS Server to display a BOM. This script assumes there is only one
active revision.

You may need to change the database name and server for your
environment. Also, if your Web server is running on a box other than
your Vantage server, you'll need to make appropriate security changes
for database connectivity.

bomdisplay.htm
--------------
<html>

<head>
<title>BOM Display</title>
</head>

<body>

<p>Enter the Part Number for which you wish to view BOM:

<form method="POST" action="bomdisplay.asp">

<p><input type="text" name="partnum" size="20"> <input
type="submit" value="Submit">

</form>

</body>
</html>


bomdisplay.asp
--------------
<%
sDatabase = "mfgsys80"

' Set up database connection
Set conn = Server.CreateObject("ADODB.Connection")
conn.CommandTimeout = 60
Conn.Open "DRIVER=SQL Server;SERVER=VANTAGE01;DATABASE=" & sDatabase
& ";Trusted_Connection=Yes"

sPartNum = UCase(Request.Form("partnum"))

sSql = "SELECT partmtl.mtlpartnum, partmtl.qtyper,
partmtl.revisionnum, part.partdescription, partwhse.onhandqty,
partwhse.jobunfirmallocqty + partwhse.jobunfirmallocqty AS demand " &_
"FROM partmtl LEFT JOIN partwhse ON partmtl.mtlpartnum =
partwhse.partnum " &_
"LEFT JOIN part ON partmtl.mtlpartnum = part.partnum " &_
"WHERE partwhse.warehousecode = 'Default' AND
partmtl.partnum = '" & sPartNum & "' " &_
"AND partmtl.revisionnum IN (SELECT revisionnum FROM
partrev WHERE partrev.approved = 1 AND partrev.partnum = '" &
sPartNum & "') " &_
"ORDER BY partmtl.mtlpartnum"

Set RS1=Conn.Execute(sSql)

%>

<HTML>
<HEAD>
<TITLE>BOM Display</TITLE>
</HEAD>

<BODY>

<% Response.write "<strong>BOM Display for Part #: </strong>" &
sPartNum %>
<% If Not RS1.EOF Then Response.Write (", Rev " & RS1.Fields
("revisionnum")) %>

<p>

<table border="1" cellpadding="2" cellspacing="1">
<tr>
<td><strong>Part Number</strong></td>
<td><strong>Description</strong></td>
<td><strong>Qty</strong></td>
<td><strong>On Hand</strong></td>
<td><strong>All Demand</strong></td>
</tr>

<%
If Not RS1.EOF Then

Do While Not RS1.EOF

Response.write " <tr>"
Response.write "<td>" & RS1.Fields("mtlpartnum") & "</td>"
& vbCrLf
Response.write "<td>" & RS1.Fields("partdescription") & "</td>"
& vbCrLf
Response.write "<td>" & RS1.Fields("qtyper") & "</td>" & vbCrLf
Response.write "<td>" & RS1.Fields("onhandqty") & "</td>" &
vbCrLf
Response.write "<td>" & RS1.Fields("demand") & "</td>" & vbCrLf
Response.write " </tr>"

RS1.Movenext

Loop

Else

Response.write "<td colspan=5>No BOM found for this part
number.</td>"

End If

RS1.Close
%>

</tr>
</table>

</BODY>
</HTML>
I have been trying to create a Crystal version of the BOM Listing
Report and not having much luck.

I have linked ECORev -> ECOMtl tables. The ECOMtl table has
MtlPartNum field that lets me see the material required for the
Parent PartNum however I am unable to find a MtlPartNum Revision
(required to lookup the methods of the material requirement).

I also looked at the Part -> PartMtl tables to see if that was any
different but it is the same.

So at this point I am only able to list the 1st level components for
a part number.

If anyone has cracked this nut, I would certainly appreciate some
advice.

Thanks in advance,
Dave Olender dolender@...
Ph 651-246-3281
Yes, I will send you this report.





Toby Boogerd
Information Systems
712-324-4854 x1119

NOTICE: This email may contain confidential and proprietary information
of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
recipient agrees not to use, reproduce, disclose, or manufacture its
contents, in whole or in part, without prior written consent of
Rosenboom Machine & Tool, Inc.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Olender
Sent: Thursday, October 05, 2006 8:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Has anyone created a Crystal BOM listing.



I have been trying to create a Crystal version of the BOM Listing
Report and not having much luck.

I have linked ECORev -> ECOMtl tables. The ECOMtl table has
MtlPartNum field that lets me see the material required for the
Parent PartNum however I am unable to find a MtlPartNum Revision
(required to lookup the methods of the material requirement).

I also looked at the Part -> PartMtl tables to see if that was any
different but it is the same.

So at this point I am only able to list the 1st level components for
a part number.

If anyone has cracked this nut, I would certainly appreciate some
advice.

Thanks in advance,
Dave Olender dolender@...
<mailto:dolender%40olenderconsulting.com>
Ph 651-246-3281





[Non-text portions of this message have been removed]
Is there anyway you can add this report to the files in this group?
If not can you post your Report Definition. I am trying to re create
this report also in Vantage 6.10.535 using Crystal Reports. Epicor
tells me that Vantage saves BOM only in single level.


--- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
> recipient agrees not to use, reproduce, disclose, or manufacture its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I would appreciate this report as well!
Â
Dan


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ace_Man
Sent: Friday, October 13, 2006 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.

Is there anyway you can add this report to the files in this group?
If not can you post your Report Definition. I am trying to re create
this report also in Vantage 6.10.535 using Crystal Reports. Epicor
tells me that Vantage saves BOM only in single level.


--- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
> recipient agrees not to use, reproduce, disclose, or manufacture its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [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
Yes, I've tried to created CR for BOM.
BOM table is temp table..
I really have thought regarding to this report..
Would you share your Idea if you have time?

Thank you,
I am in the process of trying to figure out how to move the existing
BOM lines from the one section of the Crystal Reprot to each parts
respective related op section in the canned job traveler. I have to
say I am just hackin at it.
I would also appreciate a copy of this report. There are other users
in the past that have tried and failed, so I am sure there is enough
interest to post this report in the files for the group.

Thanks

John


> --- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@> wrote:
> >
> > Yes, I will send you this report.
> >
> >
> >
> >
> >
> > Toby Boogerd
> > Information Systems
> > 712-324-4854 x1119
> >
> > NOTICE: This email may contain confidential and proprietary
> information
> > of Rosenboom Machine & Tool, Inc. By opening any enclosed files, the
> > recipient agrees not to use, reproduce, disclose, or manufacture its
> > contents, in whole or in part, without prior written consent of
> > Rosenboom Machine & Tool, Inc.
> >
I would also like a copy of this report.
Dan
Independent Components Corp.

--- In vantage@yahoogroups.com, "Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Me Too Please!

-----Original Message-----
From: dsirow [mailto:dan@...]
Sent: Monday, October 16, 2006 1:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.



I would also like a copy of this report.
Dan
Independent Components Corp.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
I would appreciate this as well please!
Thanks,
Rudy

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Monday, October 16, 2006 12:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.



Me Too Please!

-----Original Message-----
From: dsirow [mailto:dan@... <mailto:dan%40iccparts.com> ]
Sent: Monday, October 16, 2006 1:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.

I would also like a copy of this report.
Dan
Independent Components Corp.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On

Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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






[Non-text portions of this message have been removed]
I would also like a copy of this report, too.
Thank you,


--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@...> wrote:
>
> Me Too Please!
>
> -----Original Message-----
> From: dsirow [mailto:dan@...]
> Sent: Monday, October 16, 2006 1:39 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
>
>
> I would also like a copy of this report.
> Dan
> Independent Components Corp.
>
> --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com, "Toby Boogerd" <tboogerd@> wrote:
> >
> > Yes, I will send you this report.
> >
> >
> >
> >
> >
> > Toby Boogerd
> > Information Systems
> > 712-324-4854 x1119
> >
> > NOTICE: This email may contain confidential and proprietary
> information
> > of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
> the
> > recipient agrees not to use, reproduce, disclose, or manufacture
> its
> > contents, in whole or in part, without prior written consent of
> > Rosenboom Machine & Tool, Inc.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
> Behalf
> > Of Dave Olender
> > Sent: Thursday, October 05, 2006 8:06 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> >
> >
> >
> > I have been trying to create a Crystal version of the BOM Listing
> > Report and not having much luck.
> >
> > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > MtlPartNum field that lets me see the material required for the
> > Parent PartNum however I am unable to find a MtlPartNum Revision
> > (required to lookup the methods of the material requirement).
> >
> > I also looked at the Part -> PartMtl tables to see if that was
any
> > different but it is the same.
> >
> > So at this point I am only able to list the 1st level components
> for
> > a part number.
> >
> > If anyone has cracked this nut, I would certainly appreciate some
> > advice.
> >
> > Thanks in advance,
> > Dave Olender dolender@
> > <mailto:dolender%40olenderconsulting.com>
> > Ph 651-246-3281
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I was able to write stored procedure for SQL server that creates
temporary tables. Then I used this procedure for the report. I do not
know how to attach the files so I'll post it here.

You need to run this in SQL Query Analyzer for Vantage database.

*************START*****************************
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE spIndentedBOM_ITT
@part varchar(20)
AS
BEGIN

--declare @part varchar(20)
--set @part='1026'

declare @levelnum int
set @levelnum=0

create table #bomtempo1(
company varchar(8),
parent varchar(20),
revision varchar(5),
effectivedate datetime,
pullasasm smallint,
viewasasm smallint,
child varchar(20),
lvl int,
mtlseq varchar(8),
qtyper decimal(15,5),
mfgcomment varchar(1000),
nodes varchar(8000)
)



insert into #bomtempo1
select partrev.company,'', partrev.revisionnum,partrev.effectivedate,
1,1,@part,@levelnum,'00',1,'',@part
from partrev with (nolock) where partrev.partnum=@part and
partrev.effectivedate in
(SELECT MAX(partrev.effectivedate) from partrev with (nolock) where
partrev.partnum=@part)

while (exists (select * from #bomtempo1 with (nolock) where
lvl=@levelnum))
begin
insert into #bomtempo1
select
partmtl.company,partmtl.partnum,partmtl.revisionnum,partrev.effectived
ate,partmtl.pullasasm, partmtl.viewasasm,partmtl.mtlpartnum,
@levelnum+1, cast(partmtl.mtlseq as varchar(8)),
partmtl.qtyper, partmtl.mfgcomment,#bomtempo1.nodes+'-
'+partmtl.mtlpartnum
from (partmtl with (nolock) inner join partrev with (nolock) on
partmtl.partnum=partrev.partnum and
partmtl.revisionnum=partrev.revisionnum
and partmtl.company=partrev.company
and partrev.partnum + cast(partrev.effectivedate as varchar
(40)) in
(SELECT partrev.partnum+cast(MAX(partrev.effectivedate) as
varchar(40)) as latestdate
FROM partrev with (nolock)
GROUP BY partrev.partnum))inner join #bomtempo1 with (nolock)
on partmtl.partnum=#bomtempo1.child and
partmtl.company=#bomtempo1.company
where #bomtempo1.lvl=@levelnum and #bomtempo1.viewasasm=1


set @levelnum=@levelnum+1
end

create table #bomtempo2(
company varchar(8),
lvl int,
pullasasm smallint,
viewasasm smallint,
part varchar(20),
revision varchar(5),
partdescription varchar(50),
effectivedate datetime,
ium varchar(2),
typecode varchar(2),
nonstock tinyint,
prodcode varchar(4),
qtyper decimal(15,5),
FindNo varchar(15),
RefNo varchar(255),
Alt varchar(255),
Comments varchar(255),
mfgcomments varchar(1000),
nodes varchar(8000),
filename varchar(255)
)
insert into #bomtempo2
select isnull(#bomtempo1.company,'') as
company,lvl,pullasasm,viewasasm,child as part,revision,
cast(part.partdescription as varchar(50)) as
partdescription,effectivedate,part.ium,part.typecode,part.nonstock,par
t.prodcode,qtyper,
FindNo=
case
when (charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar(255))))
>0
then
case
when (charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))+5,charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))-5) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('FIND:',cast
(#bomtempo1.mfgcomment as varchar(255)))+5,charindex('REF:',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('FIND:',cast
(#bomtempo1.mfgcomment as varchar(255)))-5) as varchar(255))))-1) as
varchar(10))
else
case
when (charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))+5,charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))-5) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('FIND:',cast
(#bomtempo1.mfgcomment as varchar(255)))+5,charindex('ALT:',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('FIND:',cast
(#bomtempo1.mfgcomment as varchar(255)))-5) as varchar(255))))-1) as
varchar(10))
else
case
when (charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))+5,charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('FIND',cast(#bomtempo1.mfgcomment as varchar
(255)))-5) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('FIND:',cast
(#bomtempo1.mfgcomment as varchar(255)))+5,charindex('COMMENT',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('FIND',cast
(#bomtempo1.mfgcomment as varchar(255)))-5) as varchar(255))))-1) as
varchar(10))
else cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment
as varchar(255)),charindex('FIND:',cast(#bomtempo1.mfgcomment as
varchar(255)))+5,len(cast(#bomtempo1.mfgcomment as varchar(255)))-
charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as
varchar(255))),len(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('FIND:',cast(#bomtempo1.mfgcomment as varchar
(255)))+5,len(cast(#bomtempo1.mfgcomment as varchar(255)))-charindex
('FIND:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as varchar
(255))))-0) as varchar(10))
end
end
end
else '0'
end,
RefNo=
case
when (charindex('REF:',cast(#bomtempo1.mfgcomment as varchar(255))))
>0
then
case
when (charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255)))+4,charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255)))-4) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('REF:',cast
(#bomtempo1.mfgcomment as varchar(255)))+4,charindex('ALT:',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('REF:',cast
(#bomtempo1.mfgcomment as varchar(255)))-4) as varchar(255))))-1) as
varchar(255))
else
case
when (charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255)))+4,charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('REF',cast(#bomtempo1.mfgcomment as varchar(255)))-
4) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('REF:',cast
(#bomtempo1.mfgcomment as varchar(255)))+4,charindex('COMMENT',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('REF',cast
(#bomtempo1.mfgcomment as varchar(255)))-4) as varchar(255))))-1) as
varchar(255))
else cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment
as varchar(255)),charindex('REF:',cast(#bomtempo1.mfgcomment as
varchar(255)))+4,len(cast(#bomtempo1.mfgcomment as varchar(255)))-
charindex('REF:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as
varchar(255))),len(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('REF:',cast(#bomtempo1.mfgcomment as varchar
(255)))+4,len(cast(#bomtempo1.mfgcomment as varchar(255)))-charindex
('REF:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as varchar
(255))))-0) as varchar(255))
end
end
else ''
end,
Alt=
case
when (charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar(255))))
>0
then
case
when (charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))))>0 then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255)))+4,charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))) -charindex('ALT',cast(#bomtempo1.mfgcomment as varchar(255)))-
4) as varchar(255))),len(rtrim(cast(substring(cast
(#bomtempo1.mfgcomment as varchar(255)),charindex('ALT:',cast
(#bomtempo1.mfgcomment as varchar(255)))+4,charindex('COMMENT',cast
(#bomtempo1.mfgcomment as varchar(255))) -charindex('ALT',cast
(#bomtempo1.mfgcomment as varchar(255)))-4) as varchar(255))))-1) as
varchar(255))
else cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment
as varchar(255)),charindex('ALT:',cast(#bomtempo1.mfgcomment as
varchar(255)))+4,len(cast(#bomtempo1.mfgcomment as varchar(255)))-
charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as
varchar(255))),len(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as
varchar(255)),charindex('ALT:',cast(#bomtempo1.mfgcomment as varchar
(255)))+4,len(cast(#bomtempo1.mfgcomment as varchar(255)))-charindex
('ALT:',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as varchar
(255))))-0) as varchar(255))
end
else ''
end,
Comments=
case
when (charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255))))>0
then
cast(left(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as varchar
(255)),charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255)))+7,len(cast(#bomtempo1.mfgcomment as varchar(255)))-charindex
('COMMENT',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as varchar
(255))),len(rtrim(cast(substring(cast(#bomtempo1.mfgcomment as varchar
(255)),charindex('COMMENT',cast(#bomtempo1.mfgcomment as varchar
(255)))+7,len(cast(#bomtempo1.mfgcomment as varchar(255)))-charindex
('COMMENT',cast(#bomtempo1.mfgcomment as varchar(255)))-0) as varchar
(255))))-0) as varchar(255))
else ''
end,
cast(#bomtempo1.mfgcomment as varchar(255)) as
mfgcomments,nodes,drawings.filename
from #bomtempo1 with (nolock) inner join part with (nolock) on
#bomtempo1.child=part.partnum and #bomtempo1.company=part.company
left outer join drawings with (nolock) on
#bomtempo1.company=drawings.company and
#bomtempo1.child=drawings.key1 and #bomtempo1.revision=drawings.key2
and
drawings.relatedtofile='PartRev'
order by nodes

select * from #bomtempo2

drop table #bomtempo1
drop table #bomtempo2

END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

*************END*******************************


--- In vantage@yahoogroups.com, "Rudy Rodriguez" <rrodriguez@...>
wrote:
>
> I would appreciate this as well please!
> Thanks,
> Rudy
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Jasper Recto
> Sent: Monday, October 16, 2006 12:54 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
>
>
> Me Too Please!
>
> -----Original Message-----
> From: dsirow [mailto:dan@... <mailto:dan%40iccparts.com> ]
> Sent: Monday, October 16, 2006 1:39 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
> I would also like a copy of this report.
> Dan
> Independent Components Corp.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Toby Boogerd" <tboogerd@> wrote:
> >
> > Yes, I will send you this report.
> >
> >
> >
> >
> >
> > Toby Boogerd
> > Information Systems
> > 712-324-4854 x1119
> >
> > NOTICE: This email may contain confidential and proprietary
> information
> > of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
> the
> > recipient agrees not to use, reproduce, disclose, or manufacture
> its
> > contents, in whole or in part, without prior written consent of
> > Rosenboom Machine & Tool, Inc.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
>
> Behalf
> > Of Dave Olender
> > Sent: Thursday, October 05, 2006 8:06 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> >
> >
> >
> > I have been trying to create a Crystal version of the BOM Listing
> > Report and not having much luck.
> >
> > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > MtlPartNum field that lets me see the material required for the
> > Parent PartNum however I am unable to find a MtlPartNum Revision
> > (required to lookup the methods of the material requirement).
> >
> > I also looked at the Part -> PartMtl tables to see if that was
any
> > different but it is the same.
> >
> > So at this point I am only able to list the 1st level components
> for
> > a part number.
> >
> > If anyone has cracked this nut, I would certainly appreciate some
> > advice.
> >
> > Thanks in advance,
> > Dave Olender dolender@
> > <mailto:dolender%40olenderconsulting.com>
> > Ph 651-246-3281
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Ditto.





<http://www.coldjet.com>

Michelle de la Vega

Business Applications Manager

Cold Jet, LLC

455 Wards Corner Road

Loveland, Ohio 45140

513-716-6400

513-831-1209 FAX

Celebrating 20 Years of Dry Ice Technology and Innovation

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rudy Rodriguez
Sent: Monday, October 16, 2006 2:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.



I would appreciate this as well please!
Thanks,
Rudy

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Jasper Recto
Sent: Monday, October 16, 2006 12:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.

Me Too Please!

-----Original Message-----
From: dsirow [mailto:dan@... <mailto:dan%40iccparts.com>
<mailto:dan%40iccparts.com> ]
Sent: Monday, October 16, 2006 1:39 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.

I would also like a copy of this report.
Dan
Independent Components Corp.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Toby Boogerd" <tboogerd@...> wrote:
>
> Yes, I will send you this report.
>
>
>
>
>
> Toby Boogerd
> Information Systems
> 712-324-4854 x1119
>
> NOTICE: This email may contain confidential and proprietary
information
> of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
the
> recipient agrees not to use, reproduce, disclose, or manufacture
its
> contents, in whole or in part, without prior written consent of
> Rosenboom Machine & Tool, Inc.
>
> ________________________________
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On

Behalf
> Of Dave Olender
> Sent: Thursday, October 05, 2006 8:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Has anyone created a Crystal BOM listing.
>
>
>
> I have been trying to create a Crystal version of the BOM Listing
> Report and not having much luck.
>
> I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> MtlPartNum field that lets me see the material required for the
> Parent PartNum however I am unable to find a MtlPartNum Revision
> (required to lookup the methods of the material requirement).
>
> I also looked at the Part -> PartMtl tables to see if that was any
> different but it is the same.
>
> So at this point I am only able to list the 1st level components
for
> a part number.
>
> If anyone has cracked this nut, I would certainly appreciate some
> advice.
>
> Thanks in advance,
> Dave Olender dolender@...
> <mailto:dolender%40olenderconsulting.com>
> Ph 651-246-3281
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

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





[Non-text portions of this message have been removed]
Toby could you send me this report also.
thanks

Could a moderator place the file online ?

Stephen
sdeforge@...

--- In vantage@yahoogroups.com, "Michelle de la Vega" <mdelavega@...>
wrote:
>
> Ditto.
>
>
>
>
>
> <http://www.coldjet.com>
>
> Michelle de la Vega
>
> Business Applications Manager
>
> Cold Jet, LLC
>
> 455 Wards Corner Road
>
> Loveland, Ohio 45140
>
> 513-716-6400
>
> 513-831-1209 FAX
>
> Celebrating 20 Years of Dry Ice Technology and Innovation
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Rudy Rodriguez
> Sent: Monday, October 16, 2006 2:10 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
>
>
> I would appreciate this as well please!
> Thanks,
> Rudy
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Jasper Recto
> Sent: Monday, October 16, 2006 12:54 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
> Me Too Please!
>
> -----Original Message-----
> From: dsirow [mailto:dan@... <mailto:dan%40iccparts.com>
> <mailto:dan%40iccparts.com> ]
> Sent: Monday, October 16, 2006 1:39 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
> I would also like a copy of this report.
> Dan
> Independent Components Corp.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Toby Boogerd" <tboogerd@> wrote:
> >
> > Yes, I will send you this report.
> >
> >
> >
> >
> >
> > Toby Boogerd
> > Information Systems
> > 712-324-4854 x1119
> >
> > NOTICE: This email may contain confidential and proprietary
> information
> > of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
> the
> > recipient agrees not to use, reproduce, disclose, or manufacture
> its
> > contents, in whole or in part, without prior written consent of
> > Rosenboom Machine & Tool, Inc.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
>
> Behalf
> > Of Dave Olender
> > Sent: Thursday, October 05, 2006 8:06 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> >
> >
> >
> > I have been trying to create a Crystal version of the BOM Listing
> > Report and not having much luck.
> >
> > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > MtlPartNum field that lets me see the material required for the
> > Parent PartNum however I am unable to find a MtlPartNum Revision
> > (required to lookup the methods of the material requirement).
> >
> > I also looked at the Part -> PartMtl tables to see if that was any
> > different but it is the same.
> >
> > So at this point I am only able to list the 1st level components
> for
> > a part number.
> >
> > If anyone has cracked this nut, I would certainly appreciate some
> > advice.
> >
> > Thanks in advance,
> > Dave Olender dolender@
> > <mailto:dolender%40olenderconsulting.com>
> > Ph 651-246-3281
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Has this report file been placed online? If not could I please receive
the file?

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of de_forge
Sent: Tuesday, November 07, 2006 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.



Toby could you send me this report also.
thanks

Could a moderator place the file online ?

Stephen
sdeforge@... <mailto:sdeforge%40xsil.com>

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Michelle de la Vega" <mdelavega@...>
wrote:
>
> Ditto.
>
>
>
>
>
> <http://www.coldjet.com <http://www.coldjet.com> >
>
> Michelle de la Vega
>
> Business Applications Manager
>
> Cold Jet, LLC
>
> 455 Wards Corner Road
>
> Loveland, Ohio 45140
>
> 513-716-6400
>
> 513-831-1209 FAX
>
> Celebrating 20 Years of Dry Ice Technology and Innovation
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Rudy Rodriguez
> Sent: Monday, October 16, 2006 2:10 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
>
>
> I would appreciate this as well please!
> Thanks,
> Rudy
>
> ________________________________
>
> 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 Jasper Recto
> Sent: Monday, October 16, 2006 12:54 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
> Me Too Please!
>
> -----Original Message-----
> From: dsirow [mailto:dan@... <mailto:dan%40iccparts.com>
> <mailto:dan%40iccparts.com> ]
> Sent: Monday, October 16, 2006 1:39 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
> I would also like a copy of this report.
> Dan
> Independent Components Corp.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Toby Boogerd" <tboogerd@> wrote:
> >
> > Yes, I will send you this report.
> >
> >
> >
> >
> >
> > Toby Boogerd
> > Information Systems
> > 712-324-4854 x1119
> >
> > NOTICE: This email may contain confidential and proprietary
> information
> > of Rosenboom Machine & Tool, Inc. By opening any enclosed files,
> the
> > recipient agrees not to use, reproduce, disclose, or manufacture
> its
> > contents, in whole or in part, without prior written consent of
> > Rosenboom Machine & Tool, Inc.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]
On
>
> Behalf
> > Of Dave Olender
> > Sent: Thursday, October 05, 2006 8:06 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> >
> >
> >
> > I have been trying to create a Crystal version of the BOM Listing
> > Report and not having much luck.
> >
> > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > MtlPartNum field that lets me see the material required for the
> > Parent PartNum however I am unable to find a MtlPartNum Revision
> > (required to lookup the methods of the material requirement).
> >
> > I also looked at the Part -> PartMtl tables to see if that was any
> > different but it is the same.
> >
> > So at this point I am only able to list the 1st level components
> for
> > a part number.
> >
> > If anyone has cracked this nut, I would certainly appreciate some
> > advice.
> >
> > Thanks in advance,
> > Dave Olender dolender@
> > <mailto:dolender%40olenderconsulting.com>
> > Ph 651-246-3281
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
I know its been a few months but can someone send me this crystal
report. (I looked on the board for it and didnt see it posted)
Thanks
Elizabeth

ebigelow@...




--- In vantage@yahoogroups.com, "de_forge" <sdeforge@...> wrote:
>
> Toby could you send me this report also.
> thanks
>
> Could a moderator place the file online ?
>
> Stephen
> sdeforge@...
>
> --- In vantage@yahoogroups.com, "Michelle de la Vega" <mdelavega@>
> wrote:
> >
> > Ditto.
> >
> >
> >
> >
> >
> > <http://www.coldjet.com>
> >
> > Michelle de la Vega
> >
> > Business Applications Manager
> >
> > Cold Jet, LLC
> >
> > 455 Wards Corner Road
> >
> > Loveland, Ohio 45140
> >
> > 513-716-6400
> >
> > 513-831-1209 FAX
> >
> > Celebrating 20 Years of Dry Ice Technology and Innovation
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> > Of Rudy Rodriguez
> > Sent: Monday, October 16, 2006 2:10 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
listing.
> >
> >
> >
> > I would appreciate this as well please!
> > Thanks,
> > Rudy
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> > Behalf
> > Of Jasper Recto
> > Sent: Monday, October 16, 2006 12:54 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
listing.
> >
> > Me Too Please!
> >
> > -----Original Message-----
> > From: dsirow [mailto:dan@ <mailto:dan%40iccparts.com>
> > <mailto:dan%40iccparts.com> ]
> > Sent: Monday, October 16, 2006 1:39 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
> >
> > I would also like a copy of this report.
> > Dan
> > Independent Components Corp.
> >
> > --- In vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com,
> > "Toby Boogerd" <tboogerd@> wrote:
> > >
> > > Yes, I will send you this report.
> > >
> > >
> > >
> > >
> > >
> > > Toby Boogerd
> > > Information Systems
> > > 712-324-4854 x1119
> > >
> > > NOTICE: This email may contain confidential and proprietary
> > information
> > > of Rosenboom Machine & Tool, Inc. By opening any enclosed
files,
> > the
> > > recipient agrees not to use, reproduce, disclose, or
manufacture
> > its
> > > contents, in whole or in part, without prior written consent of
> > > Rosenboom Machine & Tool, Inc.
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com
> > [mailto: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
> >
> > Behalf
> > > Of Dave Olender
> > > Sent: Thursday, October 05, 2006 8:06 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> > >
> > >
> > >
> > > I have been trying to create a Crystal version of the BOM
Listing
> > > Report and not having much luck.
> > >
> > > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > > MtlPartNum field that lets me see the material required for the
> > > Parent PartNum however I am unable to find a MtlPartNum
Revision
> > > (required to lookup the methods of the material requirement).
> > >
> > > I also looked at the Part -> PartMtl tables to see if that was
any
> > > different but it is the same.
> > >
> > > So at this point I am only able to list the 1st level
components
> > for
> > > a part number.
> > >
> > > If anyone has cracked this nut, I would certainly appreciate
some
> > > advice.
> > >
> > > Thanks in advance,
> > > Dave Olender dolender@
> > > <mailto:dolender%40olenderconsulting.com>
> > > Ph 651-246-3281
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Did this report ever get posted, I couldn't find it. If not, I'd
love to have a copy if it's still available.

Sincerely,
Judy Havlik
judy.havlik@...

--- In vantage@yahoogroups.com, "elizabeth_h2ojet" <ebigelow@...>
wrote:
>
> I know its been a few months but can someone send me this crystal
> report. (I looked on the board for it and didnt see it posted)
> Thanks
> Elizabeth
>
> ebigelow@...
>
>
>
>
> --- In vantage@yahoogroups.com, "de_forge" <sdeforge@> wrote:
> >
> > Toby could you send me this report also.
> > thanks
> >
> > Could a moderator place the file online ?
> >
> > Stephen
> > sdeforge@
> >
> > --- In vantage@yahoogroups.com, "Michelle de la Vega" <mdelavega@>
> > wrote:
> > >
> > > Ditto.
> > >
> > >
> > >
> > >
> > >
> > > <http://www.coldjet.com>
> > >
> > > Michelle de la Vega
> > >
> > > Business Applications Manager
> > >
> > > Cold Jet, LLC
> > >
> > > 455 Wards Corner Road
> > >
> > > Loveland, Ohio 45140
> > >
> > > 513-716-6400
> > >
> > > 513-831-1209 FAX
> > >
> > > Celebrating 20 Years of Dry Ice Technology and Innovation
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On
> Behalf
> > > Of Rudy Rodriguez
> > > Sent: Monday, October 16, 2006 2:10 PM
> > > To: vantage@yahoogroups.com
> > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> listing.
> > >
> > >
> > >
> > > I would appreciate this as well please!
> > > Thanks,
> > > Rudy
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ] On
> > > Behalf
> > > Of Jasper Recto
> > > Sent: Monday, October 16, 2006 12:54 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> listing.
> > >
> > > Me Too Please!
> > >
> > > -----Original Message-----
> > > From: dsirow [mailto:dan@ <mailto:dan%40iccparts.com>
> > > <mailto:dan%40iccparts.com> ]
> > > Sent: Monday, October 16, 2006 1:39 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
> > >
> > > I would also like a copy of this report.
> > > Dan
> > > Independent Components Corp.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com,
> > > "Toby Boogerd" <tboogerd@> wrote:
> > > >
> > > > Yes, I will send you this report.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Toby Boogerd
> > > > Information Systems
> > > > 712-324-4854 x1119
> > > >
> > > > NOTICE: This email may contain confidential and proprietary
> > > information
> > > > of Rosenboom Machine & Tool, Inc. By opening any enclosed
> files,
> > > the
> > > > recipient agrees not to use, reproduce, disclose, or
> manufacture
> > > its
> > > > contents, in whole or in part, without prior written consent
of
> > > > Rosenboom Machine & Tool, Inc.
> > > >
> > > > ________________________________
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com
> > > [mailto: vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com] On
> > >
> > > Behalf
> > > > Of Dave Olender
> > > > Sent: Thursday, October 05, 2006 8:06 AM
> > > > To: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com
> > > > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> > > >
> > > >
> > > >
> > > > I have been trying to create a Crystal version of the BOM
> Listing
> > > > Report and not having much luck.
> > > >
> > > > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > > > MtlPartNum field that lets me see the material required for
the
> > > > Parent PartNum however I am unable to find a MtlPartNum
> Revision
> > > > (required to lookup the methods of the material requirement).
> > > >
> > > > I also looked at the Part -> PartMtl tables to see if that
was
> any
> > > > different but it is the same.
> > > >
> > > > So at this point I am only able to list the 1st level
> components
> > > for
> > > > a part number.
> > > >
> > > > If anyone has cracked this nut, I would certainly appreciate
> some
> > > > advice.
> > > >
> > > > Thanks in advance,
> > > > Dave Olender dolender@
> > > > <mailto:dolender%40olenderconsulting.com>
> > > > Ph 651-246-3281
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
Me too please, it would be greatly appreciated!



Stuart Noble
Thompson Meat Machinery


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Judy Havlik
Sent: Thursday, 25 January 2007 6:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.



Did this report ever get posted, I couldn't find it. If not, I'd
love to have a copy if it's still available.

Sincerely,
Judy Havlik
judy.havlik@... <mailto:judy.havlik%40plitek.com>

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"elizabeth_h2ojet" <ebigelow@...>
wrote:
>
> I know its been a few months but can someone send me this crystal
> report. (I looked on the board for it and didnt see it posted)
> Thanks
> Elizabeth
>
> ebigelow@...
>
>
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"de_forge" <sdeforge@> wrote:
> >
> > Toby could you send me this report also.
> > thanks
> >
> > Could a moderator place the file online ?
> >
> > Stephen
> > sdeforge@
> >
]
On
> Behalf
> > > Of Rudy Rodriguez
> > > Sent: Monday, October 16, 2006 2:10 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> listing.
> > >
> > >
> > >
> > > I would appreciate this as well please!
> > > Thanks,
> > > Rudy
> > >
> > > ________________________________
> > >
> > > 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 Jasper Recto
> > > Sent: Monday, October 16, 2006 12:54 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> listing.
> > >
> > > Me Too Please!
> > >
> > > -----Original Message-----
> > > From: dsirow [mailto:dan@ <mailto:dan%40iccparts.com>
> > > <mailto:dan%40iccparts.com> ]
> > > Sent: Monday, October 16, 2006 1:39 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
> > >
> > > I would also like a copy of this report.
> > > Dan
> > > Independent Components Corp.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com,
> > > "Toby Boogerd" <tboogerd@> wrote:
> > > >
> > > > Yes, I will send you this report.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Toby Boogerd
> > > > Information Systems
> > > > 712-324-4854 x1119
> > > >
> > > > NOTICE: This email may contain confidential and proprietary
> > > information
> > > > of Rosenboom Machine & Tool, Inc. By opening any enclosed
> files,
> > > the
> > > > recipient agrees not to use, reproduce, disclose, or
> manufacture
> > > its
> > > > contents, in whole or in part, without prior written consent
of
> > > > Rosenboom Machine & Tool, Inc.
> > > >
> > > > ________________________________
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com
> > > [mailto: vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com] On
> > >
> > > Behalf
> > > > Of Dave Olender
> > > > Sent: Thursday, October 05, 2006 8:06 AM
> > > > To: vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com
> > > > Subject: [Vantage] Has anyone created a Crystal BOM listing.
> > > >
> > > >
> > > >
> > > > I have been trying to create a Crystal version of the BOM
> Listing
> > > > Report and not having much luck.
> > > >
> > > > I have linked ECORev -> ECOMtl tables. The ECOMtl table has
> > > > MtlPartNum field that lets me see the material required for
the
> > > > Parent PartNum however I am unable to find a MtlPartNum
> Revision
> > > > (required to lookup the methods of the material requirement).
> > > >
> > > > I also looked at the Part -> PartMtl tables to see if that
was
> any
> > > > different but it is the same.
> > > >
> > > > So at this point I am only able to list the 1st level
> components
> > > for
> > > > a part number.
> > > >
> > > > If anyone has cracked this nut, I would certainly appreciate
> some
> > > > advice.
> > > >
> > > > Thanks in advance,
> > > > Dave Olender dolender@
> > > > <mailto:dolender%40olenderconsulting.com>
> > > > Ph 651-246-3281
> > > >




[Non-text portions of this message have been removed]
I have uploaded our Job BOM report
'Job004-JobBOM.rpt onto the site. If you have any questions, please
ask me offline.

Rich J
ERMC

--- In vantage@yahoogroups.com, "Stuart Noble" <stuart@...> wrote:
>
> Me too please, it would be greatly appreciated!
>
>
>
> Stuart Noble
> Thompson Meat Machinery
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Judy Havlik
> Sent: Thursday, 25 January 2007 6:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Has anyone created a Crystal BOM listing.
>
>
>
> Did this report ever get posted, I couldn't find it. If not, I'd
> love to have a copy if it's still available.
>
> Sincerely,
> Judy Havlik
> judy.havlik@... <mailto:judy.havlik%40plitek.com>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "elizabeth_h2ojet" <ebigelow@>
> wrote:
> >
> > I know its been a few months but can someone send me this
crystal
> > report. (I looked on the board for it and didnt see it posted)
> > Thanks
> > Elizabeth
> >
> > ebigelow@
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ,
> "de_forge" <sdeforge@> wrote:
> > >
> > > Toby could you send me this report also.
> > > thanks
> > >
> > > Could a moderator place the file online ?
> > >
> > > Stephen
> > > sdeforge@
> > >
> ]
> On
> > Behalf
> > > > Of Rudy Rodriguez
> > > > Sent: Monday, October 16, 2006 2:10 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> > > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> > listing.
> > > >
> > > >
> > > >
> > > > I would appreciate this as well please!
> > > > Thanks,
> > > > Rudy
> > > >
> > > > ________________________________
> > > >
> > > > 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 Jasper Recto
> > > > Sent: Monday, October 16, 2006 12:54 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: RE: [Vantage] Re: Has anyone created a Crystal BOM
> > listing.
> > > >
> > > > Me Too Please!
> > > >
> > > > -----Original Message-----
> > > > From: dsirow [mailto:dan@ <mailto:dan%40iccparts.com>
> > > > <mailto:dan%40iccparts.com> ]
> > > > Sent: Monday, October 16, 2006 1:39 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Has anyone created a Crystal BOM
listing.
> > > >
> > > > I would also like a copy of this report.
> > > > Dan
> > > > Independent Components Corp.
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%
> > 40yahoogroups.com> .com,
> > > > "Toby Boogerd" <tboogerd@> wrote:
> > > > >
> > > > > Yes, I will send you this report.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Toby Boogerd
> > > > > Information Systems
> > > > > 712-324-4854 x1119
> > > > >
> > > > > NOTICE: This email may contain confidential and
proprietary
> > > > information
> > > > > of Rosenboom Machine & Tool, Inc. By opening any enclosed
> > files,
> > > > the
> > > > > recipient agrees not to use, reproduce, disclose, or
> > manufacture
> > > > its
> > > > > contents, in whole or in part, without prior written
consent
> of
> > > > > Rosenboom Machine & Tool, Inc.
> > > > >
> > > > > ________________________________
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%
> > 40yahoogroups.com> .com
> > > > [mailto: vantage@yahoogroups <mailto:vantage%
> > 40yahoogroups.com> .com] On
> > > >
> > > > Behalf
> > > > > Of Dave Olender
> > > > > Sent: Thursday, October 05, 2006 8:06 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com
> > > > > Subject: [Vantage] Has anyone created a Crystal BOM
listing.
> > > > >
> > > > >
> > > > >
> > > > > I have been trying to create a Crystal version of the BOM
> > Listing
> > > > > Report and not having much luck.
> > > > >
> > > > > I have linked ECORev -> ECOMtl tables. The ECOMtl table
has
> > > > > MtlPartNum field that lets me see the material required
for
> the
> > > > > Parent PartNum however I am unable to find a MtlPartNum
> > Revision
> > > > > (required to lookup the methods of the material
requirement).
> > > > >
> > > > > I also looked at the Part -> PartMtl tables to see if that
> was
> > any
> > > > > different but it is the same.
> > > > >
> > > > > So at this point I am only able to list the 1st level
> > components
> > > > for
> > > > > a part number.
> > > > >
> > > > > If anyone has cracked this nut, I would certainly
appreciate
> > some
> > > > > advice.
> > > > >
> > > > > Thanks in advance,
> > > > > Dave Olender dolender@
> > > > > <mailto:dolender%40olenderconsulting.com>
> > > > > Ph 651-246-3281
> > > > >
>
>
>
>
> [Non-text portions of this message have been removed]
>