Consignments –

If you sell consignment stock through the premises of another company, SQLWorks can help you keep track of your consignments.

Stock locations can be managed in a number of ways, but the easiest way to hold your stock at another location is to create a new warehouse to represent this, named after the customer who holds this stock as a consignment.

To add a consignments warehouse, open ‘Products’ from the main nabvbar (1), open your Warehouse Map (2) and click the ‘New’ button on the top left to add a new warehouse to your list of warehouses. Name this warehouse after the consignment location, or the name of the consignment customer.

When creating the new warehouse, remember to check the correct radio button on the right hand side before saving, tagging the new consignment warehouse as ‘consignment wh’ or ‘retail store.’

You can treat this warehouse like any other – moving stock to or from the premises of your seller, raising customer orders and invoices against that company, and performing stock valuations.

If your consignment is large, you can also divide it into multiple ‘Bin’ locations, as you might for one of your own warehouses, and assign stock to the correct bins accordingly.

You can choose to change a customers’ default order type to ‘IWT’ (Inter-warehouse transfer) or CONS (Consignment) under the ‘Print and Orders’ Tab in a customers’ Sales Ledger account.

This function allows you to specify your (actually their) new consignment stock warehouse under “Warehouse to” for stock, to be moved into by default. In the case of IWT and Consignment stock, this order will then be removed to prevent invoicing a consignment stock re-seller or similar for the consignment before sale.

At all times SQLWorks treats consignment stock exactly as what it is: your stock, temporarily stored with someone else.

 

For help with stock control and warehousing: contact the SQLWorks team today.

email marketing

If you have SQLWorks linked to your email account, SQLWorks can be used for email marketing and mailshots, bulk sending emails with custom designs.

Accessed within SQLWorks CRM, users can create a new email campaign by making a new mailshot project, and create multiple mass emails within a campaign.

Right clicking in the main list and selecting ‘New Mailshot’ will open a new email creation window, where users can give the mailshot a unique name, choose an email from address, subject line, and ‘drag-and-drop’ in attachments.

The list of intended recipients can be chosen from the ‘Client Lists’ dropdown, selecting from one of your custom client lists, which you can build from your saved SQLWorks CRM contacts.

For the design of an email, you can choose from a wide range of tools from within the formatting pallet on the right of the main email editing window – get creative with different fonts and text sizes, colours, bulletpoints and alignment, insert images, tables and more!

You can format elements by highlighting them and clicking the format buttons, and confine the margins of your email by setting these measurements in the ‘Document’ tab.

For tidy formatting, we recommend creating a borderless table in which to align all the elements of your email marketing email – to ensure any custom designs are displayed consistently in the inboxes of recipients.

SQLWorks database tags can be input into the main email body so that each email contains mail merged custom data from elsewhere in your contact directory. This can be used for targeting with ‘informal’ detail (e.g.: a first name – ‘Dear John’) and a “fall-through” function which pulls in substitute data as a ‘formal’ backup (e.g.: surnames – ‘Dear Mr Smith’) where the main data is unavailable. These functions can be customised by our SQLWorks team, to email your contacts using any piece of data from your SQLWorks CRM, Accounts or Stock Control data.

SQLWorks allows you to preview each version of a mailmerged email to check for errors by clicking the ‘Prev’ / ‘Next’ buttons, and ensure each email is correctly personalised. Using the spellcheck function, and undo/redo buttons, email marketeers can also avoid any errors being broadcast to a wide audience.

If you wish to remove all formatting, and send your email as a ‘plain text’ email to improve chances of deliverability, simply tick the ‘Send as Plain Text’ checkbox at the top of the Mailshot window. Using the ‘Show Plain Text’ checkbox, you can also check how this email is likely to be seen by email inbox previews.

Deploying these tools, you can field imaginative, targeted and ongoing email campaigns, linking all the intelligence of your SQLWorks data together with your marketing.

 

For expert CRM tools, contact us about SQLWorks today:

Adding emails

SQLWorks integrates with your email inbox to let you view, send and use emails to complete other tasks: here’s how.

To add your email account to SQLWorks, click ‘User Prefs’ under Preferences (1) in the main navbar. Select your User ID, and under the ‘Employee Info’ Tab put your email settings into email settings fields, including your account ID and password. This will give SQLWorks permission to see the contents of your email inbox.

In the main Companies List (1) by clicking the ‘Emails’ Tab (2) under a selected company’s record you can view the contents of your inbox on the left hand panel, and emails saved within SQLWorks on the right hand panel.

Dragging an email from the left panel to the right panel saves a copy to the system and makes the email visible to other SQLWorks users, whilst selecting an email makes the message content visible in the yellow viewing box below.

This is most useful for adding emails which are to valuable to just sit in your inbox – emails which your team will need to be able to share or recover details from in your absence.

You can also use this tool to place important emails within the system, linking important correspondence to projects, sales leads, quotations and more.

 

SQLWorks can even be configured to recognise significant emails and automatically add them to projects and other areas – for additional information, ask the SQLWorks team today.

Working in a larger team means that a post-it note can easily get lost – so SQLWorks lets you leave prompted reminder messages for other members of your team, called Prompt Notes.

Your prompt note will pop up when another SQLWorks user opens a specific company entry from the company’s list, a specific company’s account, project or all of these, and can be used to set reminders for all members of your team when accessing that company record.

Prompt Notes can be set from your SQLWorks default preferences for any chosen company by clicking ‘Edit’ from the toolbar, and selecting the ‘Prompt Notes’ Checkbox.

Choosing ‘None’, ‘Projects’, ‘Accounts’ or ‘All’ from your SQLWorks Preferences sets when the message should appear. Selecting ‘None’ restricts your prompt note to the company’s Companies List entry only.

Prompt notes are a useful tool for leaving warning messages, designated contact points or other client-specific information, and ensuring everyone gets a prompt for an important reminder.

SQLWorks Accounts allows users to control both credit limits for each company they sell to, and credit hold settings for their customers overall.

Each company’s credit limit can be found in their company information by selecting them from the list of companies with sales accounts in the Sales Ledger (1). Clicking ‘Edit’ from the top toolbar unlocks the company information for editing, and users can simply enter a chosen Credit Limit (2), before clicking ‘Save.’

Within Accounts Preferences, users can set a standard ‘Value for Credit Limit’ to apply to each new company by default. You can also change your ‘Credit Hold’ type for what happens when companies exceed their limit, chosen from one of four possible settings:

• Manual – Where the user must check if companies have exceeded their credit limit, and choose who to place on hold or not. An utility can be run at any time to review current sales accounts.

• Manual with Override – As above, but if a company is on hold, SQLWorks will prompt the user with notifications so that the user must choose whether to continue with the action or not.

• Automatic – SQLWorks will place companies on hold or not, based on their credit limit and overdue invoices.

• Automatic with Override – As above, but the user can be override this and choose to extend further credit if they choose.

If on ‘Automatic’ SQLWorks will also move companies with overdue invoices onto hold, but users can specify a number of ‘days grace’ to give customers under the ‘Sales’ Tab within ‘Accounts Prefs. Company’s automatically placed on hold will also have their orders placed on hold, unless overriden manually.

If using manual credit control, users can right click the list window in the Sales Ledger and launch the ‘Credit Control’ utility – here you can review your companies manually based on four criteria: ‘Days grace’ given for overdue invoices, ‘Put Accounts on Hold’ or ‘Take Accounts off Hold’ to add or remove holds respectively, ‘Include Outstanding Order as Part of the Credit Limit’ to include orders placed but not invoiced on a company’s credit limit.

The manual ‘Credit Control’ utility then generates a list of those companies which are on hold (but are now within agreed credit terms) or not on hold (but have exceeded their credit terms). The user must choose who to place on hold or remove from hold, based on their credit limit and ‘days grace’ for payment deadlines. You can remove companies from the list by selecting lines and clicking the ‘Filter’ Button.

If using automatic credit control, this filtering process is controlled by SQLWorks unless you choose to override a hold. Whether to use Manual or Automatic depends on your own businesses’ level of credit control.

By default, SQLWorks will always automatically hold orders for companies that have exceeded their credit limit, and (if you also use SQLWorks Stock) will not allocate stock to that customer.

For account managers, a useful tool can be to set a chosen company’s credit limit within SQLWorks to ‘0’ (always on hold) or set a highly trusted company’s credit limit to ‘-1’ (never on hold.)

In this way SQLWorks ensures you always have control over how much credit your business extends, and to which clients.

Please contact our team for more information about SQLWorks and managing sales accounts.

SQLWorks includes four main ledgers for customer transactions: Sales Ledger, Purchase Ledger, Sundry Cash Ledger and Petty Cash Ledger

For accounting, these transaction ledgers are collated into two analysis ledgers, your live Nominal Ledger and your Bank Ledger as described below.

 

Transaction Ledgers (Sales/Purchase/Sundry Cash/Petty Cash)

Your Sales and Purchase Ledgers control account centric transactions for selling and buying to a particular customer/supplier, typically involving an ordering process and a separated invoicing and payment process (i.e. debt and credit).

Sundry Cash Ledger is for payments to and from those whom you have no ‘account’ with, and therefore is best suited to financial transactions that have no delay in payment (for example, a simple cash sale). Because of this, your Sundry Cash Ledger should be used for direct sales & expenditure, or for moving funds into and out of your Petty Cash Ledger.

Each record in any transaction ledger will appear automatically in your nominal audit. SQLWorks follows standard double entry bookkeeping rules, in that each financial transaction has two associated nominal postings. When running a nominal audit SQLWorks uses your nominal profile in preferences and the list below to automatically generate the audit records from the records in the transaction ledgers:

Financial Transaction Type	Side 1 Posts to:	Side 2 Posts to:
SL Invoice	Invoice Line Nominal Code	Creditor Account
SL Credit Note	Credit Line Nominal Code	Creditor Account
SL VAT	Creditors VAT Control Code	Creditor Account
SL Receipt	Bank Account Nominal Code	Creditor Account
SL Currency Variation	Variance Control Code	Creditor Account
SL Settlement	Settlement Control Code	Creditor Account
PL Invoice	Invoice Line Nominal Code	Debtor Account
PL Credit Note	Credit Line Nominal Code	Debtor Account
PL VAT	Debtors VAT Control Code	Debtor Account
PL Payment	Bank Account Nominal Code	Debtor Account
PL Currency Variation	Variance Control Code	Debtor Account
PL Settlement	Settlement Control Code	Debtor Account
Cash Book	Cash Record Nominal Code	Bank Account Nominal Code
Cash Book Income VAT	Creditors VAT Control Code	Bank Account Nominal Code
Cash Book Expense VAT	Debtors VAT Control Code	Bank Account Nominal Code
Petty Cash	Petty Record Nominal Code	Petty Account Nominal Code
Petty Cash Income VAT	Creditors VAT Control Code	Petty Account Nominal Code
Cash Book Expense VAT	Debtors VAT Control Code	Petty Account Nominal Code

 

Bank Ledger

Your Bank Ledger records the actual record of payments and receipts. A payment can be exist in any of your three main transaction Ledgers (Sales/Purchase/Sundry Cash). Here you can group and organise payments into deposits to exactly match your Bank statement during the bank reconciliation process.

Your Bank Ledger can include multiple bank accounts, against which to record different types of payments. Each account must have a different nominal code that is used when automatically posting the payment records from SL, PL & SCL in the nominal ledger. Note that you cannot enter a payment/receipt record in SL, PL or SCL without selecting the bank account first.
 

Nominal Ledger

Whilst your Bank Ledger records the actual movement of funds, your Nominal Ledger also considers debit and credit transactions from the invoices in your Sales/Purchase Ledgers. The Nominal Ledger gives you a constantly updated window into the profit and loss for each part of your business. By using the ‘audit by year’ you take a snapshot of your business from which you can view P&L, Balance sheet, Trial Balance and drill down into actual live data.

Your Nominal Ledger audit pulls live data from the all of the financial transactions in your Sales and Purchase Ledgers, and from all of the records in Sundry Cash Ledger and Petty Cash Ledger. The value is posted to the nominal code stored on the record and the other side of the nominal posting is decided automatically as explained above, VAT is also posted automatically to the VAT control account.

The nominal ledger also loads nominal journals, non-financial records that serve only to move figures between nominal accounts. Certain processes in SQLWorks create journals automatically, such as end of year appropriation and changes that affect stock valuation.

The Nominal Ledger can have up to three tiers: Nominal codes, Analysis codes (i.e. Sub Nominal codes), and Department codes, each of which can be crosschecked against another to breakdown spending or revenue in different segments of your business for more targeted analysis. The nominal audit creates a record of the value against each individual combination and then pools together the data as per your reporting requirements.

Your Nominal Ledger provides an understanding of your accounts, which includes amounts owed and owing as well as gained or lost, for financial analysis.

 

 

If your company email password has changed, SQLWorks won’t be able to integrate with your email – here’s how to fix that.

You can update your SQLWorks integrated email password via ‘Preferences’ in the main Nav Bar (1). Clicking ‘User Prefs’ will open your company’s SQLWorks users, giving you access to some of your own accounts settings by clicking your own name on the user list.

This opens the Employee Info window shown above. In the bottom right panel your email settings are saved (2) – here you can update your User ID and Password, along with other integrated email settings such as your email signature.

Higher security user settings can only be changed by a designated system administrator, or the SQLWorks team by formal request.

 

Contact us for more information: 01272 375999

Stock comes in many different forms, so SQLWorks stock ledger can be set to value stock, per item, in four different ways – known as stock costs:

1. Default Purchase Cost – specify a purchase cost against any stock item in any currency, and when you buy in that currency, SQLWorks will match the costs using the appropriate exchange rate.

2. Average Cost – this is an average taken across all purchase invoices over the total quantity of stock. Accurate to up to 4 decimal places, this can be recalculated with a right click or set to automatically update via Preferences > Accounts Prefs > Stock. If no stock is available average cost will estimate an average from recent sold stock using your invoices.

3. Standard Cost – Your custom valuation, not derived from any financial transactions in the system, and used to give a stock item an arbitrary value.

4. Batch Cost – Used for advanced warehousing, batch cost records the cost of each item from a specific purchased batch, and can vary between batches, allowing for more accurate manufacturing, re-sale and accounting.

On costs/landed costs, accounting for extra stock costs obtained with freight charges, duties and import taxes, can also be recorded specifically or as averages, and users can specify whether to include or exclude on-costs from their stock valuations.

When generating reports in SQLWorks, users can specify the default valuation for your stock from among the stock cost methods, choosing the one most appropriate for your business. By setting a default cost type, this also affects your Sales Ledger, directly affecting profit and associate reports.

 

Learn more about SQLWorks stock today: http://www.sqlworks.co.uk/stock/

Project management is a powerful function of SQLWorks CRM, which allows users to collaborate on bigger projects and coordinate work from different areas of your business.

With careful planning, you can use SQLWorks’ Projects tool to more easily collate your team’s efforts towards an overarching goal onto a single dashboard, saving time and money.

‘Projects’ can be accessed under the SQLWorks CRM dropdown in the main navbar (1) and displays your live projects within the list panel (2). Key information and editing buttons for the selected project is displayed at the top of the main window (3).

SQLWorks Projects acts as a collection point for entries from across SQLWorks (including financial elements, tasks, documents and much more) relating to a chosen project, in one place under the correct tab (4). You can create new linked items (of any type) direct from projects by right clicking the correct window from within the project screen, which will also added in the relevant section elsewhere in SQLWorks. For example, a new phone log created inside “projects” will also display in SQLWorks phone logs.

This becomes most powerful in reverse however – when creating new entries elsewhere in SQLWorks, users can tag this as part of a specific project. This is the case for almost any SQLWorks item (including individual lines from quotes, orders or invoices for project costings) which can all be linked to an open Project.

SQLWorks can have multiple project types for managing different sorts of projects at once, each with their own data capture or layout – for example, financial projects may require access to financial entries from SQLWorks Accounts. The SQLWorks team can add new project types for your business on request.

For staged projects, a SQLWorks project can be segmented into saved ‘Stages’ which prompt automatic action when reached, for example emailing a contact or completing a task.

Security groups prevent unauthorised users from accessing restricted projects, or sections within a certain project (for example: confidential data) and this can also be configured on request by the SQLWorks team.

SQLWorks Projects can help you easily gather information and organise stages of a more complex set of related jobs, or pool the work of a larger team in a coordinated way.

 

For more information on SQLWorks CRM tools, contact our team today: http://www.sqlworks.co.uk/contact-us/

 

Lineal Software Solutions have launched of our new sqlworks website for our SQLWorks Business Management Software (www.sqlworks.co.uk).

Managing Director of Lineal, Mike Matthews, explained: “This is a big year for SQLWorks, as we’re due to release Version 8 in conjunction with the release of Omnis 8, and we wanted to overhaul our SQLWorks website too.”

“We always aim for our software to work how you work: we’ll now be offering 3 different delivery models to suit different businesses’ needs, with SQLWorks available in on-premise, hosted and cloud versions.”

SQLWorks, Lineal’s leading software for Accounting, CRM & Stock Control was first developed for manufacturing in 1983, and has evolved substantially over 33 years.

Keeping up with the times, the new website has been designed to be fully responsive, for use on mobile and tablet devices. More and more people will use SQLWorks on the move in the future, from a variety of devices, so the SQLWorks website should mirror this.

Existing SQLWorks users will also receive additional support, accessing learning materials via the SQLWorks News page. Extra features, including a live SQLWorks demo and our SQLWorks help guide, will be available soon – watch this space!

 

Discover SQLWorks today: visit www.sqlworks.co.uk or call 01271 375999