Introduction to Stock Audit and Stock Taking

Stock Audit allows businesses to perform a comprehensive stock take, record variances, verify the results, report on valuation, and automatically adjust stock levels for accuracy.

Stock takes can be initiated, or continued, by clicking on ’Stock Audit’ under ‘Products’ in the Main SQLWorks Navigation Bar (1). To begin a new stock take simply click ‘Create New’ or load an unfinished stocktake via ‘Load Existing’. Each stock take is warehouse specific, and can be given a reference ID.

Users must choose whether the final results will ’Save Quantity’ (adjust the actual quantity to a fixed number established from the stock check) or ’Save Variance’ (adjust the actual quantity according to a variance from the theoretical quantity, incorporating quantity changes which may have taken place during the stock take.)

stock audit type

Clicking ‘Print Sheets’ generates a series of stock take forms, listing the stock items and locations under review, which can be printed and assigned to stock counters for counting. Printed stock take sheets include a notes field for stock counters to record additional information, but do not list the theoretical quantity, so as not to prejudice the accuracy of the stock take.

stock audit sheets

Once stock counters have returned their stock take sheets, stock controllers can enter counted values in the ‘Count’ column next to each item by entering the name of the counter in the ‘Counted By’ dropdown (2) at the top of the window. The ‘Variance’ Column automatically calculates the variance, and a note of the counter’s name is recorded in the ‘Count By’ column (3)

If required, stock controllers can print “check sheets” in order to have questionable variances verified by a second counter, and enter a revised quantity in the same field by using the ‘Checked By’ dropdown at the top of the window (2). The ‘Variance’ Column automatically calculates the variance, and a note of the checker’s name is recorded in the ‘Check By’ column (3). When printing check sheets you may enter a single product code or a csv of codes, each product including its current values for all bin locations are printed on their own page.

To review the records, clicking the ‘Print Variance’ button at the top of the window produces a report on the results of the stock take, grouping the variances on each item across all monitored locations, and calculating a monetary value for the overall positive or negative variance.

By clicking ‘Finish’, the results of either the ’Save Quantity’ or ’Save Variance’ stock take are applied to the SQLWorks Stock Ledger to bring the stock levels back into alignment with the stock take.*

 

For additional information on stock control, contact our team today.

 

 

*If the ‘Free Qty’ tickbox is ticked at the top of the theory column, the theoretical values for the stock audit are shown excluding any allocated quantity. SQLWorks will not accept a variance which adjusts the quantity of an item below the quantity of that item which is already Allocated to Sales Orders, and will instead adjust the Actual quantity as close to the recorded variance as allowed numerically.

stock free

SQLWorks to Make Tax Digital

**NEW Update**

We’re Officially Recognised by HMRC for Making Tax Digital!

SQLWorks Accounting was approved for five key functionalities following demonstration of a sandbox environment to HMRCs review team. Learn more about Making Tax Digital with SQLWorks here.

recognised

 


We’ve updated our SQLWorks software to support Making Tax Digital – with Lineal staff officially demonstrating their work to HMRC’s Review Team during January 2019.

SQLWorks Accounts Prefs can be linked directly with a company’s HMRC VAT Account, granting permission to submit quarterly VAT returns for 18-months before re-authentication is required.

making tax digital authorisation

Making Tax Digital will be available for all SQLWorks Accounts Admin users via the existing VAT Ledger, and allows the accounts administrator to report their VAT return (shown in boxes 1-9) directly to HMRC’s system at the press of a button.

SQLWorks can also report up-to-date VAT account status information (such as obligation, payment and liability entries) from a company’s HMRC account, and access logs recording the full audit trail of communication between HMRC and our software. Once submitted, the company’s VAT return quarter is locked down to ensure security of reporting.

 


Lineal Software Solutions have been officially registered as a provider developing software suitable for HMRC’s new ‘Making Tax Digital’ initiative.

The new tax regulation, which will require UK businesses to undertake tax reporting (initially VAT) via digital links from April 2019, will need approved accounting software to report directly and digitally to a company’s HMRC digital tax account via web API.

Only software which passes a reporting test set by HMRC using example data will be approved for Making Tax Digital (Phase 2 standard.)

Mike Matthews explained: “Currently only around 130 software providers in the UK are registered as developing for direct Making Tax Digital accounts reporting. SQLWorks has had the ability to calculate your VAT return for many years, but very soon, you’ll be able to process your submission direct to HMRC digitally too.”

making tax digital software

HMRC says a quick Hello to SQLWorks during testing…

“HMRC’s main aim is to remove any re-keying or manual re-processing of data – which will make SQLWorks the perfect integrated solution for processing business all the way from quotation to sale, to direct VAT reporting.”

“The government have recently altered some of the software rules being put into place for making tax digital, but we’re hard at work to make sure all SQLWorks customers can begin reporting VAT digitally from next year.”

Recent figures collected by The Institute for Chartered Accountants have suggested awareness of Making Tax Digital is still very limited, with less than half of businesses stating they were unaware of changes that are about to come into force.

This Page will be updated periodically with the latest SQLWorks Making Tax Digital news – please check back for updates! 30.10.18

For an effective, integrated software solution – contact our team today.

Introduction to Audit & Real Time ‘Live’ Reporting

Using SQLWorks Audit, accounting managers can generate key financial reports either ‘Live’ using real-time data, or from an enforced point in time.

This feature is available using the ‘Audit’ tool. When this tool runs, SQLWorks collates the most up-to-date financial data available from the accounts, to use for financial reports. Auditing can be performed immediately before the creation of a new report, by ticking the ‘Audit Matrix’ checkbox in the report options, to ensure the report shows ‘live’ data.

If the checkbox is left unticked, SQLWorks will report using figures from the last time the accounts were audited.

audit matrix

 

Auditing can also be run independently from the ‘Audit By Year’ option in the main SQLWorks Navbar, by right clicking on the financial year in the main list and clicking ‘Audit Year’. The adjacent column displays the date of the last successful audit. This can be used to manually designate an official Audited point in time, from which reports are run, until you are ready to re-audit.

‘Live’ data reporting is normally the preferred option, as it permits accounting managers to get an instant snapshot of the exact state of the business accounts at that moment in time.

audit live reporting

Reporting from the last audited point in time may be more useful in certain situations however. On systems with large numbers of transactions being entered, some businesses prefer to draw a line in the sand, and report consistently from this point in time, until ready to perform the next official reporting audit.

audit reporting

To learn more about SQLWorks financial reporting, contact our team today.

Did you know? SQLWorks Cloud Link

SQLWorks includes a useful ‘drag and drop’ facility for saving documents against projects, sales leads, accounting records and more.

If your organisation stores files in a cloud storage app, SQLWorks can be integrated directly to view these folders in your ‘Documents’ tab, and files can be dragged and dropped into SQLWorks directly from the cloud.

This option can be set up from the main Navigation bar via Preferences > User Preferences > (User) > and by clicking the Setup Tab. By saving the file-path of your cloud app’s desktop folder into the ‘Remote/ Cloud Folder Path’ field, and clicking ‘Save & Close’, a SQLWorks user’s document tree will automatically default to view the chosen file location.

sqlworks cloud link filepath

As long as your cloud app on your PC/Mac is able to sync to the cloud, SQLWorks will be able to make most up-to-date version of your synced files available for drag and drop.

document management

This can be a useful way to make documents collected during fieldwork (eg: photographs) available to a main office – syncing direct from a smartphone, via your cloud app of choice, to be dragged and dropped against projects in SQLWorks.

Options include Microsoft OneDrive, Google Drive, Apple iCloud and Dropbox, as well as many other cloud file storage applications with a read/write access ‘desktop folder’ style client. (If you’re using a lesser-known cloud storage service with SQLWorks cloud link – we’d like to hear about it!)

This tool can also be used with a valid filepath to a location on a traditional on-premise server, and may be useful for businesses with very complex file structures, to help users automatically find the file location they would normally use for managing documents.

SQLWorks cloud link helps leverage all the flexibility of your favourite cloud app, to gather important files into your CRM, accounting and stock control system.

For additional support and assistance, please contact our SQLWorks team today.

Fact Sheet: Accounting Locks

SQLWorks includes a range of accounting locks which allow data entry for business accounting to be restricted to certain time periods.

SQLWorks operates date based-accounting rather than ‘Period-based accounting’ in the commonly understood sense – this gives companies greater granularity over how accounting is controlled.

Because of this, SQLWorks accounting can be locked down* based on a number of different periods and conditions, depending on your preference:

  • Financial Year Level Locking
  • Monthly Locking
  • VAT Period /  Quarterly Locking
  • Appropriation Locking

 

Financial Year Level Lock

Year Level Locking is available from Audit > Audit by Year in the main SQLWorks Navbar, by right-clicking on the financial year and selecting ‘Lock Year’.

year locking

Financial years that have been locked will display a ‘Yes’ in the ‘Lock’ column of the financial years list, and will prevent SQLWorks users from making any changes to financial transactions within that year. However, nominal journals may still be posted to a locked year.

This lock should only be used by your SQLWorks Accounting Admin, and acts independently of all other accounting conditions.

 

Monthly Lock (Current Financial Year Only)

This lock can be made available in your Accounts Prefs, where individual months, or months within specific ledgers, can be locked or unlocked for current financial year.

month locking

By default, users can only post in the designated active financial year – however transitionary options are available here to allow temporary posting into the final period of the previous financial year if this is still Year Level unlocked.

Because this lock can be turned on/off by a user with sufficient privileges and are always reversible, this forms a ’soft’ lock accounting managers can deploy as a highly flexible ‘Month-end’ control or similar.

 

VAT Locking (Quarterly Lock)

The SQLWorks VAT Ledger allows users to calculate the UK tax return due for each VAT Quarter.

vat locking

Once the VAT return has been complete, the date period covered by the specified VAT Quarter will be automatically locked against further accounting entries.

Reporting VAT accurately is a legal obligation, and additional transaction entries will not be permitted into the locked Quarter once VAT has been calculated for reporting to HMRC. Journaling between nominal codes is still permitted.

 

Appropriation Locking

Once you have set retained profit for a financial year (‘appropriated’ profit) the financial year will be locked, even if the financial year has not yet been Month, VAT or Year Level locked yet. No further transactions may be created in this year.

Because of this, Appropriation is usually only completed once year-end processing for that financial year has already been completed. For more information, please read: “1.1.2.4 – How to Set Retained Profit.

 

*Under certain circumstances some accounting locks can be reversed – please speak to your SQLWorks team about this in more detail.

SQLWorks V8 – your thoughts?

With SQLWorks Version 8 debuting later this year, we’re gathering feedback on what our clients would like to see after the upcoming major upgrade.

Version 8 will be our opportunity to make considerable improvements to both the technical capabilities and user experience of SQLWorks.

Our team’s development priorities have been shaped by the feedback our users have given us in recent weeks and months – please let us know your thoughts below:

Did you know? Importing Journals

SQLWorks Accounting includes the option to enter Journals both manually, but also offers the chance to save time by importing journals from a spreadsheet of data directly to your Nominal Ledger.

When in the Nominal Ledger click ‘Journal’ in the top toolbar, and the add Journals window opens. To begin importing your journals, click the ‘Import Journal Option, and browse for the file you wish to import.

Imports must be imported using a fixed format from a template file: a copy of which can be found within your SQLWorks installation ‘Misc’ Folder as a Microsoft Excel spreadsheet – or downloaded here. You will need to enter your data and save the file as a tab-delimited text (.txt) file before importing.

SQLWorks will warn you if the data you are seeking to import is old, and may block you from entering nominal journals into locked accounting periods.

Once importing journals has run successfully, your nominal journal data will appear in the list of journals to be added, and users can commit them to the Nominal Ledger by clicking ‘Save and Close’.

 

For accounting advice and support, contact the SQLWorks team today.

Fact Sheet: Security Permissions

SQLWorks includes two levels of security permissions: Group and User security.

  1. User security states which parts of SQLWorks a user has access to (visible within menus) and does not have access to.
  2. Group Security sets permissions for groups of users, including every user in that group and overrides an individual’s security settings.

To review your SQLWorks users, click the ‘System Administration’ button on the main navbar. If you wish to review your users, click ‘Users.’ This displays a table with every valid SQLWorks user at your company, and administrators can double click to view or edit an individual’s user settings.

To review your SQLWorks groups, click ‘Groups.’ This displays a table with your saved Groups of users. You can also add a new group, copy or edit any existing group from this table.

To change your security settings, click ‘Security’ (1). This loads your list of groups in the left hand list, with the users contained within any selected group in the right hand list. By clicking the ‘Add’ or ‘Remove’ buttons you can add or remove individual users to the correct group.

By using the ‘Group Windows Security’ Tab along the top, you can also set the permissions for that group (and therefore the users contained within it.) Grant access by clicking the checkboxes next to each area of the system, and  give ‘Basic’ (find, add new or edit) or ‘All’ permissions (find, add new, edit, edit multiple or delete.) (2)

There are no limits on the size or number of groups users can be assigned to, so your permissions structure can be as simple or complex as your internal company policies require. Please ask the SQLWorks team if you need help or advice on setting up security permissions settings, or on IT security best practice.

By default, SQLWorks has one ‘Admin’ group which has administration permissions for the Sales/Purchase Ledgers, Stock Ledger, Finance and CRM sections. This can be changed to different groups in larger organisations – for example to designate a different administrator for sales/purchasing.

Once you have your users and groups configured correctly, simply close the System Administration window, and your SQLWorks security permissions will be in place when each user next logs on.

 

SQLWorks Security Permissions


Bank Ledger – Security permissions for managing Bank accounts and cash accounting

Bank Accounts – Lets users see Bank accounts within the Bank Ledger.

Bank Transactions –  Lets users access options for bank transactions within the Bank Ledger.

Petty Cash Accounts – Lets users access any petty cash accounts.

Sundry Cash Ledger – Lets users access the sundry cash ledger for cash payments.

Sundry Cash List –  Lets users access the global table listing all sundry cash payments.

 

CRM System – Security permissions for ‘SQLWorks CRM’ functions

Actions – Gives access to the Actions Table.

CRM Links – Admin Only. Allows users to link CRM items, for example: attaching a document to a lead.

CRM Prefs – Allows users access to edit system-wide CRM preferences under ‘Preferences.’

Diary Calendar – Allows users access to the diary window.

Diary Entries – Lets users access entries to the diary.

Layers – Lets users edit types of appointment, e.g.: Meeting, Visit etc.

Lead Categories – Lets users use custom checkbox categories to categorise leads.

Lead Sources – Allows users to use the editable dropdown noting where a lead originated from.

Leads – Allows users access to the Leads window.

Phone Logs – Lets users access the phone logs table.

Project Types – Admin only. Lets users access project types.

Projects –  Gives users access to the Project window.

Tasks – Gives users access to the task tables.

 

ISSAccountsPrefs – Security permissions for setting SQLWorks ‘Accounts’ preferences

Accounts Prefs – Financial Management ONLY. Gives users access to system-wide accounting preferences under ‘Preferences.’

Day Book – Gives users access to the day book.

ForX – Gives users access to amend system currencies and foreign exchange rates (multiple currency) accounting.

Message Sets – Gives users access to edit various option lists – eg: ‘why a quote is cancelled’ field answers.

VAT Ledger – Gives users access to the VAT Ledger for calculating VAT submissions to HMRC.

 

Documents – Security permissions for ‘Document Management’ functions

Crystal Reports – Deprecated feature. Lets users import Crystal Reporting.

Document Analysis – Gives users access to edit the custom document type category checkboxes when uploading a new file.

Documents – Gives users access to files uploaded to SQLWorks.

Emails – Gives users access to emails linked into SQLWorks.

Email Browser – Gives users access to the email browser which synchronises to their email account.

Icons – Gives users access to amend the preview icons which load on screen when using Documents within SQLWorks.

Letters – Currently unavailable. Gives users access to SQLWorks letter writing tool.

 

IssPRList – Security permissions for the main ‘Companies’ list and associated data management tools

Address Editor – Gives users access to the full table of recorded addresses.

Client Lists – Allows users access to SQLWorks fixed and dynamic list building tools.

Client Types – Allows users to set custom checkbox categories for categorising companies.

Companies – Allows users access to the Companies List.

Contact Data – Allows users access to the contacts table (listing each company’s recorded contacts.)

 

IssPurchase Ledger – Security permissions for Purchasing

Purchase Accounts – Lets users see their Purchase Accounts with recorded suppliers.

Purchase Ledger – Grants users access to the Purchase Ledger.

Purchase Orders – Gives users access to Purchase Orders.

Purchase Transactions – Gives users access to Purchase Transactions.

Purchase Transaction List – Allows users access to the global table listing all purchase transactions.

 

IssQuotesOrderSales – Security permissions for Sales

Contracts – Lets users access contracts system.

Customer Order –  Allows users access to the Sales Orders panel within the Sales Ledger.

Customer Quote – Allows users access to the Sales Quotes panel within the Sales Ledger.

Directors – Lets users access the recorded list of directors for each company.

Disbursements – Gives users control over sales disbursements (e.g.: expenses, mileage etc.)

Sales Account – Gives users access to each customer’s sales account details.

Sales Account List – Gives users access to their list of customer sales accounts in the Sales Ledger.

Sales Ledger – Allows users to access the Sales Ledger window within Accounts.

Sales Ledger Detail –  Gives users access to unlocked detail lines on Sales Ledger quotes, orders and invoices.

Sales Ledger Transaction – Allows users access to the Sales Transactions panel (Invoices, payments and credit notes) within the Sales Ledger.

Sales Order List – Allows users access to the global table listing all customer sales orders.

Sales Quote List – Allows users access to the global table listing all customer sales quotes.

Sales Runs –  REDUNDANT

Sales Transaction Archives – Allows users access to the global table listing all archives customer sales transactions.

Sales Transaction List – Allows users access to the global table listing all customer sales transactions.

SL Web List – (Top Secret Work in Progress. Shhhh!)

 

IssSQLWorksMain – Security permissions for managing SQLWorks itself

Audit Logs – Gives users access to the ‘audit log’ of users actions within SQLWorks.

Binary Objects –  Controls template images and more. Should be enabled by default.

Database Table Viewer – For Lineal Use Only

DB Sessions – Lets users see logged-in SQLWorks sessions.

Employees – Lets users see the recorded list of company employees.

External Databases – For Lineal Use Only. Allows access to secondary databases if required for external document stores or alternate companies.

Help – Gives users help shortcut to SQLWorks online assistance. Please see www.sqlworks.co.uk/help

Label Prefs – Allows system admin to define system-wide user-defined fields. Should be locked by default.

Refs – Lets users access reference lookup lists and set start points, e.g.: first invoice number.

Server Logs – For Lineal Use Only.

SQLWorks Prefs – Management ONLY. Lets users access system-wide SQLWorks Preferences.

System Monitor – For Lineal Use Only.

User Logs – Lets users access the recorded log of user logins.

User Prefs – Lets users set the user preferences of their own SQLWorks account.

Years – REDUNDANT.

 

Nominal – Security permissions for the Nominal accounting and company finances.

Analysis – Lets users access the accounts ordered by analysis code.

Audit By Code – Lets users audit by nominal code and run nominal reporting.

Audit By Year – Lets users audit by financial year and run nominal reporting.

Budget By Year – Lets users access and compare against recorded financial budgets.

Dashboard – Lets users access the SQLWorks account dashboard.

Departments – Lets users access the accounts ordered by department.

Financial Years – Lets users set system-wide financial year start/end dates.

Nominal Journals – Gives users access to Nominal Journals.

Nominal Ledger – Lets users access the accounts ordered by Nominal Code.

Nominal Audit List – Grants users access to ‘audited’ data calculated from the nominal ledger for financial years.

Nominal Code List – Allows users access to the list of nominal codes defined within the nominal Ledger.

Nominal Journals – Allows users access to Nominal Journals within the Accounts.

Nominal Ledger – Allows users access to the Nominal Ledger (General Ledger) Window within Accounts.

Standing Journal Items – Allows users access to standing journal entry line details for each journal.

Standing Journals –  Allows users access to the Standing Journals window.

Standing Journals Group – Allows users access to standing journal entries.

 

Products – Security permissions for managing Stock

Assets –  Lets users access the ‘Assets’ tab of equipment linked to a company.

Bin Locations – Allows users access to stock ‘bin’ locations within each warehouse.

Dealers – Allows users access to set dealerships, defining both approved suppliers and customers for a stock item, and cross reference the two (eg: for hazardous materials.)

Order Allocation –  Allows users access to SQLWorks stock ‘Order Allocation’ tab in for reserving stock for specific customer orders.

Pricing and Discounting – Allows users permission to set current and future price break rules for stock items.

Stock Allowed –  Gives users access to approvals list, restricting warehouse bins to holding only specific stock items.

Stock Audit – Gives users access to Stock Audit to perform stock takes.

Stock Browser – Allows users access to the stock browser table of all stock items.

Stock Groups – Allows users access to stock groups, to which any stock item can be assigned.

Stock Ledger – Allows users access to the Stock Ledger.

Warehouse Map – Allows users access to the Warehouse Map displaying warehouses, bin locations within these, and stock items within those bins.

 

Fact Sheet: Works Orders

To compliment SQLWorks manufacturing and kitting, Stock Ledger allows users to create and manage manufacturing works orders to different degrees of detail.

(For an introduction to SQLWorks manufacturing and kitting, click here.)

Works Orders are accessible from the Stock Ledger screen, under the ‘Products’ module, in the main NavBar (1), by clicking the ‘Works Orders’ tab for a chosen stock item.

The two tables on the left-hand side show ‘Active Word Orders’ still being worked upon, and ‘Completed Works Orders’ which have been finished (2.)

To the right the ‘Build Quantity’ (3) Panel shows the parts needed for that stock item, how many are available in the default warehouse to use for this works order, and the maximum finished items that can be built from these parts.

The lower right panels (4) show a summary of the scheduled builds on a selected works order, and the parts required for each of these scheduled builds (in case the Works Orders vary between builds.)

 

Quick Build

Users can complete a simple works order by right clicking in the ‘Active Works Orders’ and choosing ‘Quick Build.’ This simplified option checks the correct parts out of stock from their default warehouses, completes a Works Order immediately, and checks in the finished item into stock in its default warehouse.

This is useful for simple builds where no extra works order detail is required and the works order doesn’t need to be drafted in advance.

 

Full Works Order

Users can create a full new works order by right clicking in the ‘Active Works Orders’ and selecting ‘New Works Order’.

This opens a new works order window for the chosen stock item– these can be given header information including a Total Build Quantity. Parts for kitting will be taken from the ‘Take Stock From’ Warehouse code, and (via the designated build bin) the finished item will be checked into the ‘Build Product Where?’ Warehouse code and Bin number.

Each line on the Works Order represents one ‘schedule’ for building a given quantity of the kit – with the quantity of that schedule enterable on the left hand side. A component list is also shown here, to help inform production numbers.

The middle column (‘Cost Groups’) displays advanced Construction Time / Cost Centre additions for this kit if this feature is turned on in SQLWorks.*

The ‘Build Group Column’ is used for the actual building of the works order: typing a quantity into the ‘Take’ field and clicking ‘Take’ removes the required parts from the ‘Take Stock From’ warehouse, and doing the same in the ‘Build’ field and clicking ‘Build’ assembles the new kitted item and moves it to your designated ‘Build Product Where?’ Warehouse and Bin.

You can also cancel quantity’s from the Works Order by typing a quantity into the ‘Cancel Qty’ field.

On the right hand side of each line the ‘Inspection Group’ allows you to enter up to four custom quality testing/inspection checkpoints for each works order schedule, date-stamped for approval.

Works Orders can be saved without being built (to schedule future work), but when the ‘built’ quantity within the works order and any cancelled quantity added together equal the ‘Total Quantity’ required, the works order will automatically be moved to the ‘Completed Works Order’ list.

 

*Construction Time / Cost Centres

Advanced users can turn on ‘Default Construction Costs (per Hour)’ and ‘Default Construction Times (per Hour)’ which will appear at the top of the Works Order Tab if used.

This allows the user to save details for time taken, and costs expended, as the finished kit is processed through up to a maximum of six stages to complete the Works Order, and can be factored into sales costs accordingly.

 

Did you Know? Quoting Tips

quoting tips

Quoting a customer can be a delicate process, and sometimes you need to be able to issue a quote with detailed options. We’ve collated a few handy tips to help your sales team build the perfect SQLWorks quote.

If you’re putting together a more complex quote, it can sometimes be useful to give a customer options. You can create these by right-clicking on the line numbers on the left of each quote line, and selecting ‘Choose Option Group’ to place groups of lines under ‘Option 1’ ‘Option 2’ subheadings (1.)

These options are normally alternatives to each other, so you typically won’t want SQLWorks to total them together. You can remove the overall total by switching to the to ‘Extras and Project’ Tab in the top right of the quote header, and unchecking the ‘Print Totals’ checkbox (2.) This will remove the ‘grand total’ from the bottom of the normal quote template (please note that if you exclude VAT you’ll need to include an amendment to this effect, as depending on your settings, the total VAT may no longer be visible.)

If you need to include sub-total lines instead for each option group, the easiest way is to add a sub-total line at the end of each group. By right clicking on the grey background of any given line, you can choose ‘Toggle Line Type’ to change a line to display the sub-total of the group immediately above it, to be hidden or to become a comment line without any costs (3.)

The area around the line number will change to a different colour to reflect the line type (1), and the quote template will change to incorporate the new line type. This is useful to help keep your quote clear and tidy – to add a running sub-total, line gaps or comments.

With these extras it’s easy to build more complex quotes from SQLWorks, and give customers an informative choice.

A Quick Disclaimer: if you have a custom quotations window for your company/organisation, one or more of these quoting tips features may be disabled. If you need them – speak to the SQLWorks team!