BAM Class 101 - remedial help

I uploaded POReleaseSuspenseReminder.P. It fires off the PORel.ExpChart
field.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Monday, February 28, 2005 5:39 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


I'm using it for new parts, too, so that inventory control has an
opportunity to validate the time-phase-related characteristics as soon
as a
part is created. I've also created BAM alerts for new orders (to notify
engineering admin), new job headers (to notify the job planner) and new
vendors (to notify quality control). So far, personnel responses have
been
mostly positive. Would you mind posting your BAM for PO releases
pointing
to a suspense account to our group file section?

In order for the line feed/carriage return to work properly, must the ~n
be
included in quotes?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Saturday, February 26, 2005 12:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

Glad it helped Scott. I use that feature to send notifications/messages
of new part additions, new requisitions (notify the approver that they
need to check their to do list), etc. I recently wrote a BAM to display
a message to the user if the PO Rel line GL Chart is pointing to a
suspense account.

I'm sure someone will know the true meaning of the U function but the ~n
causes a Line Feed Carriage Return.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 2:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

Thanks Butch and Patrick for your replies. Butch, your reply did the
trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply,
it
finally dawned on me that I was already setting the condition by
monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body
of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of
"U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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 Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129gdo6u1/M=298184.6018725.7038619.3001176/
D=groups/S=1705007183:HM/EXP=1109684342/A=2593423/R=0/SIG=11el9gslf/*htt
p://www.netflix.com/Default?mqso=60190075>

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

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
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! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has worked
pretty well (the exceptions being those tables for which Vantage will not
attach an alert.vdl). However, trying to write alert programs has been a
completely different matter, even with Epicor's sample .p files; not one has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone suggest to
me how to look for only new records, e.g. new RMA's, and send an alert when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p to be
safe.
If I am not mistaken, your logic is missing the second if statement unless
the Part table is not available, the opposite of what you are looking for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



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

How about:
IF RMAHead.RMADate = Today
THEN DO:


Patrick Winter


-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 2:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has worked
pretty well (the exceptions being those tables for which Vantage will not
attach an alert.vdl). However, trying to write alert programs has been a
completely different matter, even with Epicor's sample .p files; not one has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone suggest to
me how to look for only new records, e.g. new RMA's, and send an alert when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p to be
safe.
If I am not mistaken, your logic is missing the second if statement unless
the Part table is not available, the opposite of what you are looking for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I can't get
it to work. What I want is to send an alert when a part is received that
has a specific Material Analysis Code in the Part table. The code in
question is "ECN". (We are trying to improve part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum NO-LOCK
NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still don't
receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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
One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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


* To visit your group on the web, go to:
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! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Thanks Butch and Patrick for your replies. Butch, your reply did the trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply, it
finally dawned on me that I was already setting the condition by monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of "U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[Non-text portions of this message have been removed]
Glad it helped Scott. I use that feature to send notifications/messages
of new part additions, new requisitions (notify the approver that they
need to check their to do list), etc. I recently wrote a BAM to display
a message to the user if the PO Rel line GL Chart is pointing to a
suspense account.

I'm sure someone will know the true meaning of the U function but the ~n
causes a Line Feed Carriage Return.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 2:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


Thanks Butch and Patrick for your replies. Butch, your reply did the
trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply,
it
finally dawned on me that I was already setting the condition by
monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body
of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of
"U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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 Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129arotvp/M=298184.6018725.7038619.3001176/
D=groups/S=1705007183:HM/EXP=1109455803/A=2593423/R=0/SIG=11el9gslf/*htt
p://www.netflix.com/Default?mqso=60190075>

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

________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
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! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Scott,
The reason the message did not change even though the code did is that you
will need to restart Vantage on the client in order to have it recompile the
code when the BAM is called. Per session each BAM .p is compiled only once.
When you restart the client, it will compile a new version.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 5:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help



Thanks Butch and Patrick for your replies. Butch, your reply did the trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply, it
finally dawned on me that I was already setting the condition by monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of "U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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
I'm using it for new parts, too, so that inventory control has an
opportunity to validate the time-phase-related characteristics as soon as a
part is created. I've also created BAM alerts for new orders (to notify
engineering admin), new job headers (to notify the job planner) and new
vendors (to notify quality control). So far, personnel responses have been
mostly positive. Would you mind posting your BAM for PO releases pointing
to a suspense account to our group file section?

In order for the line feed/carriage return to work properly, must the ~n be
included in quotes?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Saturday, February 26, 2005 12:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

Glad it helped Scott. I use that feature to send notifications/messages
of new part additions, new requisitions (notify the approver that they
need to check their to do list), etc. I recently wrote a BAM to display
a message to the user if the PO Rel line GL Chart is pointing to a
suspense account.

I'm sure someone will know the true meaning of the U function but the ~n
causes a Line Feed Carriage Return.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 2:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

Thanks Butch and Patrick for your replies. Butch, your reply did the
trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply,
it
finally dawned on me that I was already setting the condition by
monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body
of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of
"U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[Non-text portions of this message have been removed]
BINGO! THANK YOU, AARON!

I had called Vantage Support about this before posting my message. The
suggestion from there was to try stopping and restarting Process Server.

Regards,
Scott

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 28, 2005 8:10 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

Scott,
The reason the message did not change even though the code did is that you
will need to restart Vantage on the client in order to have it recompile the
code when the BAM is called. Per session each BAM .p is compiled only once.
When you restart the client, it will compile a new version.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 5:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help



Thanks Butch and Patrick for your replies. Butch, your reply did the trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply, it
finally dawned on me that I was already setting the condition by monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of "U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help


OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[Non-text portions of this message have been removed]
Scott,
Yes the ~n must be in quotes, and I find it beneficial to add a space
before. I don't know why on that, but it seems to be more reliable " ~n".
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Monday, February 28, 2005 8:39 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help



I'm using it for new parts, too, so that inventory control has an
opportunity to validate the time-phase-related characteristics as soon as a
part is created. I've also created BAM alerts for new orders (to notify
engineering admin), new job headers (to notify the job planner) and new
vendors (to notify quality control). So far, personnel responses have been
mostly positive. Would you mind posting your BAM for PO releases pointing
to a suspense account to our group file section?

In order for the line feed/carriage return to work properly, must the ~n be
included in quotes?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Saturday, February 26, 2005 12:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

Glad it helped Scott. I use that feature to send notifications/messages
of new part additions, new requisitions (notify the approver that they
need to check their to do list), etc. I recently wrote a BAM to display
a message to the user if the PO Rel line GL Chart is pointing to a
suspense account.

I'm sure someone will know the true meaning of the U function but the ~n
causes a Line Feed Carriage Return.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, February 25, 2005 2:10 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

Thanks Butch and Patrick for your replies. Butch, your reply did the
trick;
as I figured, it was quite simple. I had already limited the BAM to the
RMANum field only, but I was thinking that I still needed to specify a
selection condition in the alert program. The moment I read your reply,
it
finally dawned on me that I was already setting the condition by
monitoring
only that particular field. Doh!

Now I have another couple of questions. Has anyone else seen the body
of
global alert messages NOT changing even though the text specified in the
alert program (.p) was changed? Can someone explain the functions of
"U"
and "~n"?

Regards,
Scott

-----Original Message-----
From: Butch Menge [mailto:bmenge@...]
Sent: Wednesday, February 23, 2005 4:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101 - remedial help

One option would be to fire the BAM on the field RMANum in the RMAHead
table (only select that field). That RMANum field should only be
modified once - when it is created.

Butch

________________________________

From: Lepley, Scott A. [mailto:sal@...]
Sent: Wednesday, February 23, 2005 12:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM Class 101 - remedial help

OK, I am right there with Michael with these BAM's. Creating them and
configuring them to append log text and attach alert.vdl files has
worked
pretty well (the exceptions being those tables for which Vantage will
not
attach an alert.vdl). However, trying to write alert programs has been
a
completely different matter, even with Epicor's sample .p files; not one
has
worked yet.

This may be very simple, but I'm just not seeing it. Can someone
suggest to
me how to look for only new records, e.g. new RMA's, and send an alert
when
they are entered?

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: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 21, 2005 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Class 101

Michael,
Try ending your if after the not available.
and also end the else statement at the end.
I would also assign the email "to" with an email address within the .p
to be
safe.
If I am not mistaken, your logic is missing the second if statement
unless
the Part table is not available, the opposite of what you are looking
for.
Also, I don't believe you need to call out the full name of Mfgsys.Part,
just Part should do, the database is assumed.
I suspect this will fix most of the problems.
For instance:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Part WHERE Part.PartNum = RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Part THEN RETURN "Cancel Send":U.
END.

IF (Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item"
Email-To = "insert the email address here".

END.
ELSE RETURN "Cancel Send":U.
END.

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: ami_miker [mailto:michael.randolph@...]
Sent: Monday, February 21, 2005 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Class 101

OK folks, I need some help with my first BAM. It is simple, but I
can't get it to work. What I want is to send an alert when a part
is received that has a specific Material Analysis Code in the Part
table. The code in question is "ECN". (We are trying to improve
part of our ECN process.)

What I have written (copying from the samples) is:

{ud/GlbAlert.i &TableName = "RcvDtl"}

FIND Mfgsys.Part WHERE Mfgsys.Part.PartNum = Mfgsys.RcvDtl.PartNum
NO-LOCK NO-ERROR.

IF NOT AVAILABLE Mfgsys.Part THEN RETURN "Cancel Send":U.

IF (Mfgsys.Part.Mtl-AnalysisCode = "ECN":U) THEN DO:

ASSIGN Email-Subject = "ECN Critical Item".

END.
ELSE RETURN "Cancel Send":U.

I have worked on this until I no longer get any errors, but I still
don't receive the email. Any suggestions for a Progress newbie?
Perhaps the code is OK, but I am doing something wrong on the BAM.

Thanks,
Michael Randolph
Purchasing Manager
American Magnetics, Inc.



[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