Job Closing

Yahoo Archive
1
I was wondering if anybody had a progress program or macro which
facilitates closing of jobs. Ideally it would read a text file or
file of some format containing job numbers. These job numbers would
be marked complete and closed with the appropriate dates in one mass
closure. Getting the selected jobs we want to close into a separate
file is the easy part, closing hundreds of jobs one at a time is a
waste of time. Any ideas?

Thanks

Keith
2
I think this will do the trick for you. This is for Vantage 5.1

If you go to http://www.ktcorp.com/vantage/jobclose/ you will find a screen
shot, Winbatch Script and an Access database.
You will need to download Winbatch from www.winbatch.com

Steps to run,
Replace the linked jobhead table with a table or query with the jobs you
want closed.
Open the Access form FORM1 (The first job in your list should appear in the
text box, place the focus on that text box)
Open the Job Closing screen in Vantage.
Open the Wil script and change the counter variable to the number of jobs
you are closing
Run the Wil Script.

The script will:
1)Copy the job number from Access 2000 into the windows clipboard.
2)Paste the job number from the clipboard into the lookup screen in Vantage
3)Mark the job complete
4)Answer Yes if the qty complete is less then the production qty
5)Mark the job closed
6)Close the screen
7)Return to Access 2000
8)Start the loop over

I hope this helps. Winbatch is very easy to use. One of the best help
packages I have ever used. Their website is packed with allot of great
examples. I am sure it will need some tweaking but I think you will get the
idea. There are allot of things you can do to customize the program. If
you have any questions feel free to contact me.

Thanks
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
jleonard@...


-----Original Message-----
From: kmailloux1959 [mailto:kmailloux@...]
Sent: Thursday, November 14, 2002 4:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Closing


I was wondering if anybody had a progress program or macro which
facilitates closing of jobs. Ideally it would read a text file or
file of some format containing job numbers. These job numbers would
be marked complete and closed with the appropriate dates in one mass
closure. Getting the selected jobs we want to close into a separate
file is the easy part, closing hundreds of jobs one at a time is a
waste of time. Any ideas?

Thanks

Keith



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
3
What is the best process for Job Closing?

We complete the jobs in the Job Closing module the day they ship,
but we do not close the jobs right away because I was told we can no
longer apply costs (ie freight, outside process etc) to it once it
is closed.

Can I reopen the jobs to do this? What is the best process?

Thanks!
Ben
4
This would depend on a few other things... you can reopen a job It mostly depends on if you put items to storage or ship from manufacturing... standard costing or actual...

-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Tuesday, February 01, 2005 6:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Closing




What is the best process for Job Closing?

We complete the jobs in the Job Closing module the day they ship,
but we do not close the jobs right away because I was told we can no
longer apply costs (ie freight, outside process etc) to it once it
is closed.

Can I reopen the jobs to do this? What is the best process?

Thanks!
Ben





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
5
Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper



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



Job Entry

Job

View Change Log

Profit!



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, October 16, 2007 11:01 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Job Closing



Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper

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





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

If you look in the change log for a particular job it will tell you what
user ID closed the job.



Paul



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, October 16, 2007 10:01 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Job Closing



Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper

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





[Non-text portions of this message have been removed]
8
In order for it to be in the change log, I must first set up the change log. Which table should I be checking on and which fields?

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Paul Wetherington
Sent: Tuesday, October 16, 2007 1:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Closing



Jasper-

If you look in the change log for a particular job it will tell you what
user ID closed the job.

Paul

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Tuesday, October 16, 2007 10:01 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Job Closing

Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper

[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]
9
This feature has to be activated in Business Activity Manager.


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Paul Wetherington
Sent: Tuesday, October 16, 2007 1:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Closing

Jasper-

If you look in the change log for a particular job it will tell you what
user ID closed the job.

Paul

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Jasper Recto
Sent: Tuesday, October 16, 2007 10:01 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Job Closing

Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper

[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]
10
JobHead table and JobClosed field

Brandon Murch
WindStone Medical Packaging, Inc.
Supervisor of Information Technology
(406)259-6387
bmurch@...
www.windstonemedical.com


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Tuesday, October 16, 2007 10:54 AM
To: 'vantage@yahoogroups.com'
Subject: RE: RE: [Vantage] Job Closing

In order for it to be in the change log, I must first set up the change
log. Which table should I be checking on and which fields?

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Paul Wetherington
Sent: Tuesday, October 16, 2007 1:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Job Closing



Jasper-

If you look in the change log for a particular job it will tell you what
user ID closed the job.

Paul

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:
vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Tuesday, October 16, 2007 10:01 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Job Closing

Is there a way to find out who closed a job?

If not, is there something in the logs that can track that?

Thanks,
Jasper

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



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



***********************************************************************
Privileged and/or confidential information may be contained in
this message. If you are not the addressee indicated in this
message (or are not responsible for delivery of this message to that person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and
notify the sender by reply e-mail. If you or your employer do
not consent to Internet e-mail for messages of this kind,
please advise the sender. Windstone Medical Packaging,
Inc. does not provide or endorse any opinions, conclusions
or other information in this message that do not relate to the
official business of the company.
***********************************************************************