Using Engineering Documents

SQLWorks Document management has reached the next level, enabling tagging of engineering documents and automated printing alongside Works Orders.

As shown in our Introduction to Document Management, many types of files can be added and stored within SQLWorks, linked to other data, downloaded or referenced whenever required. Our development team have also enabled tagging of specific files as ‘engineering’ documents so they can be automatically transferred through to production.

Saving a .jpeg or .pdf to a stock item’s document tab is a simple drag-and-drop process, supported by tagging with the engineering tag. When a Works order is created for that Bill of Materials, those supporting documents can be pulled through for printing automatically.

engineering documents

This is especially useful for assembly instructions, photographs, blueprints and similar that help guide during the production process.

Setting specific criteria in ‘Accounts preferences’ and ‘Document Analysis’ which can be found on the Navbar, allows a specific ‘tag’ such as one named Engineering, to be selected when saving a document on a stock item. Tagged documents appear in the ‘Documents List’ in the top right of the Works Order automatically, and when printing or previewing your Works Order SQLWorks finds the associated document and asks you to confirm whether you would like to print the engineering documents.

engineering documents

 

This feature is especially useful if you have drawings, assembly instructions or diagrams for example, that need to accompany the Works order when sent to the shopfloor/workshop for the build process.

If you would like to find out more about how SQLWorks can make the Manufacturing processes more efficient and less time consuming, please get in touch with our SQLWorks team via email [email protected] or call 01271 441570.

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.

Manufacture and Kitting

manufacture

SQLWorks includes a manufacture and kitting tool able to budget for and build manufactured products using a selection of saved kits.

Manufacturing is accessible to users of the SQLWorks Advanced Stock, and can be found within the Stock Ledger screen under the ‘Products’ module in the main Navbar (1).

Clicking the ‘Kit Details’ Tab opens the kitting information for the selected stock item (2), and users should click the ‘Setup’ button if using these tools for a given stock item for the first time. By default, SQLWorks saves up to 3 alternate builds for each manufactured item (although more are available) with saved descriptions for each build (3).

Each stock item in your SQLWorks stock ledger can be both a ‘parent’ (made from its stock item ‘children’ – its components) or a ‘child’ of another stock item ‘parent’. Right-clicking opens options to ‘add child’ (component part) including values for both the components and associated labour costs.

Saved builds can include many components, sub components, and more levels as needed.

On the right hand side of the panel (4) are fields displaying the ‘Base Component Cost’ (the total value of the component parts as worked out by your saved SQLWorks stock valuation model) the ‘Marked Up Component Cost’ (the total markup value once percentage markups such as labour or assembly costs have been applied to each component for this build) and the ‘Current Kit Cost’ with your assigned sale cost for the finished product.

The kit price will be re-calculated automatically as component parts change, or if you have disabled this feature, by pressing the ‘Re-calculate’ button. Users can update the cost details for a build, allowing for any recent changes to stock ledger components, their value or assembly markup costs. You can also use saved shortcuts in the quick select menu of the Stock Ledger to view ‘Parent Items’ and ‘Child Items’ for easy searching.

SQLWorks manufacturing gives you a toolkit to organize the manufacture of kits from countless components, and to keep track of costs at every stage of the production line.

 

For specialist manufacture and kitting tools – speak to us about SQLWorks Stock Control today.