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.
Blue Streak Consulting Ltd
getting more out of SYSPRO
Thursday, 4 October 2012
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:
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
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.
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.
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.
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
Subscribe to:
Posts (Atom)