Crystal reports for a BOM

Yahoo Archive
1
We have been having issues with Vantage locking up as well, every once
in a while. Users can view data but upon saving, vantage hangs. If
you let it go, it will be locked up for 30 min and then the record is
released and all the users who tried to save while it was locked will
now save. I wrote my own BOM report using SQL procedures and then
feeding the result to Crystal. We have had a call open with Vantage
since October and still haven't been able to determine what the issue
is. Another note, while records are locked, MES still operates just
fine.

Is this is issue that you are having as well?


--- In vantage@yahoogroups.com, "Hartman, Jim" <jhartman@...> wrote:
>
> To all who have requested copies of this report,
>
> We have discovered some issues related to this ODBC report. It is
> suspected that the report causes Vantage to lock up. Based on this
> issue, I will not offer the report until such time as it is eliminated
> as the suspect for these lockups.
>
>
>
> Jim Hartman
> Procurement Engineer
> 125 Taylor Parkway
> Archbold, Ohio 43502
> Phone: (419) 445-8915 ext. 235
> Fax: (419) 445-8113
>
2
We have created a new pick slip, and set it as the default in Vantage.
When we try to go print it, we get the error below. Now the original
pick ticket was 8.5" x 11" and the new one is 8.5" x 14". Would that
be the cause of the problem? Is there somewhere to change the page size
in Vantage? Is this an Epicor Tech Support Question?



************** Exception Text **************

System.Runtime.InteropServices.COMException (0x8002000B): Invalid index.
(Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

at
CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClass.
ModifyPrintOptions(PrintOptions newVal)

at
CrystalDecisions.CrystalReports.Engine.PrintOptions.set_PaperSize(PaperS
ize value)

at Epicor.Mfg.Lib.Report.EpiCrystalViewer.ShowReport()

at
System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry
tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object
obj)

at System.Threading.ExecutionContext.runTryCode(Object userData)

at
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteed
Cleanup(TryCode code, CleanupCode backoutCode, Object userData)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext
executionContext, ContextCallback callback, Object state)

at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)

at
System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry
tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbacks()





Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]
3
Mr. Matt: Have you tried setting your XP local print preferences to
8.5x14 as a default?

If not I would give that a try first.

DaveO

--- In vantage@yahoogroups.com, "Matt Caldwell" <matt@...> wrote:
>
> We have created a new pick slip, and set it as the default in
Vantage.
> When we try to go print it, we get the error below. Now the
original
> pick ticket was 8.5" x 11" and the new one is 8.5" x 14". Would
that
> be the cause of the problem? Is there somewhere to change the page
size
> in Vantage? Is this an Epicor Tech Support Question?
>
>
>
> ************** Exception Text **************
>
> System.Runtime.InteropServices.COMException (0x8002000B): Invalid
index.
> (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
>
> at
>
CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClas
s.
> ModifyPrintOptions(PrintOptions newVal)
>
> at
> CrystalDecisions.CrystalReports.Engine.PrintOptions.set_PaperSize
(PaperS
> ize value)
>
> at Epicor.Mfg.Lib.Report.EpiCrystalViewer.ShowReport()
>
> at
> System.Windows.Forms.Control.InvokeMarshaledCallbackDo
(ThreadMethodEntry
> tme)
>
> at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper
(Object
> obj)
>
> at System.Threading.ExecutionContext.runTryCode(Object userData)
>
> at
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuarante
ed
> Cleanup(TryCode code, CleanupCode backoutCode, Object userData)
>
> at System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>
> at System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>
> at
> System.Windows.Forms.Control.InvokeMarshaledCallback
(ThreadMethodEntry
> tme)
>
> at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
>
>
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
This printer is a network share. If we print this pick slip from
Crystal, it prints fine. We cannot preview or print it from Vantage,
though.





--Matt



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Olender
Sent: Tuesday, February 05, 2008 7:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports/Vantage error



Mr. Matt: Have you tried setting your XP local print preferences to
8.5x14 as a default?

If not I would give that a try first.

DaveO

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Matt Caldwell" <matt@...> wrote:
>
> We have created a new pick slip, and set it as the default in
Vantage.
> When we try to go print it, we get the error below. Now the
original
> pick ticket was 8.5" x 11" and the new one is 8.5" x 14". Would
that
> be the cause of the problem? Is there somewhere to change the page
size
> in Vantage? Is this an Epicor Tech Support Question?
>
>
>
> ************** Exception Text **************
>
> System.Runtime.InteropServices.COMException (0x8002000B): Invalid
index.
> (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
>
> at
>
CrystalDecisions.ReportAppServer.Controllers.PrintOutputControllerClas
s.
> ModifyPrintOptions(PrintOptions newVal)
>
> at
> CrystalDecisions.CrystalReports.Engine.PrintOptions.set_PaperSize
(PaperS
> ize value)
>
> at Epicor.Mfg.Lib.Report.EpiCrystalViewer.ShowReport()
>
> at
> System.Windows.Forms.Control.InvokeMarshaledCallbackDo
(ThreadMethodEntry
> tme)
>
> at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper
(Object
> obj)
>
> at System.Threading.ExecutionContext.runTryCode(Object userData)
>
> at
>
System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuarante
ed
> Cleanup(TryCode code, CleanupCode backoutCode, Object userData)
>
> at System.Threading.ExecutionContext.RunInternal(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>
> at System.Threading.ExecutionContext.Run(ExecutionContext
> executionContext, ContextCallback callback, Object state)
>
> at
> System.Windows.Forms.Control.InvokeMarshaledCallback
(ThreadMethodEntry
> tme)
>
> at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
>
>
>
>
>
> Matt Caldwell
> Technical Support Analyst
>
> KERUSSO
> P.O. Box 32
> Berryville, AR 72616
> Phone: 800-424-0943 Ext. 231
> Fax: 870-423-3568
> Web Site: http://www.kerusso.com
> ******************************************************************
> CONFIDENTIALITY STATEMENT:
> This message, from Kerusso Inc., contains information
> which is privileged and confidential and is solely for the use of
> the intended recipient. If you are not the intended recipient, be
> aware that any review, disclosure, copying, distribution, or use
> of the contents of this message is strictly prohibited. If you have
> received this in error, please destroy it and notify us immediately
> at: 800-424-0943
> ******************************************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
5
Good Morning Everyone,



Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.



Can any please help me with this!







Dale Kalsow | Information Technologies Director
____________________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... | * http://determan.com/



"Ambition is the path to success. Persistence is the vehicle you arrive
in."



Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________





[Non-text portions of this message have been removed]
6
Good Morning Everyone,



We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?



Thanks!



Dale Kalsow | Information Technologies Director
____________________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... | * http://determan.com/



"Ambition is the path to success. Persistence is the vehicle you arrive
in."



Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________





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

I created a crystal BOM report by using multiple instances of the BOM
file and other related files, and daisy chaining them together. In other
words by relating the child from one instance to the parent of the next
instance. This works very well going down 7 levels deep, not sure if it
will work going any deeper.



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 Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports for a BOM



Good Morning Everyone,

We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?

Thanks!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
HTLuZQnAhNKVKDMDeFteXbxEVbK9IIcBQkXFFFLKce5N4DIpGX0Ux8YhQfVs5h-rsokUz6Hq
RebqjHnBPqbRTHCQkXFFFLKc6zASO-rdbopS4Z8-qnjh09hbkDFVEwzWRoPEq87qNd46Cy0p
30SrDUvf0srhdFECQTSjhONtNwTDw61-CpFRLz>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

[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]
8
Mine goes 8 levels, Jim...I could not get it to go further than that.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hartman, Jim
Sent: Tuesday, February 05, 2008 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports for a BOM



Dale,

I created a crystal BOM report by using multiple instances of the BOM
file and other related files, and daisy chaining them together. In other
words by relating the child from one instance to the parent of the next
instance. This works very well going down 7 levels deep, not sure if it
will work going any deeper.



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%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal reports for a BOM

Good Morning Everyone,

We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?

Thanks!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
>
HTLuZQnAhNKVKDMDeFteXbxEVbK9IIcBQkXFFFLKce5N4DIpGX0Ux8YhQfVs5h-rsokUz6Hq
RebqjHnBPqbRTHCQkXFFFLKc6zASO-rdbopS4Z8-qnjh09hbkDFVEwzWRoPEq87qNd46Cy0p
30SrDUvf0srhdFECQTSjhONtNwTDw61-CpFRLz>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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






[Non-text portions of this message have been removed]
9
It is my understanding that Epicor will not give users this information.




Paul Manzi

Director Information Systems

Acceleron, Inc.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor table relationships



Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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





CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. The designated recipients are prohibited from redisplaying this information to any other party without authorization. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited by federal or state law. If you have received this communication in error, please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of this communication and any attachments.



[Non-text portions of this message have been removed]
10
You can create your own version of this using the Data Dictionary Report and
selecting Table Relationships and selecting the tables you wish to view. It
is still there in v6.1, not sure about v8.



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul Manzi
Sent: Tuesday, February 05, 2008 11:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor table relationships



It is my understanding that Epicor will not give users this information.

Paul Manzi

Director Information Systems

Acceleron, Inc.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor table relationships

Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. The designated recipients are prohibited
from redisplaying this information to any other party without authorization.
If you are not the intended recipient, you are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited
by federal or state law. If you have received this communication in error,
please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of
this communication and any attachments.

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





[Non-text portions of this message have been removed]
11
You can create your own version of this using the Data Dictionary Report and
selecting Table Relationships and selecting the tables you wish to view. It
is still there in v6.1, not sure about v8.



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul Manzi
Sent: Tuesday, February 05, 2008 11:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor table relationships



It is my understanding that Epicor will not give users this information.

Paul Manzi

Director Information Systems

Acceleron, Inc.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor table relationships

Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. The designated recipients are prohibited
from redisplaying this information to any other party without authorization.
If you are not the intended recipient, you are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited
by federal or state law. If you have received this communication in error,
please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of
this communication and any attachments.

[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]
12
It is my understanding that Epicor will not give users this information.




Paul Manzi

Director Information Systems

Acceleron, Inc.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor table relationships



Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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





CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. The designated recipients are prohibited from redisplaying this information to any other party without authorization. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited by federal or state law. If you have received this communication in error, please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of this communication and any attachments.



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


[Non-text portions of this message have been removed]
13
You can create your own version of this using the Data Dictionary Report and
selecting Table Relationships and selecting the tables you wish to view. It
is still there in v6.1, not sure about v8.



Ted Kitch

Information Technology Manager

Astro Machine Corporation

www.astromachine.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul Manzi
Sent: Tuesday, February 05, 2008 11:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor table relationships



It is my understanding that Epicor will not give users this information.

Paul Manzi

Director Information Systems

Acceleron, Inc.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor table relationships

Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. The designated recipients are prohibited
from redisplaying this information to any other party without authorization.
If you are not the intended recipient, you are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited
by federal or state law. If you have received this communication in error,
please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of
this communication and any attachments.

[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]
14
It is my understanding that Epicor will not give users this information.




Paul Manzi

Director Information Systems

Acceleron, Inc.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor table relationships



Good Morning Everyone,

Has anyone seen a diagram which shows how all of the tables are related
in Epicor? I know you can go into the software and see the keys and the
tables that relate to a specific table but I am looking for a diagram.
I can believe that Epicor would not have this for their vantage product.

Can any please help me with this!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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





CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. The designated recipients are prohibited from redisplaying this information to any other party without authorization. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited by federal or state law. If you have received this communication in error, please notify Acceleron, Inc. at 1-860-651-9333, and destroy all copies of this communication and any attachments.



[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]
15
> You can create your own version of this using the Data Dictionary Report and
> selecting Table Relationships and selecting the tables you wish to view. It
> is still there in v6.1, not sure about v8.

Yes, the relationships report is still there.

Hmm, I wonder if one could do something similar with Visio that this gent did?

http://urlgreyhot.com/personal/publications/automating_diagrams_with_visio

Don't have Visio or I would try...

Mark W.
16
It would be nice to have a Visio diagram. It's so much easier to get the concepts when you view how it is working.

Debbie Smith
Argonics, Inc

Mark Wonsil <mark_wonsil@...> wrote:
> You can create your own version of this using the Data Dictionary Report and
> selecting Table Relationships and selecting the tables you wish to view. It
> is still there in v6.1, not sure about v8.

Yes, the relationships report is still there.

Hmm, I wonder if one could do something similar with Visio that this gent did?

http://urlgreyhot.com/personal/publications/automating_diagrams_with_visio

Don't have Visio or I would try...

Mark W.






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
17
I wonder if you could get it to go deeper, if you used sub reports.



Bruce Butler

<mailto:bbutler@...> bbutler@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Tuesday, ebruary 05, 2008 10:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports for a BOM



Mine goes 8 levels, Jim...I could not get it to go further than that.



M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Hartman, Jim
Sent: Tuesday, February 05, 2008 9:48 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal reports for a BOM

Dale,

I created a crystal BOM report by using multiple instances of the BOM
file and other related files, and daisy chaining them together. In other
words by relating the child from one instance to the parent of the next
instance. This works very well going down 7 levels deep, not sure if it
will work going any deeper.

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%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal reports for a BOM

Good Morning Everyone,

We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?

Thanks!

Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
>
HTLuZQnAhNKVKDMDeFteXbxEVbK9IIcBQkXFFFLKce5N4DIpGX0Ux8YhQfVs5h-rsokUz6Hq
RebqjHnBPqbRTHCQkXFFFLKc6zASO-rdbopS4Z8-qnjh09hbkDFVEwzWRoPEq87qNd46Cy0p
30SrDUvf0srhdFECQTSjhONtNwTDw61-CpFRLz>

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

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





[Non-text portions of this message have been removed]
18
Early on in our implementation (8.03.305K at present), I also asked
about getting just such a schema...was told that none existed outside
of the Development team @ Epicor. Given any 'spare time', I'd sure
like to build one.....using the relationships in the Data dictionary..

Gary

--- In vantage@yahoogroups.com, "Dale R. Kalsow" <dale.r.kalsow@...>
wrote:
>
> Good Morning Everyone,
>
>
>
> Has anyone seen a diagram which shows how all of the tables are related
> in Epicor? I know you can go into the software and see the keys and the
> tables that relate to a specific table but I am looking for a diagram.
> I can believe that Epicor would not have this for their vantage product.
>
>
>
> Can any please help me with this!
>
>
>
>
>
>
>
> Dale Kalsow | Information Technologies Director
> ____________________________________________________________________
> Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432
>
> * Phone: (763) 502-9689 | * Fax: (763) 571-1789
>
> * dale.r.kalsow@... | * http://determan.com/
>
>
>
> "Ambition is the path to success. Persistence is the vehicle you arrive
> in."
>
>
>
> Electronic Privacy Notice. This e-mail, and any attachments, contains
> information that is, or may be, covered by the Electronic Communications
> Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
> proprietary in nature. If you are not the intended recipient, please be
> advised that you are legally prohibited from retaining, using, copying,
> distributing, or otherwise disclosing this information in any manner.
> Instead, please reply to the sender that you have received this
> communication in error, and then immediately delete it. Thank you in
> advance for your cooperation.
>
> ________________________________
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
19
I did try to build one a while back using the Visio Reverse feature and
ODBC. It did work but was such a huge file and the formatting was so
messy I just tossed the thought aside. I just tried it again a moment
ago using the Job related tables and it did extract all the tables and
field names in a nice Entity Relationship Model format. It did not link
the tables but does provide table data with index information. I suspect
to accomplish this for the entire database would take some serious
efforts.

I used Visio 2003 Professional if you are interested.





Keith Mailloux

Ferguson Perforating

(401)941-8876



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Franks
Sent: Thursday, February 07, 2008 1:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor table relationships



Early on in our implementation (8.03.305K at present), I also asked
about getting just such a schema...was told that none existed outside
of the Development team @ Epicor. Given any 'spare time', I'd sure
like to build one.....using the relationships in the Data dictionary..

Gary

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dale R. Kalsow" <dale.r.kalsow@...>
wrote:
>
> Good Morning Everyone,
>
>
>
> Has anyone seen a diagram which shows how all of the tables are
related
> in Epicor? I know you can go into the software and see the keys and
the
> tables that relate to a specific table but I am looking for a diagram.
> I can believe that Epicor would not have this for their vantage
product.
>
>
>
> Can any please help me with this!
>
>
>
>
>
>
>
> Dale Kalsow | Information Technologies Director
> __________________________________________________________
> Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432
>
> * Phone: (763) 502-9689 | * Fax: (763) 571-1789
>
> * dale.r.kalsow@... | * http://determan.com/ <http://determan.com/>
>
>
>
> "Ambition is the path to success. Persistence is the vehicle you
arrive
> in."
>
>
>
> Electronic Privacy Notice. This e-mail, and any attachments, contains
> information that is, or may be, covered by the Electronic
Communications
> Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
> proprietary in nature. If you are not the intended recipient, please
be
> advised that you are legally prohibited from retaining, using,
copying,
> distributing, or otherwise disclosing this information in any manner.
> Instead, please reply to the sender that you have received this
> communication in error, and then immediately delete it. Thank you in
> advance for your cooperation.
>
> ________________________________
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
20
--- In vantage@yahoogroups.com, "Paul Manzi" <pmanzi@...> wrote:
>
> It is my understanding that Epicor will not give users this
information.
>
> Paul Manzi
>
> Director Information Systems
>
> Acceleron, Inc.
>
In 6.1 ou can ODBC into the tables used for the in built Data
dictionary.
They all start with SYSPROGRESS_
this is a full list of table.
and fields within tables.
Though i have not tried to generate a full relational diagram
I would thing that looking at the number of table and fields it
would be hard to understand.
that i did produce was an alphabetic list of all field names and the
tables they occur in.
and an access query to search for the same thing.
these let me find my way into relationships i ares of the Db i have
not explored. And when i have found tabel anmes i use the data
dictionary. I guess i could improve my access Query to did out the
Data dictionary text but life is too short, use the pre built tool.


hope this is of some use.

D