many thanks to Jerry, Patrick, and Aaron for your help.
I would have danced all night without it.
kind regards,
I would have danced all night without it.
kind regards,
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[Non-text portions of this message have been removed]
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[Non-text portions of this message have been removed]
We use a very simple one to add data to the email generated whenever a new
sales order is added. It is a .p file:
{ud/GlbAlert.i &TableName = "OrderHed"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND Mfgsys.Terms WHERE (Mfgsys.Terms.Company = Mfgsys.OrderHed.Company) AND
(Mfgsys.Terms.TermsCode = Mfgsys.OrderHed.TermsCode)
NO-LOCK NO-ERROR.
FIND Mfgsys.Customer WHERE (Mfgsys.Customer.Company =
Mfgsys.OrderHed.Company) AND
(Mfgsys.Customer.CustNum =
Mfgsys.OrderHed.CustNum) NO-LOCK NO-ERROR.
/* Add the order number to the subject line */
ASSIGN Email-Subject = Email-Subject + " number " +
String(Mfgsys.OrderHed.OrderNum).
/* Create the new body of the email */
ASSIGN Email-Text = "Details of new order - ~n~n"
+ " Number - " + String(Mfgsys.OrderHed.OrderNum) + "~n"
+ " Customer - " + Mfgsys.Customer.Name + "~n"
+ " PO Number - " + Mfgsys.OrderHed.PONum + "~n"
+ " Terms - " + Mfgsys.Terms.Description + "~n"
+ " Order Date - " + String(Mfgsys.OrderHed.OrderDate) + "~n"
+ "Need By Date - " + String(Mfgsys.OrderHed.NeedByDate) + "~n".
I used the sample that was in my /mfgsys61/ud folder (they are .i files) to
create it. It works well. I would like to do others but have not been able
to allocate any time to working on them. We also use the "Append Log Text"
option to get data into some other alerts.
Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells the
recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine incorporated to return the
desired values. They do not have an example tho.
Has anyone gone down this road? Do you have any examples?
sales order is added. It is a .p file:
{ud/GlbAlert.i &TableName = "OrderHed"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
FIND Mfgsys.Terms WHERE (Mfgsys.Terms.Company = Mfgsys.OrderHed.Company) AND
(Mfgsys.Terms.TermsCode = Mfgsys.OrderHed.TermsCode)
NO-LOCK NO-ERROR.
FIND Mfgsys.Customer WHERE (Mfgsys.Customer.Company =
Mfgsys.OrderHed.Company) AND
(Mfgsys.Customer.CustNum =
Mfgsys.OrderHed.CustNum) NO-LOCK NO-ERROR.
/* Add the order number to the subject line */
ASSIGN Email-Subject = Email-Subject + " number " +
String(Mfgsys.OrderHed.OrderNum).
/* Create the new body of the email */
ASSIGN Email-Text = "Details of new order - ~n~n"
+ " Number - " + String(Mfgsys.OrderHed.OrderNum) + "~n"
+ " Customer - " + Mfgsys.Customer.Name + "~n"
+ " PO Number - " + Mfgsys.OrderHed.PONum + "~n"
+ " Terms - " + Mfgsys.Terms.Description + "~n"
+ " Order Date - " + String(Mfgsys.OrderHed.OrderDate) + "~n"
+ "Need By Date - " + String(Mfgsys.OrderHed.NeedByDate) + "~n".
I used the sample that was in my /mfgsys61/ud folder (they are .i files) to
create it. It works well. I would like to do others but have not been able
to allocate any time to working on them. We also use the "Append Log Text"
option to get data into some other alerts.
Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells the
recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine incorporated to return the
desired values. They do not have an example tho.
Has anyone gone down this road? Do you have any examples?
Dick,
You will find tons of information in the archive. Look up based on BAM. I
have done extensive work with BAM, most of it either learned through emails
to this list or through use of the Progress Help. I have also passed on
tons of information on how to use the BAM to your benefit. You can create
emails based on whatever text you want (examples for 6.1 are in the
\ud\test). You can also create exports using progress routines, and one of
the latest tricks I am employing is to generate net send messages using a
BAM.
Let me know about specific needs and I will attempt to assist.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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
You will find tons of information in the archive. Look up based on BAM. I
have done extensive work with BAM, most of it either learned through emails
to this list or through use of the Progress Help. I have also passed on
tons of information on how to use the BAM to your benefit. You can create
emails based on whatever text you want (examples for 6.1 are in the
\ud\test). You can also create exports using progress routines, and one of
the latest tricks I am employing is to generate net send messages using a
BAM.
Let me know about specific needs and I will attempt to assist.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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
Aaron,
I have been trying to find information on BAM. I have not used it yet but would like to learn. When you say 'archive', what do you mean by that? What would be the best sources to learn this feature.
Thanks!
Jasper
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Friday, February 04, 2005 8:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V6.0 Business Activity Manager
Dick,
You will find tons of information in the archive. Look up based on BAM. I
have done extensive work with BAM, most of it either learned through emails
to this list or through use of the Progress Help. I have also passed on
tons of information on how to use the BAM to your benefit. You can create
emails based on whatever text you want (examples for 6.1 are in the
\ud\test). You can also create exports using progress routines, and one of
the latest tricks I am employing is to generate net send messages using a
BAM.
Let me know about specific needs and I will attempt to assist.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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
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 have been trying to find information on BAM. I have not used it yet but would like to learn. When you say 'archive', what do you mean by that? What would be the best sources to learn this feature.
Thanks!
Jasper
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Friday, February 04, 2005 8:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V6.0 Business Activity Manager
Dick,
You will find tons of information in the archive. Look up based on BAM. I
have done extensive work with BAM, most of it either learned through emails
to this list or through use of the Progress Help. I have also passed on
tons of information on how to use the BAM to your benefit. You can create
emails based on whatever text you want (examples for 6.1 are in the
\ud\test). You can also create exports using progress routines, and one of
the latest tricks I am employing is to generate net send messages using a
BAM.
Let me know about specific needs and I will attempt to assist.
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 7:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells
the recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine
incorporated to return the desired values. They do not have an example
tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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
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
Dick,
I have done a couple of these.
They both will give you examples of adding meaningful information to the
email.
The first one is for parts were the active / inactive status changes.
/* Program to send a global alert on Active/Inactive Part changes
by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "Part"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF Part.Inactive = FALSE
THEN DO:
ASSIGN Email-Subject = Part.PartNum + " reopened or new part by " +
USERID.
ASSIGN Email-Text = "Part was reopened.".
END.
ELSE DO:
ASSIGN Email-Subject = Part.PartNum + " inactivated by " + USERID.
ASSIGN Email-Text = "Part was inactivated. sSc MPN: " +
Part.Searchword.
END.
/* the end */
This second one sends email when a specific job type is closed.
Jobs that begin with TL which is a tool kit job in our tool room
/* Program to send a global alert on a TL Job when closed
by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "JobHead"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF JobHead.JobClosed = TRUE
AND SUBSTRING(JobHead.JobNum,1,2) = 'TL'
THEN DO:
ASSIGN Email-Subject = JobHead.JobNum + "has been closed by " + USERID.
ASSIGN Email-Text = "The attached tool job has been closed, the tools
are ready!".
END.
ELSE DO:
RETURN ERROR.
END.
/* end */
Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 6:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells the
recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine incorporated to return the
desired values. They do not have an example tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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 have done a couple of these.
They both will give you examples of adding meaningful information to the
email.
The first one is for parts were the active / inactive status changes.
/* Program to send a global alert on Active/Inactive Part changes
by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "Part"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF Part.Inactive = FALSE
THEN DO:
ASSIGN Email-Subject = Part.PartNum + " reopened or new part by " +
USERID.
ASSIGN Email-Text = "Part was reopened.".
END.
ELSE DO:
ASSIGN Email-Subject = Part.PartNum + " inactivated by " + USERID.
ASSIGN Email-Text = "Part was inactivated. sSc MPN: " +
Part.Searchword.
END.
/* the end */
This second one sends email when a specific job type is closed.
Jobs that begin with TL which is a tool kit job in our tool room
/* Program to send a global alert on a TL Job when closed
by Patrick Winter
10/15/2004 */
{ud/GlbAlert.i &TableName = "JobHead"}
DEFINE VARIABLE NewEmailBody AS CHARACTER NO-UNDO.
IF JobHead.JobClosed = TRUE
AND SUBSTRING(JobHead.JobNum,1,2) = 'TL'
THEN DO:
ASSIGN Email-Subject = JobHead.JobNum + "has been closed by " + USERID.
ASSIGN Email-Text = "The attached tool job has been closed, the tools
are ready!".
END.
ELSE DO:
RETURN ERROR.
END.
/* end */
Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975
-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Friday, February 04, 2005 6:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.0 Business Activity Manager
Anyone who uses the BAM know that this global alert does not return
meaningful information on the body of an e-mail.
For instances, when someone changes an order quantity, the email tells the
recipient that an order quantity has been changed.
Which one???? Who knows. I spoke to Epicor yesterday, and they told me
that there would have to be a Progress routine incorporated to return the
desired values. They do not have an example tho.
Has anyone gone down this road? Do you have any examples?
regards,
[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