If a business harnesses important physical assets, keeping track of these over time quickly becomes essential.
Whether it’s your own machinery, or a piece of equipment you maintain for a client, attributing costs to these accurately is an key part of your business financial planning – and helps you make smarter decisions about future investment.
SQLWorks supports this process with a dedicated asset register – allowing the user to save a range of information (including make, model, warranty and more) for both in-house and client assets to aid day-to-day business operations. Asset Register can be found in the Stock Ledger, and helps the user build a centralised and definitive list that can be controlled with permissions groups, like any other SQLWorks Ledger.
For in-house assets, SQLWorks users can also link these assets to Purchase Orders – ensuring that asset’s data contains a detailed maintenance history that includes financials.
Helpfully, this also works across multiple Purchase Ledger suppliers, so that maintenance costs (such as repairs or replacement parts) remain accurate even if an asset’s service contract changes hands. This helps a company stay flexible, since accounting and contract periods may be much shorter than machinery lifecycles.
Assets may also be optionally enabled as a special tab in a customer’s Sales Ledger account – ensuring a service engineer can easily access known information about a client’s asset as a part of routine account maintenance. This might include location, serial numbering for identification, or notes on past repair work.
SQLWorks ensures business managers can properly document and maintain a full asset register – itself an asset to a well-informed team.
For expertise and software assistance, please contact our SQLWorks Team today
Lineal’s SQLWorks Software is officially registered as a specialist UK digital technologies provider for manufacturing.
Made Smarter is a UK-Government backed initiative launched in 2017, following a nationwide review of the manufacturing sector – and includes a number of private and public sector organisations helping to modernise industry and drive adoption of productivity-boosting technology in the sector.
Recognised fields include a wide range of next-generation technologies for manufacturing such as robotics & process control, data and systems integration, mobile and wearable devices, sensor innovations, machine learning, additive manufacturing and augmented reality technology.
“We’re delighted to see SQLWorks listed among some of this country’s most advanced and cutting-edge technology solutions for manufacturing” said Lineal’s Managing Director Mike Matthews. “The Made Smarter review highlights adoption of modern technology as a keystone for industry in this country, and we want SQLWorks to underpin real advancement and strength in the industry.”
Managing outbound goods often requires an overarching view of business operations ‘as-a-whole’ – looking across all sales accounts, orders and products. We’ve given users the power to do this via SQLWorks Dispatch Planner.
Dispatch Planner gives order managers and warehouse teams a comprehensive dashboard to maximise visibility and control over orders. Dispatch Planner is accessible within the Stock Ledger, and (by default) loads a comprehensive list of all outstanding customer sales Orders with key information about each order.
Double clicking on an order allows a drill-down to the exact order, meaning shopfloor teams don’t need to access individual customer sales accounts to understand workloads and even check line-level detail.
Simple ‘traffic-light’ statuses indicate whether the required stock quantity is available for each order to be shipped in full. By selecting an order, dispatch managers can also view the same information for each order line of the order – with the same status indication based on free stock availability. Orders will only be considered ready to ship in full once every line on that order is available to ship.
When ready to ship, dispatches can be sent to dispatch and invoiced (and emailed automatically to the customer) in one smooth workflow, removing the outstanding order from the Dispatch Planner list.
High volume companies may lengthen or shorten the time horizon of the viewed orders, or filter by warehouse. Where goods are not ‘Ready to Ship’, SQLWorks will make the user aware of why an order is delayed – for example, showing Purchasing Delays.
For companies that use Delivery/Dispatch Notes prior to invoice, the Dispatch Planner will also allow the generation of new delivery notes from here, list any valid delivery note numbers for each order for cross-referencing, and require the user to select an existing delivery note before invoicing a previous dispatch.
Dispatch Planner shows the real power of SQLWorks: as the ability to cross-reference stock control and ordering globally across the business allows you to manage operations quickly, efficiently, and with confidence.
You can find more detail about how to use Dispatch Planner here
Members of Lineal’s Software Development Team were recently invited to join the Omnis Software Engineering Team for a special 2-day visit focusing on development work regarding web features within SQLWorks.
Software engineers from both companies focused the dedicated day on the implementation and deployment of Lineal’s recent online work including business-to-business (B2B) trade ordering portals and online user survey systems.
The SQLWorks Team at Lineal wanted to thank the staff at Omnis for being excellent hosts and helping to craft an extremely useful and informative visit.
Omnis Software recently celebrated 40 Years in the industry, having been founded in 1979 by Blyth Computers Ltd. Co-founder Paul Wright.
Omnis technology has underpinned Lineal’s SQLWorks Business Management Software (integrating accounting, stock control, CRM and manufacturing) since the early 1980s. Lineal’s Managing Director Mike Matthews is a part of the international Omnis Technical Committee, and Lineal staff regularly help coordinate and take part in EurOmnis, the international Omnis software developer conference.
For Software development advice and expertise today, please contact our team today.
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.)
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.
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.
This year Lineal’s SQLWorks Team traveled to Arnhem, The Netherlands, for the 4-day European Omnis Developers Conference – EurOmnis 2017.
Conference workshops offer the opportunity for developers from more than a dozen countries to exhibit their latest work, seek advice from other programmers and share best practice. A primarily educational event, EurOmnis brings together the brightest and best to further develop software projects and draw on a wider pool of knowledge.
Members of the Omnis Executive Team also attended to discuss the very latest developments of the platform, explain new features (such as remote debugging technology working live from the developer console) and gather valuable feedback from the wider Omnis developer community.
Managing Director of Lineal Software Solutions, Mike Matthews explained: “Over the many years during which we’ve helped organise EurOmnis, both the software itself and the Omnis Developers Group (ODEV) have gone from strength the strength.”
“This year’s conference studied some exciting breakthroughs in web development, mobile/tablet-friendly user interfaces, internet-of-things (IOT) examples, future API technology, and much, much more.”
“SQLWorks is designed to be a highly flexible business management software, and we greatly value contributions from the extraordinarily diverse range of industry sectors, creative skills and technical knowledge represented each year at EurOmnis.”
In addition to coding, EurOmnis 2017 attendees had the chance to visit and dine at the Kasteel Doorwerth, a medieval chateaux dating from before the 13th Century, and literary home of the Beaulieu restaurant, where Erik Hazelhoff Roelfzema wrote Soldier of Orange.
See you next year!
Lineal are Omnis and business software development specialists – learn more here.
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:
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!
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.