The below is the SQL statement that is already available to the users for the List of “Open SO” that we have available under the Sales User Defined triggers as an example SQL statement.
select Orderdate, sono from somain where empty(poackdt) and ord_type = "Open" and orderdate > date() – 30
You can modify this trigger or you can create a new one. All you should have to do is setup a time and emails.
SELECT somain.sono,somain.orderdate,somain.ord_type FROM somain WHERE NOT poack AND ord_type='Open' ORDER BY OrderDate
|