Currently we have a BPM which sends out an email on JobEntry.ChangeJobProdProdQty simply sent whenever the prod qty changes. The team that receives these emails wants the changes to be sent weekly/daily instead of on an “as-it-happens” basis.
One idea I had was to create a UD table and use data directive to populate it with any change, then use that to send out a weekly report of all of the changes. I’ve never done something like that and don’t know if it would work so I would like some other options. (If it’s possible with Chglog please tell me how!! I couldn’t think of how that would work.)
Yes it should work fine. It’s a bit involved, but isn’t a too terribly hard depending on your skill level. ChgLog is a joke, I wouldn’t go that way if I were you, although you could technically do it via BAQ report.
You can find an empty UD table to comandeer (UD01 or whatever you have that’s available). Then with the current task that sends an email, write a row to the that table with your change information that would normally be in the email. Then make a BAQ that displays that information, with an BPM on get list post processing that puts that list of info into an email and sends it. You can schedule that BAQ to run various ways. Probably easiest with a function, because the function scheduler is just built into epicor. Otherwise you can make a BAQ report out of it and scheule that.
To keep track of what’s been sent or not, make or use a checkbox to flag when it’s been sent. You can flip this with the post processing BPM on get list. Then use that to filter the table in your BAQ so that you’ll only send out the rows once.
