Client Lists

SQLWorks CRM allows for easy creation and maintenance of a list of specific companies, which can be used for email mailshots, segmented letters and other targeted communication.

Client Lists can be found under the CRM section in the main SQLWorks Navbar (1), and opens a window with a list management menu (2) and a client list panel (3).

To create a new custom list from the companies in your main Companies List, click the ‘New’ button in the top toolbar, this opens the new client list window (4) which allows you to set options for the list you’re about to create, including assigning it to a user, creating a list from companies or contacts (or both) and choosing from pre-saved options from your ‘Quick Select’ menu.

The ‘Locked List?’ checkbox allows the list creator to toggle control of the new list, locking the list to being changed by anyone but the administrator.

For generating email lists, three additional email option checkboxes provide a useful shortcuts to automatically exclude any company or contact without an email, exclude duplicated email addresses to avoid double-sending, and hide anyone saved with an email ‘opt-out’ against their name within SQLWorks.

You can build your list using any of three methods, selecting from checkbox categories saved in your Companies List, choosing options from your Quick Select menu such as companies with ‘Recent Phone Logs’, or building a custom query using the standard SQLWorks Custom Search tool. This final option gives you complete control over your new list – adding lines using the (+) and (-) buttons to add or remove qualifying companies that match a series of terms.

SQLWorks can handle both fixed and dynamic lists: by clicking ‘Enable Smartlist’ under the ‘Live Search’ Tab your list will constantly update as new data becomes available, re-fulfilling your saved search terms to remain current. Leaving Smartlist turned off will keep your list as it was when you first created it.

Two further tabs labelled ‘Always Included’ and ‘Never Included’ allow you to set overriding exception rules for who appears on your list. Moving a company or individual from left to right, onto the ‘Always Included’ category ensures this company or category will always remain on the list.

Moving a company or individual from left to right onto the ‘Never Included’ list ensures this company or contact will be never be a part of this list. If a company or contact appears on both lists, so that the two exceptions conflict, the ‘Never Included’ list takes priority.

Clicking ‘Save & Close’ will save under your SQLWorks User ID the results of your list – which can be exported to an excel spreadsheet for use in external applications by clicking the ‘Export’ button at the top of Client Lists window.

Back in your SQLWorks Companies List, your saved client lists can also be used from either Quick Select dropdown or the ‘Client Lists’ tab to filter your overall database.

SQLWorks Client Lists give you the power to create precise and complex lists from your larger company database for highly targeted marketing and other customer management.

 

For more information of SQLWorks CRM tools, click here.

Removing Companies

Keeping on top of your data means cleaning old entries and removing companies you don’t need every now and then – but what’s the best way to do this?

Your SQLWorks includes an ‘inactive’ status for removing companies, which allows you to effectively tidy your database whilst avoiding deleting data you might need later. – SQLW

We recommend using this feature because outright ‘deletion’ of a company is normally not the best option. Most companies have linked information connected to other parts of SQLWorks: including phone logs, tasks and more, which makes deletion impractical.

To make a company inactive, right click its name in the main Companies List and click the ‘Toggle Active’ button to move a company to inactive status.

Inactive companies can be recovered later if users need to access older data, whilst keeping their main working list up to date for other time-sensitive tasks, e.g.: when generating mailshots, and ensuring your company files always remain accurate.

For the most professional warehousing operations, SQLWorks includes a powerful automated order allocation system.

‘Order Allocation’ can be accessed by users who have the SQLWorks Advanced Stock module under ‘Products’ in the main Navbar .

The top of this window gives you a series of filters for every stock order recorded in SQLWorks , with a series of configurable order allocation stages that your warehouse stock must move through to be dispatched in the panel below.

Typically stock will be progressing through one of six stages:

• ‘Unallocated’ – Stock that has not yet been processed.

• ‘Allocated’ – Stock from a specific warehouse reserved for a specific order.

• ‘Released’ – Stock in a specific bin location or locations, approved for picking.

• ‘In Pick’ –  Stock that has been picked and due to be dispatched to the customer.

• ‘In Transit’ – Stock that is part of internal stock movements between warehouses

By default all lines that meet your search criteria are displayed on the relevant tabs on the bottom of the window. These display is automatically ‘locked’ to editing, however using the radio buttons users can make the list ‘Selectable’ to turn on or off individual (or groups of) order lines, or ‘Editable’ to change individual allocation qty within a line. Right clicking a selectable or editable line opens helpful options for highlighting mass, order group or inverse line selections.

In the unallocated tab clicking the ‘Auto Set Values’ button on the right will allocate anything SQLWorks can, when you save it will move order lines to the ‘Allocated’ Tab. Since not every allocated stock item within an order is always available for dispatch, SQLWorks releases the order allocation based on the dispatch rules set in the order:

• ‘Allow Back Orders’ – When picked, any outstanding stock is cancelled unless SQLWorks is told to hold as outstanding items for back ordering.

• ‘Allow Part Order’ – SQLWorks will allocate order lines as they become available, unless told to wait until the full order can be fulfilled.

• ‘Allow Split Line’ – Send partial quantities from lines whenever they are available.

You can specify saved defaults for your company’s SQLWorks order allocation, which can be overridden with a rule for specific customer’s sales account, and are then applied to each specific order for the account.

Once released, SQLWorks can auto-generate intelligent picking notes – itemising stock to be picked using optimal warehouse walking route based on the known locations of your warehouse bins. When a pick is complete, warehouse operatives can re-enter stock ‘Fail Quantity’ figures into your order allocation history, along with reporting reasons for why the stock in question could not be picked. The remaining quantity is then automatically moved to invoice, allowing you to dispatch large numbers of orders with ease and efficiency.

An inventory Audit Log also allows you to look back through a complete history of every order line, or you can refer to the ‘Order Processing’ Tab within the Stock Ledger for a graphical summary and past failed order data.

For a more professional stock control solution – contact us about SQLWorks today: 01271 375999

Although SQLWorks is designed to avoid the need for multiple windows, sometimes this trick to open additional windows can be very useful.

To open an extra SQLWorks window, simply ‘Shift-click’ by holding shift at the same time as clicking on a chosen SQLWorks menu item.

This works with every Navbar section, tab and subsection of SQLWorks – and is useful for when you need to be able to refer to two (or more) unconnected sections of SQLWorks at once. 

For example, whilst you’re busy working on a customer’s quote, the phone rings with a call from a different customer who wishes to book a meeting. Simply ‘shift-click’ the SQLWorks Calendar to open a separate diary window for you to work with.

Each of the windows behaves independently, and can be used, moved, resized or closed as normal. The only exception to this rule is that multiple copies of the same window will not synchronise any edits you make between copies.

This handy trick guarantees that you can work in different parts of SQLWorks simultaneously however you need.

Need some helpful advice? Contact our SQLWorks team today: 01271 375999