SQLWorks Manufacturing Launches

 

Announcing Version 10:


Lineal Software Solutions are excited to announced the public release of our next generation of SQLWorks software.

Version 10 of our flagship business management suite harnesses more advanced manufacturing capabilities for the first time – introducing brand new material resource planning (MRP) capabilities into our existing integrated accounting, CRM & stock control platform.

Automation is critical to productivity. SQLWorks MRP allows businesses to instantly gauge future demand for stock items & materials based on a flexible time horizon and existing stock availability, automatically generate purchase orders for approved suppliers, automatically roll-up part and cost changes through bills of material, and automatically create works orders for production centres on the factory floor.

 

MRP software

“… We are clear that the faster adoption of technology will result in greater investment and in more manufacturing taking place in the UK.”

 

UK Gov ‘Made Smarter’ Manufacturing Review

 

 

These hotly-anticipated new features will help drive real business benefits, especially among manufacturing and logistics companies: including more intelligent and cost-effective purchasing, optimised stock holding, and coordinated forward planning of production.

Factory managers can now backflush manufactured items, auto-attach engineering documents, optionally roll-up updated part-costings from purchasing through the relevant kits, and even import new assemblies from popular engineering CAD software via drag-and-drop.

 

 “… British manufacturing needs a factory reset.”

Mike Matthews, Lineal Software Solutions

 

MRP is an immensely powerful tool for running a business – and we’ve given users the ability to drill-right down into purchasing and production recommendations – finding the exact source of demand from potentially thousands of orders, to line level, with a simple double-click.

SQLWorks manufacturing abilities integrate seamlessly with other business processes across accounting, CRM and stock control – and we’re planning further extensions to functionality for release later in 2020: including detailed capacity planning, support for ‘Just-In-Time’ (JIT) style manufacturing, and more complex ad-hoc report building.

 

sqlworks versions

 

We’ve also made some updates to the visual identify of SQLWorks with this iteration to help make our software feel smoother and more accessible to new users, and expanded Lineal’s UK Software Development Team of Omnis developers to hasten our development cycle.

Mike Matthews, Lineal’s Managing Director, explained: “This is a terrific new leap forward for our SQLWorks software. The new release is our most advanced ever, and introduces powerful new manufacturing and logistical control to our existing business management tools.”

 

manufacturing

Measurable Business Benefits


  • One, fully-integrated platform
  • Heightened financial visibility
  • Hours of work duplication saved by automation
  • Greater manufacturing control
  • Optimised spending & stock holding
  • Genuine support for business continuity

 

 

“We believe the ability for industry to automatically complete important engineering tasks – like importing newly-designed assemblies, production planning, updating part costs and forecasting future operations – will prove a popular choice among manufacturers.”

“Post-lockdown many firms will be doing some serious soul-searching about whether their systems are really up to scratch. British manufacturing needs a factory reset. If you can’t innovate then you’re at a dead end, and modernisation will be an important part of the UK’s economic recovery.”

SQLWorks Version 10 with MRP is available NOW

 

Learn more at www.sqlworks.co.uk or by contacting our UK Software Development Team today.

Tracking Customer Satisfaction

We recently rolled out ‘Client Review’, a simple way of tracking customer satisfaction using SQLWorks CRM.

The new ‘Client Review’ tab, which is available when you select a Company in SQLWorks, can be used by your staff to keep a log customer happiness, which is graphed over time.

Adding a new client review entry (such as during a catch-up call, or after a meeting) lets the user record positive and negative notes, score the client’s general approval of your service(s), and records the overall trend over time.

tracking customer satisfaction

A top-level Client Review Report also gives line manager and and company management the opportunity to aggregate this data company-wide, or filter based on team, date, or by different client types.

Keeping track of client satisfaction across a customer base, and encouraging staff to maintain good client relationships, can prove a challenge for many businesses – something SQLWorks Client Review makes much easier.

The data format is flexible – allowing staff tracking customer satisfaction to gather information from catchup calls informally, while keeping an organised schedule for regular contact.

 

For CRM options and expertise, please contact our team today.

Guest Post: Diamedica rises to UK Ventilator Challenge

SQLWorks company Diamedica (UK) Ltd., who manufacture specialist medical solutions, are providing vital support to the NHS as part of the UK Government’s Ventilator Challenge:

Developed by Lineal’s in-house software development team, SQLWorks integrated business management software, is the core of Diamedica’s accounting, order-processing, stock and production control.

(Guest Post Via. http://www.diamedica.co.uk/english/news_detail.cfm?id=3219)


“…Diamedica (UK) Ltd confirmed today they are playing a critical role in the Government’s efforts to accelerate production of ventilators to support the fight against COVID-19. Diamedica’s ventilator designs were shared with the Cabinet Office team leading the challenge, who have been able to match the plans with specialist manufacturers who are able to start ramping up production quickly, and at scale.

Diamedica are now providing consulting services to the matched specialist manufacturers who are contracted to produce ventilators.

Robert Neighbour, Managing Director, commented “We are exceptionally proud to be a part of the effort to deliver ventilators for the NHS. Our product is already the leader within emerging markets and has now been selected to support the UK’s fight against COVID-19. I want to thank our team here at Diamedica for their dedication and efforts thus far, and all the manufacturing partners who are critical to this effort.”

For further information please contact Charlotte Green, Head of Sales and Marketing at Diamedica (UK) Ltd.”

Learn more at http://www.diamedica.co.uk/english/

 

For software enquiries and questions, please contact our team today.

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.