SQLWorks V10 Live on Big Sur & Windows 10 (20H2)

Operating System Update:

SQLWorks Version 10 is officially compatible with Apple macOS 11 (‘Big Sur’) and Windows 10 October 2020 Update (’20H2’).

Our SQLWorks Software Development Team – which uses both Apple macOS and Microsoft Windows 10 for development – works hard to ensure our software maintains the best possible lifespan and interoperability, without the need for companies to spend on paid version upgrades.

big sur

Big Sur introduces a number of changes to Apple macOS, including visual enhancements, updated notifications, and performance improvements such as the ability to install updates prior to a restart.

Windows 10’s October 2020 update, coded 20H2, introduces a number of Windows 10 Start menu, taskbar and visual enhancements, and changes to Windows’ Settings controls.

In testing, SQLWorks performs around 5% faster under each operating system.

Although we generally recommend users do not install operating system updates on mission-critical devices during OS beta-testing, or immediately at point of new version release, keeping IT platforms up to date is both an important cybersecurity and business continuity measure – and users should seek to move to the latest operating systems once tested successfully.

 

Speak to our SQLWorks Team today.

Introduction to Production Planning

Production Planning


We’ve extended SQLWorks to include more powerful production planning/process routing in Version 10 – allowing Production Managers to masterplan working spaces, types of work, and employee skills to organise manufacturing capacity more effectively.

Workshop Map can be opened via the Products module in the NavBar, and uses three key elements:

  • Work Centres
These are places where work is done – normally a specific location or tooling area on the factory floor, and remember important data such as available working hours, setup/lag costs and more.
  • Processes
This is a type of manufacturing process – such as assembly, welding, mixing, painting etc, and can be restricted to specific work centres or employees.
  • Employees
This is the employee table used in SQLWorks CRM – listing your company’s available staff.

Each Process Route has a series of numbered steps (carried out in a specific order) called a Work Flow. To organise the Work Flow, the production manager simply chooses the Work Centre, Process, and Employee that is assigned at each step – by dragging and dropping them into the Workflow builder.

Workflow steps each carry associated costs and manufacturing times, allowing the system to build a comprehensive picture of the process route a finished product must follow to be completed in full.

production planning

Production managers can save Template Process Routes and assign these to Bills of Material – with the right default process routes being loaded automatically on new Works Orders to save time. Expected completion times are estimated automatically, and progress can be logged as each step of the Workflow is underway

Any Process Routes that are currently in use will be shown in the ‘Active Process Routes’ table, along with the details of the BOMs being produced which follow that process route.

Production Managers can also use this part of SQLWorks to generate reports (either from the perspective of Work Centres, Processes or Employee) to see outstanding and current Works Orders, and to gauge capacity from each.

This helps inform staffing decisions, shift patterns or identify production bottlenecks. Where there is a clash (for example, if a ‘Welding’ process employee has more welding hours due on Works Orders than is available in the calendar), SQLWorks will display ‘CLASH’ in red next to that Bill of Materials.

Overall SQLWorks’ Production Planning gives Production Managers the power to coordinate working spaces/resources, types of work, and personnel for maximum control. Production Routes help structure and streamline the manufacturing process, and organise manufacturing capacity more intelligently.

 

For expertise and software assistance, please contact our SQLWorks Team today

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 requirements 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 identity 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


 

sqlworks contact

Discover More


Simple, fast and intuitive data entry. Detailed, responsive and targeted data analysis.

 

 

 

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.

Did you Know? Local Resources & Printers

For those using SQLWorks Hosted, the ability to access SQLWorks anywhere is a major advantage. However, doing this may mean you need access local resources to print a document from SQLWorks, connecting to a new printer on a network that is unfamiliar to SQLWorks.

To do this, you will need to allow your saved Microsoft Remote Desktop connection (where Hosted SQLWorks is accessed) permission to access your printer (one of your local resources ) You can either do this when first setting up your connection to SQLWorks Hosted, or edit your settings to include this option later.

On Windows, this option is available by editing your saved Remote Desktop Connection, and clicking on the ‘Local Resources’ tab. Tick the ‘Printers’ checkbox to allow printing from Hosted SQLWorks to your local printer.

hosted printers rdc windows

On Mac, this option is available by editing your saved Remote Desktop Connection, and clicking on the ‘Local Resources’ tab. Tick the ‘Printers’ checkbox to allow printing from Hosted SQLWorks to your local printer.

hosted printers mac rdc

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.

Introduction to Document Management

SQLWorks includes Document management capabilities to allow each user to save documents into the system for extra convenience.

Files from the user’s device can be added from the user’s device, or any file location the user’s Windows/Mac device has access to (with modify/write permissions).

To save a new file into SQLWorks, look for any window which includes a ‘Documents’ or ‘CRM’ tab. Files may be dragged into the files list (a large white space) from the Windows/Mac operating system (eg: off the desktop) or from the small file tree viewer in the bottom right of the SQLWorks window.

document management

The Document Management save window opens to confirm the details of the file – here files can be categorised using any pre-established Document Analysis types and given a description. Clicking ‘Save & Close’ will save the new document into the list, represented by a new thumbnail showing the file-type if known.

Right click on any saved document to open the original file or perform further functions with it.

document management

The new attachment is stored with a database link to the area of SQLWorks it has been saved against – files can be linked to company records, financial order or transactions (eg: sales or purchase orders), sales leads, projects and many other areas of the platform, to be more easily found by other users.

Typical document management uses include:

  • Adding documents, presentations or images to a project file.
  • Saving purchase orders from a customer against a new SQLWorks sales order.
  • Archiving product designs or specifications against stock items.

For CRM expertise and assistance, contact the SQLWorks team today.

SQLWorks is changing…

 

Lineal will be launching a new major version of SQLWorks in 2017.

Version 8 will bring a host of new features to our flagship business management software, as well as provide existing SQLWorks customers a greatly improved user-experience.

Managing Director of Lineal Mike Matthews explained: “We were determined to release a major new version of SQLWorks this year, and wanted to implement the customer feedback we’ve been gathering in recent months.”

“By changing to the StudioWorks 8 framework, SQLWorks Version 8 will allow us to update the technology behind our business software – modernising the visual ‘look-and-feel’ to be more intuitive, adding greater flexibility, and offering more options for integration.”

Version 8 is expected to be available from Autumn 2017 – check back for more soon!

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.