I'll slap my hands in advance, but one additional option would be doing this in TSQL if you are lucky enough to be a SQL customer.  Create a script, make it a stored procedure, use the native SQL Job Scheduler to fire it off at any time you desire. This is another one of those things that are so easy to do in SQL. And it's completely safe.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 29, 2014 8:03 AM
To: Vantage
Subject: Re: [Vantage] BPM or BAM?
BAMs like BPMs are event triggered so that won't help you. Your choices are limited
1) Do a BPM on a commonly used method (Order Update, System Agent Monitor.. something like that)
2) You can write an external program that interacts with Epicor by using the BO's
3) Write a BAQ Report that you schedule to run at midnight which then prints to APM and APM sends the email (requires a client be left open)
Jose C Gomez
Software Engineer
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Thu, May 29, 2014 at 7:23 AM, sdalal91@... [vantage] <vantage@yahoogroups.com> wrote:
Hello All,
We have a special set of parts in the system that start with 'PD', they are dealt with differently to all other parts and require a bit of special attention. I want an email alert to be sent when a part starting with 'PD' is due in 3 days i.e. if an order is due in 4 days and we reach midnight of the current day, this means that the order is now due in 3 days, this is the point at which i want the alert to fire.
I was trying to create this in BPM but when the methods are ones like 'update' and 'getnew'; I dont see how it would fire anything until a change on the database is being made.
So I came across BAM which I know enough about to get me around. I set up a BAM on Orderdtl, and used the fields partnum and request date.
I setup the email, setup in company, task agent etc. to ensure the email function is operational and would fire when the conditions are met. The conditions I used were a part begins ' PD ' and the due date is 3 DAYS FROM TODAY, (there are two fields in BAM - FROM TODAY and DAYS FROM TODAY - i used these to get the date condition by ticking the FROM TODAY box and putting 3 in the DAYS FROM TODAY field)
When testing this overnight nothing happened, there were orders that would meet the criteria but no dice. I tried it a couple more times and still nothing. Is this the correct way of doing this or is there a better option?
Any advice would be greatly appreciated.
Thank you for your time, SD.
