Excel BOM Vantage 8.03.403C

Yahoo Archive
1
If you are using odbc/SQL, ALWAYS check MS's TechNet for free code 1st:

Here is a full blown (free) SQLServer db schema scenario and SQL code for multilevel explosions/viewing:

http://technet.microsoft.com/en-us/library/ms124499(SQL.100).aspx

Try adapting it to vantage tables. I had a one time need and adapted it recently to our legacy db & it worked fine with excel & msquery.

Why write what you can copy for free? :)

Rob Brown

--- On Thu, 5/22/08, Calvin Krusen <ckrusen@...> wrote:

From: Calvin Krusen <ckrusen@...>
Subject: [Vantage] Re: Excel BOM Vantage 8.03.403C
To: vantage@yahoogroups.com
Date: Thursday, May 22, 2008, 12:29 PM






I see its been a while since this thread had any activity, but had
some related comments (questions really).

Can sub-reports in Crystal be called recursively? How about
Progress .p code?

For those unaware of the term, recursive functions are functions that
use the function within itself. They obviously always have an escape
mechanism.

For example, a multi-level BOM listing function would list the first
component, then call the multi-level listing function on the
component. If no subcomponents exist, then the function exits and
pops back up a level, and then goes on to the next component at that
level. You could put a maximim number of levels to explode, mostly to
limit consuming all the system memory if a circular reference existed.

Or has an easier exploded BOM report been found?

Calvin

--- In vantage@yahoogroups .com, "pack263cubscouts" <jhartman@.. .>
wrote:
>
> New to Vantage and went live 1-2-2008. Need to export multi-level BOM
> to Excel, mostly interested in list of purchased parts (lowest
levels)
> along with their extended quantities. BOM's are a maximum of 7 levels
> deep. I think this can be accomplished with do loop and array
> functions in Crystal but I am not familiar with the code. Any help is
> appreciated.
>
> Jim Hartman
> Bil-Jax, Inc.
>
2
New to Vantage and went live 1-2-2008. Need to export multi-level BOM
to Excel, mostly interested in list of purchased parts (lowest levels)
along with their extended quantities. BOM's are a maximum of 7 levels
deep. I think this can be accomplished with do loop and array
functions in Crystal but I am not familiar with the code. Any help is
appreciated.

Jim Hartman
Bil-Jax, Inc.
3
Both Vantage 6.1 and an older version of Vista (according to my search results of all Epicor sites) had multi-level (phantom) BOM cost detail reports.

I've yet to find the equivalent in 8.03.403 but find it hard to believe something so basic in most systems doesn't exist. (Perhaps someone out there can point us in the right direction???)

IF such a (Crystal) report exists in 403, it would make a fine starting point for what you are looking for.

You'd simply have to strip out the criteria limiting further BOM level explosions past non-phantom levels encountered in the structure(s) and then likely have to tweak the displayed fields to suit your specific needs.

Rob Brown



pack263cubscouts <jhartman@...> wrote:
New to Vantage and went live 1-2-2008. Need to export multi-level BOM
to Excel, mostly interested in list of purchased parts (lowest levels)
along with their extended quantities. BOM's are a maximum of 7 levels
deep. I think this can be accomplished with do loop and array
functions in Crystal but I am not familiar with the code. Any help is
appreciated.

Jim Hartman
Bil-Jax, Inc.






---------------------------------
Never miss a thing. Make Yahoo your homepage.

[Non-text portions of this message have been removed]
4
What about writing a BAQ and dashboard with the assembly level. You
could the copy and paste right into Excel or create a BAQ report with
Crystal and indent at each level.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pack263cubscouts
Sent: Friday, January 18, 2008 7:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Excel BOM Vantage 8.03.403C



New to Vantage and went live 1-2-2008. Need to export multi-level BOM
to Excel, mostly interested in list of purchased parts (lowest levels)
along with their extended quantities. BOM's are a maximum of 7 levels
deep. I think this can be accomplished with do loop and array
functions in Crystal but I am not familiar with the code. Any help is
appreciated.

Jim Hartman
Bil-Jax, Inc.





[Non-text portions of this message have been removed]
5
The problem is taking the PartMatl file that shows parent/child/qty and
making it into this type of multi-level view. The report criteria would
determine the top level parent. It would then need to find all children,
children's children, children's children's children, etc, along with
their intended quantities which need to be multiplied down the BOM
structure to get intended quantities.



Jim Hartman
Procurement Engineer
125 Taylor Parkway
Archbold, Ohio 43502
Phone: (419) 445-8915 ext. 235
Fax: (419) 445-8113

NOTICE: This communication may contain privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email, fax, or collect telephone call and immediately delete
the message and any attachments without copying or disclosing the
contents. Thank you.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Smith
Sent: Sunday, January 20, 2008 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Excel BOM Vantage 8.03.403C



What about writing a BAQ and dashboard with the assembly level. You
could the copy and paste right into Excel or create a BAQ report with
Crystal and indent at each level.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of pack263cubscouts
Sent: Friday, January 18, 2008 7:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Excel BOM Vantage 8.03.403C

New to Vantage and went live 1-2-2008. Need to export multi-level BOM
to Excel, mostly interested in list of purchased parts (lowest levels)
along with their extended quantities. BOM's are a maximum of 7 levels
deep. I think this can be accomplished with do loop and array
functions in Crystal but I am not familiar with the code. Any help is
appreciated.

Jim Hartman
Bil-Jax, Inc.

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







The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your system.

[Non-text portions of this message have been removed]
6
You may be doing this the hard way... Seems to me you should be able to take any of the system ("z" prefix) BAQs (or one of your own authoring) and use the BAQ Export utility to dump the query results to a file. Output file options are CSV or XML.

In your case, export the results of "zPartWhereUsedDnLvl" or "zPartWhereUsedUpLvl" (or a modified version of them more pertinent to your needs). If it is going to be a reoccurring process, set it up as a recurring task.

Excel can easily bring it in the query result data if it is CSV format. I would expect XML to be usable by excel (perhaps even resulting in a more reliable process if it is going to be repetitive) - but I have yet to delve into excel's handling of XML deeply enough yet to be sure it is worth the effort.

Rob Brown
"Hartman, Jim" <jhartman@...> wrote:
The problem is taking the PartMatl file that shows parent/child/qty and
making it into this type of multi-level view. The report criteria would
determine the top level parent. It would then need to find all children,
children's children, children's children's children, etc, along with
their intended quantities which need to be multiplied down the BOM
structure to get intended quantities.



Jim Hartman
Procurement Engineer
125 Taylor Parkway
Archbold, Ohio 43502
Phone: (419) 445-8915 ext. 235
Fax: (419) 445-8113

NOTICE: This communication may contain privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email, fax, or collect telephone call and immediately delete
the message and any attachments without copying or disclosing the
contents. Thank you.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Smith
Sent: Sunday, January 20, 2008 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Excel BOM Vantage 8.03.403C

What about writing a BAQ and dashboard with the assembly level. You
could the copy and paste right into Excel or create a BAQ report with
Crystal and indent at each level.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of pack263cubscouts
Sent: Friday, January 18, 2008 7:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Excel BOM Vantage 8.03.403C

New to Vantage and went live 1-2-2008. Need to export multi-level BOM
to Excel, mostly interested in list of purchased parts (lowest levels)
along with their extended quantities. BOM's are a maximum of 7 levels
deep. I think this can be accomplished with do loop and array
functions in Crystal but I am not familiar with the code. Any help is
appreciated.

Jim Hartman
Bil-Jax, Inc.

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

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from your system.

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






---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]
7
I see its been a while since this thread had any activity, but had
some related comments (questions really).

Can sub-reports in Crystal be called recursively? How about
Progress .p code?

For those unaware of the term, recursive functions are functions that
use the function within itself. They obviously always have an escape
mechanism.

For example, a multi-level BOM listing function would list the first
component, then call the multi-level listing function on the
component. If no subcomponents exist, then the function exits and
pops back up a level, and then goes on to the next component at that
level. You could put a maximim number of levels to explode, mostly to
limit consuming all the system memory if a circular reference existed.

Or has an easier exploded BOM report been found?

Calvin

--- In vantage@yahoogroups.com, "pack263cubscouts" <jhartman@...>
wrote:
>
> New to Vantage and went live 1-2-2008. Need to export multi-level BOM
> to Excel, mostly interested in list of purchased parts (lowest
levels)
> along with their extended quantities. BOM's are a maximum of 7 levels
> deep. I think this can be accomplished with do loop and array
> functions in Crystal but I am not familiar with the code. Any help is
> appreciated.
>
> Jim Hartman
> Bil-Jax, Inc.
>