Indented BOM Blank Title 73747

Yahoo Archive
1
I just saved a modification of bw's UD20 customization that will keep
the indented BOM sequence intact. I attached a dashboard that
contains several reports as well. Hope someone finds this useful!

Kirstin

--- In vantage@yahoogroups.com, "Brian W. Spolarich "
<bspolarich@...> wrote:
>
> My solution is entirely MSSQL-based.
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
Photonix /
> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Brad Ebright
> Sent: Tuesday, February 03, 2009 10:29 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Indented BOM
>
>
>
> I just read the readme, and we use progress database and we are
running
> 8.0.
>
> So this wont work for us.correct?
>
> Thank You,
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf Of
> Brian W. Spolarich
> Sent: Tuesday, February 03, 2009 10:04 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Indented BOM
>
> I developed a Custom BOM Report that uses a MSSQL Common Table
> Expression query to generate the indented BOM.
>
> I've uploaded it to the Files Section under "Reports - Crystal
> Reports".
>
> You might use this as a starting point for your solution.
>
> -bws
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced
Photonix /
> Picometrix
>
> bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
> photonix.com
> ~ 734-864-5618 ~
> www.advancedphotonix.com
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%
40yahoogroups.com> .com] On
> Behalf
> Of brad.ebright
> Sent: Tuesday, February 03, 2009 9:42 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Indented BOM
>
> I have a request for a report that i am not sure how to do. They
would
> like to see in an indented bill of materials where parts are
> duplicated. In crystal, i have the bill of materials (not sure if i
did
> it the best way), but if the duplicate part is on another lever of
the
> BOM, i'm not sure to link it back to the first level of the BOM?
>
> When you go into the costs from the method tracker, it shows the
> different levels of the BOM using periods. Is there a table that
has
> this in it, or are they making relationships in the code of vantage
to
> show this.
>
> I thank you for the help in advance,
> Brad
>
> [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]
>
2
I have a request for a report that i am not sure how to do. They would
like to see in an indented bill of materials where parts are
duplicated. In crystal, i have the bill of materials (not sure if i did
it the best way), but if the duplicate part is on another lever of the
BOM, i'm not sure to link it back to the first level of the BOM?

When you go into the costs from the method tracker, it shows the
different levels of the BOM using periods. Is there a table that has
this in it, or are they making relationships in the code of vantage to
show this.

I thank you for the help in advance,
Brad
3
I developed a Custom BOM Report that uses a MSSQL Common Table
Expression query to generate the indented BOM.



I've uploaded it to the Files Section under "Reports - Crystal
Reports".



You might use this as a starting point for your solution.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of brad.ebright
Sent: Tuesday, February 03, 2009 9:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Indented BOM



I have a request for a report that i am not sure how to do. They would
like to see in an indented bill of materials where parts are
duplicated. In crystal, i have the bill of materials (not sure if i did
it the best way), but if the duplicate part is on another lever of the
BOM, i'm not sure to link it back to the first level of the BOM?

When you go into the costs from the method tracker, it shows the
different levels of the BOM using periods. Is there a table that has
this in it, or are they making relationships in the code of vantage to
show this.

I thank you for the help in advance,
Brad





[Non-text portions of this message have been removed]
4
I just read the readme, and we use progress database and we are running 8.0.



So this wont work for us.correct?



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 03, 2009 10:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Indented BOM



I developed a Custom BOM Report that uses a MSSQL Common Table
Expression query to generate the indented BOM.

I've uploaded it to the Files Section under "Reports - Crystal
Reports".

You might use this as a starting point for your solution.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com> photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of brad.ebright
Sent: Tuesday, February 03, 2009 9:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Indented BOM

I have a request for a report that i am not sure how to do. They would
like to see in an indented bill of materials where parts are
duplicated. In crystal, i have the bill of materials (not sure if i did
it the best way), but if the duplicate part is on another lever of the
BOM, i'm not sure to link it back to the first level of the BOM?

When you go into the costs from the method tracker, it shows the
different levels of the BOM using periods. Is there a table that has
this in it, or are they making relationships in the code of vantage to
show this.

I thank you for the help in advance,
Brad

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





[Non-text portions of this message have been removed]
5
My solution is entirely MSSQL-based.



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brad Ebright
Sent: Tuesday, February 03, 2009 10:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Indented BOM



I just read the readme, and we use progress database and we are running
8.0.

So this wont work for us.correct?

Thank You,

Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Brian W. Spolarich
Sent: Tuesday, February 03, 2009 10:04 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Indented BOM

I developed a Custom BOM Report that uses a MSSQL Common Table
Expression query to generate the indented BOM.

I've uploaded it to the Files Section under "Reports - Crystal
Reports".

You might use this as a starting point for your solution.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of brad.ebright
Sent: Tuesday, February 03, 2009 9:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Indented BOM

I have a request for a report that i am not sure how to do. They would
like to see in an indented bill of materials where parts are
duplicated. In crystal, i have the bill of materials (not sure if i did
it the best way), but if the duplicate part is on another lever of the
BOM, i'm not sure to link it back to the first level of the BOM?

When you go into the costs from the method tracker, it shows the
different levels of the BOM using periods. Is there a table that has
this in it, or are they making relationships in the code of vantage to
show this.

I thank you for the help in advance,
Brad

[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]