Pulling details to Job Traveler

Hi Ben,

I'm not exactly sure what you are asking... on job subcontracting
operations, those fields are:

JobOper.DaysOut
JobOper.EstUnitCost

But it sounds like you already knew that?

-Sarah

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Thursday, August 24, 2006 4:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Pulling details to Job Traveler

New challenge.... I would like to show the "Days Out" and the "Est Unit
Cost" on the job traveler for those operations that are Outside
Processes.



I am comfortable using the subreport in crystal, but I need to know
where to find the data.



Here is the confusing part. When a job is converted from a sales order,
I assume it pulls the details from the quote, and not the part master.
(Please correct me if I am wrong.) When this happens, where do the "Days
Out" and "Est. Unit Cost" values reside on the Job (which table(s))?



I've been messing with this thing for a while now, but I am sure there
is an easy answer.



Help would be much appreciated!



Thanks!

Ben





Ben Belzer

Manager
Inside Sales

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>







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



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/.
(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/links
Yahoo! Groups Links
New challenge.... I would like to show the "Days Out" and the "Est Unit
Cost" on the job traveler for those operations that are Outside
Processes.



I am comfortable using the subreport in crystal, but I need to know
where to find the data.



Here is the confusing part. When a job is converted from a sales order,
I assume it pulls the details from the quote, and not the part master.
(Please correct me if I am wrong.) When this happens, where do the "Days
Out" and "Est. Unit Cost" values reside on the Job (which table(s))?



I've been messing with this thing for a while now, but I am sure there
is an easy answer.



Help would be much appreciated!



Thanks!

Ben





Ben Belzer

Manager
Inside Sales

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>







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