Ned;
We use the BPM Method with e-mail notifications with the Requisition number in the alert.
We set the managers as Buyers with certain hierarchy of limits and approval people.
We set Requisition Actions for "Manager Approval" to the people who will be allowed to approve a requisition, and "Create Purchase Order" can only be don by the Buyers with their associated limits.
They want the e-mails, as they never check their queues anyway.
Works fairly well for us.
George Hicks
Just so I don’t end up spending a whole bunch of time re-inventing the wheel, I was wondering if anyone had any kind of setup done for notifications for pending requisition approvals?
I know that through a BPM, I can probably send an email every time there is one, but that seems a little excessive and could end up just flooding with emails that are not required, especially if someone is checking their approval queue like they should be.
My thought was to create some sort of way for the system to query the DB on a regular schedule, every 1 hour, or 2 hours, then if a person has a previously defined number of approvals waiting for action, say 5 or 10, it will send them an email to them reminding them or letting them know.
This is on a SQL DB, so this process doesn’t actually need to be within the application, I am pretty sure it can be done through a stored procedure on a scheduled maintenance task once I identify exactly which tables and fields hold the information to be queried, but again, if this has already been created by someone, a head start is always nice.
So even if not specifically on this process, but something similar as a guide would certainly be helpful.