Job Cost Info 4.0

Yahoo Archive
1
Sarah,
Could you email a copy to me also! Thanks!!!!! Kimberly

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 10:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

I have a report which calculates this for open jobs,
let me know if you want it.

Sarah


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
2
Anyone know which table stores all the cost info showing up on the job cost
screen in Job Tracker? Or is this a calculated field every time I click on
"Cost" in the tracker? Or what fields make up this calculation so I can
write a report? Or does anybody already have a report showing these totals
in detail by job or in summary for all open jobs?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com
3
Terry, these are calculated fields. However, the totals per job assembly
are stored
in the JobAssmbl table. There are fields for 'This Level' (the totals for
this assembly) and fields for
'Lower Level' (Total of all lower assemblies). An easy way to get totals
for the job is to link the jobhead to
the job assembl and then filter on Ass# = 0. Then create a calculated field
which adds together, for example to get total job labor, the 'TLALabor' +
'LLALabor' (This level actual labor +
Lower Level Actual Labor). This would give you the total Labor for all
assemblies on the job. I have a report which calculates this for open jobs,
let me know if you want it.

HTH,

Sarah
4
Try starting with with the JobAsmbl.TLELaborCost , JobAsmbl.TLEMaterialCost,
ETC Fields.

Ron Newell
Neon Products
-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Tuesday, January 09, 2001 9:47 AM
To: vantage@egroups.com
Subject: [Vantage] Job Cost Info 4.0

Anyone know which table stores all the cost info showing up on the job cost
screen in Job Tracker? Or is this a calculated field every time I click on
"Cost" in the tracker? Or what fields make up this calculation so I can
write a report? Or does anybody already have a report showing these totals
in detail by job or in summary for all open jobs?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
5
Sarah:
The report you sent was exactly what I was looking for. It is good to
know, though that I was on the right track with a rough report I was working
on. You saved me a ton of time. Thank God for egroups.

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 11:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

Terry, these are calculated fields. However, the totals per job assembly
are stored
in the JobAssmbl table. There are fields for 'This Level' (the totals for
this assembly) and fields for
'Lower Level' (Total of all lower assemblies). An easy way to get totals
for the job is to link the jobhead to
the job assembl and then filter on Ass# = 0. Then create a calculated field
which adds together, for example to get total job labor, the 'TLALabor' +
'LLALabor' (This level actual labor +
Lower Level Actual Labor). This would give you the total Labor for all
assemblies on the job. I have a report which calculates this for open jobs,
let me know if you want it.

HTH,

Sarah

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
6
Sarah,

Could you send me a copy of your report also. That is exactly what we
have discussed as our primary needs.
Thanks in advance.

Steve

-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 11:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

Terry, these are calculated fields. However, the totals per job
assembly
are stored
in the JobAssmbl table. There are fields for 'This Level' (the
totals for
this assembly) and fields for
'Lower Level' (Total of all lower assemblies). An easy way to
get totals
for the job is to link the jobhead to
the job assembl and then filter on Ass# = 0. Then create a
calculated field
which adds together, for example to get total job labor, the
'TLALabor' +
'LLALabor' (This level actual labor +
Lower Level Actual Labor). This would give you the total Labor
for all
assemblies on the job. I have a report which calculates this
for open jobs,
let me know if you want it.

HTH,

Sarah

We no longer allow attachments to files. To access/share Report
Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)
7
Sarah-

I would also appreciate a copy. Deeply. Thanks for sharing.

Lydia
lcoffman@...

-----Original Message-----
From: Steve Wirtz [mailto:SWirtz@...]
Sent: Tuesday, January 09, 2001 10:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Job Cost Info 4.0

Sarah,

Could you send me a copy of your report also. That is exactly what we
have discussed as our primary needs.
Thanks in advance.

Steve

-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 11:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

Terry, these are calculated fields. However, the totals per job
assembly
are stored
in the JobAssmbl table. There are fields for 'This Level' (the
totals for
this assembly) and fields for
'Lower Level' (Total of all lower assemblies). An easy way to
get totals
for the job is to link the jobhead to
the job assembl and then filter on Ass# = 0. Then create a
calculated field
which adds together, for example to get total job labor, the
'TLALabor' +
'LLALabor' (This level actual labor +
Lower Level Actual Labor). This would give you the total Labor
for all
assemblies on the job. I have a report which calculates this
for open jobs,
let me know if you want it.

HTH,

Sarah

We no longer allow attachments to files. To access/share Report
Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
8
ditto for me if possible

-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Tuesday, January 09, 2001 1:31 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0


Sarah-

I would also appreciate a copy. Deeply. Thanks for sharing.

Lydia
lcoffman@...

-----Original Message-----
From: Steve Wirtz [mailto:SWirtz@...]
Sent: Tuesday, January 09, 2001 10:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Job Cost Info 4.0

Sarah,

Could you send me a copy of your report also. That is exactly what we
have discussed as our primary needs.
Thanks in advance.

Steve

-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 11:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

Terry, these are calculated fields. However, the totals per job
assembly
are stored
in the JobAssmbl table. There are fields for 'This Level' (the
totals for
this assembly) and fields for
'Lower Level' (Total of all lower assemblies). An easy way to
get totals
for the job is to link the jobhead to
the job assembl and then filter on Ass# = 0. Then create a
calculated field
which adds together, for example to get total job labor, the
'TLALabor' +
'LLALabor' (This level actual labor +
Lower Level Actual Labor). This would give you the total Labor
for all
assemblies on the job. I have a report which calculates this
for open jobs,
let me know if you want it.

HTH,

Sarah

We no longer allow attachments to files. To access/share Report
Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
9
Sarah,
Could you also e-mail a copy of your report to me?
Thanks!
Nora Story
Spectra Technologies, Inc.
Nora_Story@...

-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Tuesday, January 09, 2001 10:04 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Job Cost Info 4.0

I have a report which calculates this for open jobs,
let me know if you want it.

Sarah