There are already a number of built-in SYSPRO Triggers and Events, but, frustratingly, the one you need is often unavailable. Utilising SQL Triggers is a powerful way of extending the functionality of standard SYSPRO.
SQL Triggers fire on a table when a record is INSERTED, DELETED or UPDATED. This means that you can trigger an action at just about any point in a Business Process, and control the exact circumstances (using CASE and IF statements etc) under which the Trigger fires.
Adding SQL Database Mail to the mix, you can create custom alerts & notifications, and send them via Email to a mailing list or dynamic email addresses.
For example:
To find out more about how Blue Streak can help you utilise SQL Triggers & Alerts, click here to contact us or simply call us on +44(0)844 567 5021
For example:
- Notify a Sales Rep when a Quotation is confirmed
- Notify Stores with a Pick List when Material is allocated to a Job
- Notify Accounts when an On-Hold Customer has made a Payment
- Email a Customer when their Goods have been Despatched
To find out more about how Blue Streak can help you utilise SQL Triggers & Alerts, click here to contact us or simply call us on +44(0)844 567 5021
No comments:
Post a Comment