Hi Everyone, I bet this is pretty simple and would appreciate some direction.
I want to set up a data directive to send an email notification when the Purchase Order due date is late.
I was not able to figure out the condition using the POdetail Table. Any advice? Much appreciated.
1 Like
Your first hurdle is that something has happen in order for a BPM or DD to fire. And once that happens, then you could take action and look for overdue PO lines.
What I would do instead of the BPM or DD, is make a BAQ Report that filters to any PO Line where the DueDate < Today. Then schedule that report to run at 12:01 each day. If nothing’s late, then no report is emailed. Otherwise, you’ll get an email with the BAQ Report attached.
2 Likes
As of 10.2.600 functions can be scheduled! I’m so happy I won’t have to have BPMs that are triggered off of the SysCube table.
That said… @ckrusen had the right answer. Make a report and potentially a routing to send the email.
1 Like
Thank you Calvin!