Business Activity Manager - Alert on Reopen Jobs

Yahoo Archive
1
Aaron,

Thanks, I got it with JobHead.Closed = False and JobHead.JobReleased = Yes,
and that's what I was going after anyway. Quality reopens jobs for DMR
transaction, reopening jobs puts them back out on datacollection stations.
That is the problem I'm going after. I didn't want a reopened job showing up
in datacollection.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, October 18, 2004 12:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Manager - Alert on Reopen Jobs.


Patrick,

Try this for your if statement...
IF JobHead.JobClosed = FALSE and OLDJobHead.JobClosed = True

You can also use Cancel Send to prevent the send instead of creating an
error.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Monday, October 18, 2004 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Manager - Alert on Reopen Jobs.



Issue: I would like to create an alert when a job is reopened but not send
the alert when a new job is entered which also triggers the event.

This is the procedure I created from epicor sample on credit hold change.

Notice I include the Job Number and User name in the title unlike epicor's
version.

So again how to I skip new jobs. I just want ones once marked closed then
changed to OPEN to send the alert?


/* Program to send a global alert on Reopening a Job by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "JobHead"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF JobHead.JobClosed = FALSE
THEN DO:
ASSIGN Email-Subject = JobHead.JobNum + " opened by " + USERID.
ASSIGN Email-Text = "The attached job has been reopened or is new!".
END.
ELSE DO:
RETURN ERROR.
END.


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



[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











------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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
2
Issue: I would like to create an alert when a job is reopened but not send
the alert when a new job is entered which also triggers the event.

This is the procedure I created from epicor sample on credit hold change.

Notice I include the Job Number and User name in the title unlike epicor's
version.

So again how to I skip new jobs. I just want ones once marked closed then
changed to OPEN to send the alert?


/* Program to send a global alert on Reopening a Job by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "JobHead"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF JobHead.JobClosed = FALSE
THEN DO:
ASSIGN Email-Subject = JobHead.JobNum + " opened by " + USERID.
ASSIGN Email-Text = "The attached job has been reopened or is new!".
END.
ELSE DO:
RETURN ERROR.
END.


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



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

Try this for your if statement...
IF JobHead.JobClosed = FALSE and OLDJobHead.JobClosed = True

You can also use Cancel Send to prevent the send instead of creating an
error.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Monday, October 18, 2004 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Manager - Alert on Reopen Jobs.



Issue: I would like to create an alert when a job is reopened but not send
the alert when a new job is entered which also triggers the event.

This is the procedure I created from epicor sample on credit hold change.

Notice I include the Job Number and User name in the title unlike epicor's
version.

So again how to I skip new jobs. I just want ones once marked closed then
changed to OPEN to send the alert?


/* Program to send a global alert on Reopening a Job by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "JobHead"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF JobHead.JobClosed = FALSE
THEN DO:
ASSIGN Email-Subject = JobHead.JobNum + " opened by " + USERID.
ASSIGN Email-Text = "The attached job has been reopened or is new!".
END.
ELSE DO:
RETURN ERROR.
END.


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



[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