Thursday 4 October 2012

Using Outlook to create Timesheets and Labour Postings

Once you have started scheduling SYSPRO Jobs in Microsoft Outlook, the next logical step is to use the information recorded to create a Timesheet for your Engineers. We can extract the data from the Calendar and Export it into an Excel Spreadsheet, where it can be checked, amended and manipulated if required. The verified data can then be used for Payroll and also imported into SYSPRO and posted directly the relevant Jobs, saving you time and money!

To find out more about how Blue Streak can save you money and time by creating Timesheets and SYSPRO Labour Posting from Microsoft Outlook, click here to contact us or simply call us on +44(0)844 567 502.


Wednesday 22 August 2012

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

Tuesday 1 May 2012

Microsoft Outlook Integration

SYSPRO can be integrated with Microsoft Outlook so that Appointments or Emails are created either automatically or at the touch of a button. The content of the Appointment or Email can be populated with data from SYSPRO (or any other database provided drivers are available). Using Microsoft Exchange and Smart Phones, staff can instantly see when a relevant Appointment or Email has been generated.

Quotation Chase Dates
Insert an Appointment in Outlook as a reminder to chase a Quote.

Sales Order Despatch Dates
Insert an Appointment in Outlook to create a Despatch schedule.

Purchase Order Delivery Dates
Insert an Appointment in Outlook to create a Booking In Schedule.

Engineer Schedule
Engineers can have scheduled Jobs delivered direct to their phone's calendar, including Customer's Address & Contact Details, Job Description & Component Allocations etc.

To find out more about how Blue Streak can integrate SYSPRO with Microsoft Outlook, click here to contact us or simply call us on +44(0)844 567 5021

Monday 16 January 2012

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

    Tuesday 22 November 2011

    Customising SYSPRO's User Interface

    Customising SYSPRO's User Interface is a simple, yet powerful way of enhancing SYSPRO's functionality.
    From simply displaying Custom Form Fields on a standard SYSPRO data entry or Query screen right through to creating a button in Inventory Query that automatically raises a Purchase Order for an item, by using VBScript and SYSPRO's customisation tools, you can effectively change the way SYSPRO works so that it fits better with your business processes.

    For example:

    Make a non-mandatory field mandatory
    Ensure an operator enters data into a standard or custom field, even though SYSPRO doesn't require it.

    Automatically change the case of a field
    If you only use upper case StockCodes, you can ensure the StockCode field in Sales Order Entry automatically converts an incorrect lower case StockCode into upper case.

    Calculate values of fields
    Automatically populate fields with a calculated value e.g. Add 10 days to Today’s date to create a Ship Date.

    Automatically capture additional data
    See not only who created a Job, but also the last person to update it, without the Operator having to do anything.

    Display Data from another screen
    Fetch data from another area of SYSPRO. e.g. Display the Supplier’s email address and telephone number in Inventory Query.

    Populate a Word Template with data from a Query screen
    Create a letter to a Customer informing them of their Credit Status at the touch of a button.

    Create an email with values from a data entry screen
    After adding a Sales Order, create an email to the relevant Salesman letting them know one of their customers has placed an order including values, order number, date etc.

    One-Touch Purchase Order
    Create a Purchase Order for an Item direct from Inventory Query.

    Data Folders
    Create or Open Folders on the network from within SYSPRO. Link them to Jobs, Quotes, Customers, Suppliers etc to store Drawings, Correspondence etc.

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