I have never been able to get the Global Alerts to work for global alert 1030 (Quote Follow Up date has been reached) and hoping someone can tell me what is going on.
I activated the global alert:
I save and then go to a quote and set a Follow up Date.
I checked in the Erp.AlertQue table and it’s completely empty for that record.
I am able to, as a test, trigger the global alert to Notify if Credit Hold has changed, as it does create records in the AlertQue table.
Am I missing something of does this feature simply not work?
Awesome.
Follow up question; what might I do to replicate this feature? I know I could run a custom process to scan for that date and send an email, but obviously it would need some sort of queue table to store the upcoming alert and clear it when it passes. This could likely be done via a UD table, but seems frustrating to replicate behavior that should work natively…
I mean all joking aside there is a way to make it work, but I honestly don’t know.
You could do a UBAQ which runs daily and gives you any quotes whose date is “TODAY” and then sends the email on post processing GetList
I’m not that familar with this feature, but if you run the process once a day. Wouldn’t you not have to store anything? Simply return records due “TODAY” so tomorrow will only bring those etc?
You could make a BAQ Report that filters to quotes that “expire” today (or yesterday if you run it at 12:01 AM), then “print” the report, but use the email feature, first setting a schedule and make it reoccurring.
Or skip e-mails altogether and just make a dashboard so they can actually check it off. (I hate nag e-mails, everyone ignores them anyways). More fields, but Meh?? (My 2 cents)
Ohhh trust me they have every dashboard they’d ever need to view this info. We tend to be too reliant on info being pushed to us as is, but I do agree with you
We created a BAQ report that runs every night. When it runs we use report SSRS breaking/routing to send a personalized email with the report attached to each salesperson. We use this for a number of custom reports.
I have Quote Follow Up emails being sent out and working as advertised. I set the Follow-up Days in Company Configuration, and then the Follow-up field get automatically populated on each Quote. then I have a Data BPM on AlertQue.Update that looks for added rows with AlertNum = 1030, and sends an email when it finds one.
One quirk that I don’t understand - To get Expired Quotes to work, I have to run the Quote Expiration process as a scheduled task every night at 2:00 am. The Expired Quote emails all get sent around 2:00 am every day. But, the Follow Up emails don’t get sent out at 2:00 am, They don’t go out until someone opens the Opportunity Quote Maintenance screen. If no one opens that screen, the Follow-up emails don’t get sent. So, on weekends, the quotes that reach Follow-up on Sat or Sun, get sent on Monday morning after someone opens Quote Maint. Kind of weird, but it does work for us.