Report tables needed to figure out cost of a project (Vantage 8

system · July 23, 2012, 5:01pm

PERFECT. Exactly what I needed. Thanks Ted and Vic..Now if I can just
figure out how to write a report to get WIP value I think I could rule the
world J

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Monday, July 23, 2012 10:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Project ID is stored in JobHead. Link JobAsmbl to JobHead and there's your
ProjectID.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mike Abell
Sent: Monday, July 23, 2012 10:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Thanks Ted, but how do I link this table back to a "Project" ID. I'm trying
to find out the costs of a "project" that has many jobs associated with it.
Not sure how what tables link "projects" and "jobs". Any ideas?

Mike..

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
Ted Koch
Sent: Monday, July 23, 2012 9:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Mike,

Try looking in the JobAsmbl table. This will contain Lower Level and This
Level Actual Costs related to a job.

________________________________
From: flexial_ma <mike.abell@...
<mailto:mike.abell%40kingston-asfc.com>
<mailto:mike.abell%40kingston-asfc.com>
<mailto:mike.abell%40kingston-asfc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Monday, July 23, 2012 9:59 AM
Subject: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

I am into writing a custom crystal report that I need to figure out which
tables to use to find the total cost of a "Project". We have multiple jobs
within a "Project" that I need to find the individual "job's" cost
(material, labor, overhead, subcontract). Can anyone point me in the right
direction as to which tables in Vantage might contain this information or
how I might get to this data? Thanks in advance!

Mike..

------------------------------------

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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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/linksYahoo! Groups Links

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

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5149 - Release Date: 07/23/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5149 - Release Date: 07/23/12

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

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

system · July 23, 2012, 9:59am

I am into writing a custom crystal report that I need to figure out which tables to use to find the total cost of a "Project". We have multiple jobs within a "Project" that I need to find the individual "job's" cost (material, labor, overhead, subcontract). Can anyone point me in the right direction as to which tables in Vantage might contain this information or how I might get to this data? Thanks in advance!

Mike..

system · July 23, 2012, 10:16am

Mike,

Try looking in the JobAsmbl table. This will contain Lower Level and This Level Actual Costs related to a job.

________________________________
From: flexial_ma <mike.abell@...>
To: vantage@yahoogroups.com
Sent: Monday, July 23, 2012 9:59 AM
Subject: [Vantage] Report tables needed to figure out cost of a project (Vantage 8.03)

I am into writing a custom crystal report that I need to figure out which tables to use to find the total cost of a "Project".Â We have multiple jobs within a "Project" that I need to find the individual "job's" cost (material, labor, overhead, subcontract).Â Can anyone point me in the right direction as to which tables in Vantage might contain this information or how I might get to this data?Â Thanks in advance!

Mike..

------------------------------------

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/.%c2%a0
(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/linksYahoo! Groups Links

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

system · July 23, 2012, 10:51am

Thanks Ted, but how do I link this table back to a "Project" ID. I'm trying
to find out the costs of a "project" that has many jobs associated with it.
Not sure how what tables link "projects" and "jobs". Any ideas?

Mike..

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ted Koch
Sent: Monday, July 23, 2012 9:17 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Mike,

Try looking in the JobAsmbl table. This will contain Lower Level and This
Level Actual Costs related to a job.

________________________________
From: flexial_ma <mike.abell@...
<mailto:mike.abell%40kingston-asfc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Monday, July 23, 2012 9:59 AM
Subject: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

I am into writing a custom crystal report that I need to figure out which
tables to use to find the total cost of a "Project". We have multiple jobs
within a "Project" that I need to find the individual "job's" cost
(material, labor, overhead, subcontract). Can anyone point me in the right
direction as to which tables in Vantage might contain this information or
how I might get to this data? Thanks in advance!

Mike..

------------------------------------

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/.
<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/linksYahoo! Groups Links

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

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

system · July 23, 2012, 11:07am

Project ID is stored in JobHead. Link JobAsmbl to JobHead and there's your
ProjectID.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Abell
Sent: Monday, July 23, 2012 10:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Thanks Ted, but how do I link this table back to a "Project" ID. I'm trying
to find out the costs of a "project" that has many jobs associated with it.
Not sure how what tables link "projects" and "jobs". Any ideas?

Mike..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ted Koch
Sent: Monday, July 23, 2012 9:17 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

Mike,

Try looking in the JobAsmbl table. This will contain Lower Level and This
Level Actual Costs related to a job.

________________________________
From: flexial_ma <mike.abell@...
<mailto:mike.abell%40kingston-asfc.com>
<mailto:mike.abell%40kingston-asfc.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Monday, July 23, 2012 9:59 AM
Subject: [Vantage] Report tables needed to figure out cost of a project
(Vantage 8.03)

I am into writing a custom crystal report that I need to figure out which
tables to use to find the total cost of a "Project". We have multiple jobs
within a "Project" that I need to find the individual "job's" cost
(material, labor, overhead, subcontract). Can anyone point me in the right
direction as to which tables in Vantage might contain this information or
how I might get to this data? Thanks in advance!

Mike..

------------------------------------

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/.
<http://groups.yahoo.com/group/vantage/files/>
<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/linksYahoo! Groups Links

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

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5149 - Release Date: 07/23/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5149 - Release Date: 07/23/12

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