Bam

Yahoo Archive
1
Ahhh brilliant..ill try that! Thanks!



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steven Gotschall
Sent: Thursday, October 08, 2009 11:40 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAM





The only way I know of is to compare it to a UD date field that you know
will always be null.

________________________________
From: Rob Bucek <rbucek@... <mailto:rbucek%40dsmfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, October 8, 2009 11:11:43 AM
Subject: [Vantage] BAM


Hi all, Im having somewhat of a proverbial brain fart here. I want a
BAM to fire when JobOper.Opcomplete = True and JobOper.LastLaborDa te is
null. I cant remember how to set the isnull condition on the date
field....

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg com/>

(Click the logo to view our site) <http://www.dsmfg com/>

[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]
2
Is anyone using Business Activity Manager? Epicor tells me I can use it
to create an Alert that will e-mail automatically when an order ships
short or a line of an order doesn't ship on time. I explored the window
where you would create this and it does not appear to be very intuitive.
Maybe it is me. Can anyone attest to this? Anyone know how I would do
this?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.


[Non-text portions of this message have been removed]
3
Todd,
Consider it attested to.
I use it to send automatic order confirmations, shipment notification
with tracking numbers, and notify me of order entry errors (where the
price per code is changed from each).
The possibilities are nearly endless, but by the time you finish you
will be slightly more than a casual Progress user, and closer to a
beginning Progress programmer.
I can forward you some examples if you like, but as with everything,
talk to your CAM first and have them ship you some examples.
It will be of great assistance if you have any programming background,
and as you note, it's not intuitive at all.
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Wednesday, August 25, 2004 12:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM


Is anyone using Business Activity Manager? Epicor tells me I can
use it
to create an Alert that will e-mail automatically when an order
ships
short or a line of an order doesn't ship on time. I explored the
window
where you would create this and it does not appear to be very
intuitive.
Maybe it is me. Can anyone attest to this? Anyone know how I
would do
this?

Thanks
Todd Hofert
IT Director
Spartan Graphics, 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=129af5mu5/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1093539276/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=545561427>


_____

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]
4
I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]
5
Todd,
You will need to take...
The PartWhse and link to Part, then to PartClass then to PurAgent.
Links should be:
FIND Part WHERE (Part.Company = PartWhse.Company) AND
(Part.PartNum = PartWhse.PartNum)
NO-LOCK.
FIND PartClass WHERE (PartClass.Company = Part.Company) AND
(PartClass.Class = Part.Class)
NO-LOCK.
FIND PurAgent WHERE (PurAgent.Company = PartClass.Company) AND
(PurAgent.BuyerID = PartClass.BuyerID)
NO-LOCK.

Now you can use:
ASSIGN Email-To = string(PurAgent.EmailAddress)

That should do the trick.
Good luck,
Aaron


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Thursday, October 13, 2005 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM


I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[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
6
Hello Aaron,



In order to inject a little bit of "fun" into our system alerts generated by
BAM and to make them a little more "attention-grabbing", I was wondering if
it is possible to add an animated GIF to an alert. Have you attempted to do
this? If so, would you mind sharing the code you used?



Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.531



-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, October 13, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM



Todd,
You will need to take...
The PartWhse and link to Part, then to PartClass then to PurAgent.
Links should be:
FIND Part WHERE (Part.Company = PartWhse.Company) AND
(Part.PartNum = PartWhse.PartNum)
NO-LOCK.
FIND PartClass WHERE (PartClass.Company = Part.Company) AND
(PartClass.Class = Part.Class)
NO-LOCK.
FIND PurAgent WHERE (PurAgent.Company = PartClass.Company) AND
(PurAgent.BuyerID = PartClass.BuyerID)
NO-LOCK.

Now you can use:
ASSIGN Email-To = string(PurAgent.EmailAddress)

That should do the trick.
Good luck,
Aaron


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Thursday, October 13, 2005 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM

I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.





[Non-text portions of this message have been removed]
7
If the alert is sent as HTML format, then its just a matter of using <IMG SRC='filename.gif'> tags. The GIF file will need to be in a location and path that is reachable from the users e-mail.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lepley, Scott A.
Sent: Wednesday, October 26, 2005 12:33 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM


Hello Aaron,



In order to inject a little bit of "fun" into our system alerts generated by
BAM and to make them a little more "attention-grabbing", I was wondering if
it is possible to add an animated GIF to an alert. Have you attempted to do
this? If so, would you mind sharing the code you used?



Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.531



-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, October 13, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM



Todd,
You will need to take...
The PartWhse and link to Part, then to PartClass then to PurAgent.
Links should be:
FIND Part WHERE (Part.Company = PartWhse.Company) AND
(Part.PartNum = PartWhse.PartNum)
NO-LOCK.
FIND PartClass WHERE (PartClass.Company = Part.Company) AND
(PartClass.Class = Part.Class)
NO-LOCK.
FIND PurAgent WHERE (PurAgent.Company = PartClass.Company) AND
(PurAgent.BuyerID = PartClass.BuyerID)
NO-LOCK.

Now you can use:
ASSIGN Email-To = string(PurAgent.EmailAddress)

That should do the trick.
Good luck,
Aaron


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Thursday, October 13, 2005 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM

I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, 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
8
Michael,



Thanks for the tip! I have specified in most of my alert programs that the
message should be sent as HTML format, so your tip was just what I needed.



Do you know how, if it is even possible, to integrate an animated GIF into a
"message" command for a screen (pop-up) alert?



Regards,
Scott



-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, October 26, 2005 2:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM



If the alert is sent as HTML format, then its just a matter of using <IMG
SRC='filename.gif'> tags. The GIF file will need to be in a location and
path that is reachable from the users e-mail.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lepley, Scott A.
Sent: Wednesday, October 26, 2005 12:33 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM

Hello Aaron,

In order to inject a little bit of "fun" into our system alerts generated by
BAM and to make them a little more "attention-grabbing", I was wondering if
it is possible to add an animated GIF to an alert. Have you attempted to do
this? If so, would you mind sharing the code you used?

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.531


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, October 13, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM

Todd,
You will need to take...
The PartWhse and link to Part, then to PartClass then to PurAgent.
Links should be:
FIND Part WHERE (Part.Company = PartWhse.Company) AND
(Part.PartNum = PartWhse.PartNum)
NO-LOCK.
FIND PartClass WHERE (PartClass.Company = Part.Company) AND
(PartClass.Class = Part.Class)
NO-LOCK.
FIND PurAgent WHERE (PurAgent.Company = PartClass.Company) AND
(PurAgent.BuyerID = PartClass.BuyerID)
NO-LOCK.

Now you can use:
ASSIGN Email-To = string(PurAgent.EmailAddress)

That should do the trick.
Good luck,
Aaron


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Thursday, October 13, 2005 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM

I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.





[Non-text portions of this message have been removed]
9
Haven't tried, but my guess would be that you could create an application which is capable of displaying animated GIF files, then in the .P program of the alert, you ShellExecute your created application displaying the data you wish to relay and your animated GIF. It might be possible to create the .P as a .W, compile it to a .R and then have a window open up with the alert. Then you could add an OCX object to the .W for displaying animated GIF's.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lepley, Scott A.
Sent: Thursday, November 03, 2005 8:57 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM


Michael,



Thanks for the tip! I have specified in most of my alert programs that the
message should be sent as HTML format, so your tip was just what I needed.



Do you know how, if it is even possible, to integrate an animated GIF into a
"message" command for a screen (pop-up) alert?



Regards,
Scott



-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, October 26, 2005 2:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM



If the alert is sent as HTML format, then its just a matter of using <IMG
SRC='filename.gif'> tags. The GIF file will need to be in a location and
path that is reachable from the users e-mail.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lepley, Scott A.
Sent: Wednesday, October 26, 2005 12:33 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAM

Hello Aaron,

In order to inject a little bit of "fun" into our system alerts generated by
BAM and to make them a little more "attention-grabbing", I was wondering if
it is possible to add an animated GIF to an alert. Have you attempted to do
this? If so, would you mind sharing the code you used?

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.531


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, October 13, 2005 10:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM

Todd,
You will need to take...
The PartWhse and link to Part, then to PartClass then to PurAgent.
Links should be:
FIND Part WHERE (Part.Company = PartWhse.Company) AND
(Part.PartNum = PartWhse.PartNum)
NO-LOCK.
FIND PartClass WHERE (PartClass.Company = Part.Company) AND
(PartClass.Class = Part.Class)
NO-LOCK.
FIND PurAgent WHERE (PurAgent.Company = PartClass.Company) AND
(PurAgent.BuyerID = PartClass.BuyerID)
NO-LOCK.

Now you can use:
ASSIGN Email-To = string(PurAgent.EmailAddress)

That should do the trick.
Good luck,
Aaron


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Hofert
Sent: Thursday, October 13, 2005 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM

I have been playing around with BAM since Aaron peaked my interest a
couple of days ago. Rather than simply waiting until his Perspectives
round table I have dove in and tried to hack apart an existing sample
for a global alert sent via e-mail but am failing miserably.

I am trying to generate an e-mail notification to a buyer when a part on
hand balance falls below it's minimum on hand quantity. I cannot use the
canned Vantage global Alert as it looks at the on hand per bin to
determine what is below minimum. In other words if I have 10 of a part
in five different bins for a total of 50 on hand with a min on hand set
at 25, the canned global alert would fire 5 e-mails, one for each bin
balance of 10. That doesn't work for me as I see myself as having 50
parts which is 25 over the part minimum. No alert necessary. I am
currently working with the PartWhse table as it contains everything I
need with exception of the buyer. Not sure how to get that.

My question is does anyone have an existing BAM that does this? I am
having trouble getting info to an e-mail and associating it to a buyers
e-mail address.

Thanks
Todd Hofert
IT Director
Spartan Graphics, 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
10
I have a BAM setup to notify a user in our accounting department when
any user changes one of the tax fields on the ShipTo table. She would
like not to receive the email if she was the one who changed the
information. Is this possible?



Rich



BAW Plastics



[Non-text portions of this message have been removed]
11
You would need to modify the standard BAM with some Progress code.
I have collected several user examples and have done a few myself.
Contact me off-line if you haven't written one before. I can send
examples and help you make sure you don't spin wheels for too long.
They are not difficult to write.

--- In vantage@yahoogroups.com, "RICH WAGNER" <rwagner@...> wrote:
>
> I have a BAM setup to notify a user in our accounting department
when
> any user changes one of the tax fields on the ShipTo table. She
would
> like not to receive the email if she was the one who changed the
> information. Is this possible?
>
>
>
> Rich
>
>
>
> BAW Plastics
>
>
>
> [Non-text portions of this message have been removed]
>
12
Is there a way to have a BAM turned off when certain users make a change
on the triggered field?



I have an Alert Box come up when users clock in to a job but I do not
want the box to pop up for our people who do labor edits.



Does an environment variable exist that for either the machine name or
Vantage user ID that I can filter from?



Any input would help.



Thanks



Rich



[Non-text portions of this message have been removed]
13
I created a simple BAM for RMA Receipts.
Table name RMARcpt
Selected fields RcvDate & RMAReceipt. The action is to create log and send alert. I have the Email address and Alert text entered. However when I receive the alert message via email I would like it to show the RMA number that was just receieved. Can anyone guess whats missing?
14
You need an alert attachment heres a basic shell of what you could start
with



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

Assign Email-Text = "The following is ready for receipt to stock;" +
"RMA Number: " + string(RMARcpt.RMANum)



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ziimeone
Sent: Tuesday, August 18, 2009 7:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM





I created a simple BAM for RMA Receipts.
Table name RMARcpt
Selected fields RcvDate & RMAReceipt. The action is to create log and
send alert. I have the Email address and Alert text entered. However
when I receive the alert message via email I would like it to show the
RMA number that was just receieved. Can anyone guess whats missing?





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

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of ziimeone
Sent: Tuesday, August 18, 2009 5:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM




I created a simple BAM for RMA Receipts.
Table name RMARcpt
Selected fields RcvDate & RMAReceipt. The action is to create log and
send alert. I have the Email address and Alert text entered. However
when I receive the alert message via email I would like it to show the
RMA number that was just receieved. Can anyone guess whats missing?






[Non-text portions of this message have been removed]
16
 You'll have to assign what you want to show up in the Email Subject/ text.
Â
ie:
Â
 ASSIGN Email-Subject = "RMA Received:# " + STRING(RMARct.RMANum).
Â
 ASSIGN Email-Text = "whatever you construct".

--- On Wed, 9/2/09, Dan Godfrey <dgodfrey@...> wrote:


From: Dan Godfrey <dgodfrey@...>
Subject: RE: [Vantage] BAM
To: vantage@yahoogroups.com
Date: Wednesday, September 2, 2009, 11:49 AM


Â



..

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of ziimeone
Sent: Tuesday, August 18, 2009 5:34 AM
To: vantage@yahoogroups .com
Subject: [Vantage] BAM

I created a simple BAM for RMA Receipts.
Table name RMARcpt
Selected fields RcvDate & RMAReceipt. The action is to create log and
send alert. I have the Email address and Alert text entered. However
when I receive the alert message via email I would like it to show the
RMA number that was just receieved. Can anyone guess whats missing?

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



















[Non-text portions of this message have been removed]
17
you coulc try using the following in a .P file
its what we use to send to users when new RMA arrive

Dave

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

find first mfgsys.RMADtl where mfgsys.RMADtl.company = mfgsys.RMARcpt.company
and mfgsys.RMADtl.RMANum = mfgsys.RMARcpt.RMANum
and mfgsys.RMADtl.RMALine = mfgsys.RMARcpt.RMALine
no-lock no-error.

find first mfgsys.WhseBin where mfgsys.WhseBin.company = mfgsys.RMARcpt.company
and mfgsys.WhseBin.WarehouseCode = mfgsys.RMARcpt.WareHouseCode
and mfgsys.WhseBin.BinNum = mfgsys.RMARcpt.BinNum
no-lock no-error.


/* Create the message box */
IF (mfgsys.RMARcpt.RMAReceipt >= 1) THEN DO:
ASSIGN Email-Subject = "Vantage RMA Receipt. RMA " + String(Mfgsys.RMADtl.RMANum)+ " / " + String(Mfgsys.RMADtl.RMALine).
ASSIGN Email-Text = "RMA Num: " + String(Mfgsys.RMARcpt.RMANum)
+ " Part: " + String(Mfgsys.RMADtl.PartNum)
+ " Description: " + String(Mfgsys.RMADtl.LineDesc)
+ " Qty: " + String(Mfgsys.RMARcpt.OurReceivedQty)
+ " Warehouse: " + String(Mfgsys.RMARcpt.WareHouseCode)
+ " Bin: " + String(Mfgsys.RMARcpt.BinNum) + " " + String(Mfgsys.WhseBin.Description).
.
END.
ELSE DO:
RETURN "CANCEL SEND".
END.
18
Hi all, Im having somewhat of a proverbial brain fart here. I want a
BAM to fire when JobOper.Opcomplete = True and JobOper.LastLaborDate is
null. I cant remember how to set the isnull condition on the date
field....



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>







[Non-text portions of this message have been removed]
19
The only way I know of is to compare it to a UD date field that you know will always be null.




________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Thu, October 8, 2009 11:11:43 AM
Subject: [Vantage] BAM

Â
Hi all, Im having somewhat of a proverbial brain fart here. I want a
BAM to fire when JobOper.Opcomplete = True and JobOper.LastLaborDa te is
null. I cant remember how to set the isnull condition on the date
field....

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg com/>

(Click the logo to view our site) <http://www.dsmfg com/>

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







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