SQL Triggers & SQL Database Mail

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:

• 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

Automatically email SYSPRO Remittances

Email HTML formatted Remittances direct to all Suppliers with a SYSPRO Remittance Email Address without any user intervention. The email can look just like your current Remittance or can take full advantage of HTML formatting to look truly professional.

This process can also be applied to other automatic notifications like AR Statements, Customers nearing or reaching Credit Limits, Goods Despatched and even Reports. In fact, the possibilities are endless.

• Email HTML Remittances direct from SQL.
• Save money on postage & labour.
• Send as soon as payment is made.
• Schedule to run automatically overnight.
• Still print & post or fax if required.
• Automate other processes, reports & notifications.

To find out more about how Blue Streak can save you money and time by helping you automatically email SYSPRO Remitances, click here to contact us or simply call us on +44(0)844 567 5021