BAM problem

Yahoo Archive
1
Dick,
I would make these modifications and see if that works for you.
I am sending cc to you to make sure the RTF highlights of my changes come
through.

If OLDRMAHead.OpenRMA = TRUE AND RMAHead.OpenRMA <> TRUE
THEN DO:
...
ASSIGN Email-To = "tse-user@...".
...
ASSIGN Email-Subject = "RMA Closed".
...
ASSIGN Email-Text = "RMA Num - " + string(RMAHead.RMANum) +
"~n " + "Customer Name - " + STRING(Customer.NAME).

Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of PLAMAN DICK
Sent: Thursday, May 26, 2005 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM problem


can anyone see why this progress script does not fire an e-mail when the
RMA is closed?
It fires when I detach the script, but I get no information....just the
fact that one of our RMA's was closed.
I really wish that epicor would offer a class in using progress code
with vantage.

thanks in advance.

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND Mfgsys.Customer WHERE (mfgsys.customer.company =
mfgsys.DMRHead.Company)
AND (Mfgsys.Customer.CustNum = mfgsys.RMAHead.CustNum) NO-LOCK
NO-ERROR.

IF RMAHead.OpenRMA = FALSE
THEN DO:
ASSIGN e-mail-to: "tse-user@...
<mailto:tse-user@...> "
ASSIGN Email-Text = "RMA Num - " + string(Mfgsys.RMAHead.RMANum) +
"~n "
"Customer Name - " +
STRING(mfgsys.Customer.NAME).

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



[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








[Non-text portions of this message have been removed]
2
can anyone see why this progress script does not fire an e-mail when the
RMA is closed?
It fires when I detach the script, but I get no information....just the
fact that one of our RMA's was closed.
I really wish that epicor would offer a class in using progress code
with vantage.

thanks in advance.

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND Mfgsys.Customer WHERE (mfgsys.customer.company =
mfgsys.DMRHead.Company)
AND (Mfgsys.Customer.CustNum = mfgsys.RMAHead.CustNum) NO-LOCK
NO-ERROR.

IF RMAHead.OpenRMA = FALSE
THEN DO:
ASSIGN e-mail-to: "tse-user@...
<mailto:tse-user@...> "
ASSIGN Email-Text = "RMA Num - " + string(Mfgsys.RMAHead.RMANum) +
"~n "
"Customer Name - " +
STRING(mfgsys.Customer.NAME).

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



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

There is a handout on the vantageusers.org/vmug website from out last
meeting
instructions for using the BAM/BAQ with sample code. At the User4User
conference
in August there will be a Progress Programming class. More info available
on that
also at the Vantageusers.org site.

regarding your program....

/** _____________program starts__________________________ **/

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.

FIND FIRST Customer WHERE Customer.Company = RMAHead.Company AND
AND Customer.CustNum = RMAHead.CustNum NO-LOCK NO-ERROR.

IF RMAHead.OpenRMA = FALSE THEN DO:
Email-To = "tse-user@...".
Email-Subject = "RMA Closed see message below".
Email-Text = "RMA Number " + string(RMAHead.RMANum) + " was closed. ~n ".
Email-Text = Email-Text + "Customer name on this RMA: " +
Customer.NAME + "~n ".
END.
ELSE DO:
RETURN "Cancel Send":U.
END.
/** _____________program ends___________________________ **/


This should work for ya.

HTH,
Calvin





















-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of PLAMAN DICK
Sent: Thursday, May 26, 2005 7:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM problem


can anyone see why this progress script does not fire an e-mail when the
RMA is closed?
It fires when I detach the script, but I get no information....just the
fact that one of our RMA's was closed.
I really wish that epicor would offer a class in using progress code
with vantage.

thanks in advance.

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

DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND Mfgsys.Customer WHERE (mfgsys.customer.company =
mfgsys.DMRHead.Company)
AND (Mfgsys.Customer.CustNum = mfgsys.RMAHead.CustNum) NO-LOCK
NO-ERROR.

IF RMAHead.OpenRMA = FALSE
THEN DO:
ASSIGN e-mail-to: "tse-user@...
<mailto:tse-user@...> "
ASSIGN Email-Text = "RMA Num - " + string(Mfgsys.RMAHead.RMANum) +
"~n "
"Customer Name - " +
STRING(mfgsys.Customer.NAME).

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



[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