Job Creation Date

Yes,
But THEN if you'll need to analyze all Jobs regarding this date - it
won't be an easy way. This is because the change log stores
information not as it should. Without the PIECE of code how to
disassembly information from ChgLog.LogText you'll need to write your
own code to aquire the data from log. i.e. 4GL procedure :).

*********************
PLEASE USE 'Reply to ALL' functionality - so I don't need to search
through all new posts in Vantage group to be able to answer your
question
*********************

regards

Grzegorz Szczepański

Dnia Wed, 20 May 2009 14:07:40 -0700 (PDT)
Robert Brown <robertb_versa@...> napisał(a):

> Dave
> You'll need to set up change logging (JobNum, JobEngineered,
> JobReleased in JobHead) to capture those dates. Rob
>
>
>
>
> ________________________________
> From: ofcwiz <DavidH@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, May 20, 2009 4:10:09 PM
> Subject: [Vantage] Job Creation Date
>
>
>
>
>
> I'm unable to find a date field related to when a Job was created.
> All the dates I can find are changeable through scheduling or Job
> Entry. Any ideas? Ideally I'm looking for an "Engineered" date and a
> "Released" date.
>
> Thanks,
> Dave
> 8.03.407C P
> Xybix
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
How do I tell when a job was created? Sales creates the job number for
custom items when the order is entered. Engineering may not get the order
for several days. We are trying to see how long it takes from order
entry/job creation until the paperwork is pulled and sent back to
engineering.

Any ideas?

Mitchell Kirby
Riten Industries, Inc.

740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX
We have the same issue. I use CorVu to create reports. We use the VB form in job entry to acknowledge start dates. We have an acknowledged date in the VB form. I have used that date. It has been suggested to add a date field in job entry. It would have to be manually entered. If anybody has a good way to get the job creation date out of vantage, I would be interested also. Right now, I just have a work around.

Thanks,

Tom Ford
Mid-West Spring

-----Original Message-----
From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Thursday, February 24, 2005 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date



How do I tell when a job was created? Sales creates the job number for
custom items when the order is entered. Engineering may not get the order
for several days. We are trying to see how long it takes from order
entry/job creation until the paperwork is pulled and sent back to
engineering.

Any ideas?

Mitchell Kirby
Riten Industries, Inc.

740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX



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
You can track when a job was created by enabling change logging on
JobHead.JobNum. You can then extract the job creation date from
ChgLog.Key1.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.518

-----Original Message-----
From: Tom Ford [mailto:tford@...]
Sent: Thursday, February 24, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Creation Date

We have the same issue. I use CorVu to create reports. We use the VB form
in job entry to acknowledge start dates. We have an acknowledged date in
the VB form. I have used that date. It has been suggested to add a date
field in job entry. It would have to be manually entered. If anybody has a
good way to get the job creation date out of vantage, I would be interested
also. Right now, I just have a work around.

Thanks,

Tom Ford
Mid-West Spring

-----Original Message-----
From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Thursday, February 24, 2005 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date

How do I tell when a job was created? Sales creates the job number for
custom items when the order is entered. Engineering may not get the order
for several days. We are trying to see how long it takes from order
entry/job creation until the paperwork is pulled and sent back to
engineering.

Any ideas?

Mitchell Kirby
Riten Industries, Inc.

740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX



[Non-text portions of this message have been removed]
Oops, wrong! I meant to write filtering on ChgLog.Key1, not extracting from
ChgLog.Key1.

Regards,
Scott

-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Thursday, February 24, 2005 11:54 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Job Creation Date

You can track when a job was created by enabling change logging on
JobHead.JobNum. You can then extract the job creation date from
ChgLog.Key1.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.518

-----Original Message-----
From: Tom Ford [mailto:tford@...]
Sent: Thursday, February 24, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Creation Date

We have the same issue. I use CorVu to create reports. We use the VB form
in job entry to acknowledge start dates. We have an acknowledged date in
the VB form. I have used that date. It has been suggested to add a date
field in job entry. It would have to be manually entered. If anybody has a
good way to get the job creation date out of vantage, I would be interested
also. Right now, I just have a work around.

Thanks,

Tom Ford
Mid-West Spring

-----Original Message-----
From: Mitchell Kirby [mailto:m.kirby@...]
Sent: Thursday, February 24, 2005 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date

How do I tell when a job was created? Sales creates the job number for
custom items when the order is entered. Engineering may not get the order
for several days. We are trying to see how long it takes from order
entry/job creation until the paperwork is pulled and sent back to
engineering.

Any ideas?

Mitchell Kirby
Riten Industries, Inc.

740-333-8719 Direct
800-338-0027 Sales
800-338-0717 FAX



[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=1294e9n2c/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705007183:HM/EXP=1109350500/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here


<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
:HM/A=2593423/rand=402076017>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
There appears to be no field that stores the date a job was actually
created.

I am trying to determine how long a job sits before it is marked
engineered.

Any ideas?

Thanks!
Did you look at JobAudit?


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bbelzer42
Sent: Thursday, May 22, 2008 11:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date



There appears to be no field that stores the date a job was actually
created.

I am trying to determine how long a job sits before it is marked
engineered.

Any ideas?

Thanks!






[Non-text portions of this message have been removed]
On 8.03.404 it exists (end we are displaying it in our customized Job Entry). The table.column is JobHead.CreateDate.

For what you are doing, try turning audit logging on for this and JobHead.JobEngineered. You can then probably right a report to sift through the audit logs and do stats on the time between job creation and when they are engineered.

If you use MRP with the schedule unfirmed jobs option, JobHead.JobFirm should also be set up for audit logging as the logged date of firming then becomes the critical comparitive date (since the unfirmed jobs are engineered when MRP creates them).

Rob Brown

--- On Thu, 5/22/08, bbelzer42 <bbelzer@...> wrote:

From: bbelzer42 <bbelzer@...>
Subject: [Vantage] Job Creation Date
To: vantage@yahoogroups.com
Date: Thursday, May 22, 2008, 11:45 AM






There appears to be no field that stores the date a job was actually
created.

I am trying to determine how long a job sits before it is marked
engineered.

Any ideas?

Thanks!
I'm on 6.1, and I tried the JobAudit table, except when a job is first
created, there is no audit logged in. Only after it is marked as
engineered...

I also tried the chglog table, except my system freezes anytime I try
to access that table...
If you have turned on the change log for the JobHead table then the
first entry in the change log will be the date it was created. The
Identifier and the TableName fields will both be "JobHead". Key1 will
be the Job Number. I don't know of any other way to get that
information.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bbelzer42
Sent: Thursday, May 22, 2008 10:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date



There appears to be no field that stores the date a job was actually
created.

I am trying to determine how long a job sits before it is marked
engineered.

Any ideas?

Thanks!





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



We had to do a report that required information that only seems to exist in
the log file, I ended up doing a query from VB6 to get the recordset I
wanted details for then another query based on this to search the log for
the specific bits of info we needed, this was then dumped to a csv file so
we could open it up direct with excel. The biggest problem is that the logs
can get very large and depending on what you are looking for the last query
can take some time to run. I am doing for every job closed last month when
was it entered (may be a long time ago), when was it first scheduled and
when was it requested for etc.



Tim Stevenson



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Friday, 23 May 2008 11:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Creation Date



If you have turned on the change log for the JobHead table then the
first entry in the change log will be the date it was created. The
Identifier and the TableName fields will both be "JobHead". Key1 will
be the Job Number. I don't know of any other way to get that
information.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of bbelzer42
Sent: Thursday, May 22, 2008 10:45 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Job Creation Date

There appears to be no field that stores the date a job was actually
created.

I am trying to determine how long a job sits before it is marked
engineered.

Any ideas?

Thanks!

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





[Non-text portions of this message have been removed]
I'm unable to find a date field related to when a Job was created. All the dates I can find are changeable through scheduling or Job Entry.
Any ideas?
Ideally I'm looking for an "Engineered" date and a "Released" date.

Thanks,
Dave
8.03.407C P
Xybix
Those two fields can definitely change throughout the life of a job. Im
thinking about a BPM or a BAM with an attachment file to permanently
store those values to a UD field the first time a job is engineered and
or released... we are working on some MCT stuff here where that would
definitely be of some use.



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ofcwiz
Sent: Wednesday, May 20, 2009 3:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Creation Date





I'm unable to find a date field related to when a Job was created. All
the dates I can find are changeable through scheduling or Job Entry.
Any ideas?
Ideally I'm looking for an "Engineered" date and a "Released" date.

Thanks,
Dave
8.03.407C P
Xybix





[Non-text portions of this message have been removed]
Dave
You'll need to set up change logging (JobNum, JobEngineered, JobReleased in JobHead) to capture those dates.
Rob




________________________________
From: ofcwiz <DavidH@...>
To: vantage@yahoogroups.com
Sent: Wednesday, May 20, 2009 4:10:09 PM
Subject: [Vantage] Job Creation Date





I'm unable to find a date field related to when a Job was created. All the dates I can find are changeable through scheduling or Job Entry.
Any ideas?
Ideally I'm looking for an "Engineered" date and a "Released" date.

Thanks,
Dave
8.03.407C P
Xybix







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