ERP Archives - SQLWorks

‘Negative’ Stock & Advance Batches

One of the questions we’re often asked surrounds the tricky issue of ‘negative’ stock quantities, and how SQLWorks can help warehousing operations balance flexibility with security.

By default, SQLWorks does not allow what some companies choose to call a ‘negative’ stock quantity. Ordinarily, the only stock that can be invoiced is the actual quantity of stock you hold, the act of invoicing moves it out of stock, and you cannot invoice a customer for stock you don’t have.

This is our recommended model, because it helps ensure business keep an accurate stock valuation and acts as natural protection against errors. While promises can be made to customers about stock owed, these remain only promises, and do not influence the company financials.

This model also makes intuitive sense to end-users: the ‘actual’ quantity will never be less than zero – reflecting the ‘actual’ amount a member of staff will find in a warehouse if they perform a stock check in person (either ‘some’ or ‘none’, but never a negative.)

However there are some instances where this principle runs into real-world difficulties. For example:

 

In fast-paced business operations or large factory sites, manufactured goods may need to be physically loaded for dispatch before a shopfloor member of staff or office team at another location are able to confirm in the system that the new stock quantity is completed. The negative stock restriction can then become a bottleneck, as a lack of stock quantity seen in the system holds up the dispatch & invoicing process, and delays the delivery of stock that was otherwise ready on time.

Production runs may not be exact – in some industries (such as printing) including and invoicing a small excess quantity or overrun of finished goods is typical: once again this can create a delay: where dispatch is held up by a tiny excess quantity that isn’t recognised in stock without some minor adjustments to data, and so can’t be invoiced in full.

Large production runs may have special contract terms or non ad-hoc invoicing arrangements agreed, where invoicing might sometimes run ahead of the production of stock. For this, a company would need to be able to invoice stock they ‘owe’ to a customer, and takes an acceptable level of risk for doing so.

 

SQLWorks offers three different solutions to this kind of ‘negative stock’ problem:

 

Solution #1 – Enabling the Dispatch Note System

Enabling the Dispatch Note system adds one extra step in the progression from Order to Invoice: the Dispatch Note. Before an invoice, the user must issue a dispatch note to a customer, which can contain stock lines selected from multiple orders, even those without stock quantity available to be invoiced yet.

The quantity ‘dispatched but not invoiced’ is logged separately under ‘Pending’ until enough ‘Actual’ stock quantity is identified. Once the user is ready to invoice, the company must invoice from the available lines listed on existing dispatch notes.

This system doesn’t allow stock to go ‘negative’, since the user must always ‘book in’ the actual quantity to eventually cover what was dispatched, before they can finally invoice the customer – but it does allow the customer to receive their goods promptly, while maintaining traceability over what was shipped. The Dispatch Note system is a good solution where the underlying issue is the time delay.

The authority to issue dispatch notes can also be optionally granted to warehousing staff, and this system also works in tandem with the Dispatch Planner.

 

Solution #2 – ‘Flexibility Mode’

The first of two ‘Advance Batch’ modes, this option permits SQLWorks to create synthetic batches of stock it doesn’t have physically available. Doing so allows a company to invoice for stock they don’t have yet – albeit with some important safeguards in place.

Firstly, these artificial advance batches are tagged as such behind the scenes to prevent any errors being introduced into the stock valuation. Secondly, when new stock quantity then arrives in from completed manufacturing or purchase order deliveries, this artificial stock quantity figure is absorbed first – reflecting the fact that the real stock was already invoiced out.

Thirdly, in this mode SQLWorks is only allowed to create as much artificial stock quantity as is already listed on outstanding Purchase Orders or Works Orders. While the user is now allowed to send an invoice for stock that isn’t quite ‘to hand’ yet, there has to be a corresponding entry on the system indicating from where the business was expecting that stock to materialise.

advance batches shown in SQLWorks stock control

For example: Advance and Adjusted stock quantities shown above, and a marker showing that stock batch 1016576 is an advance batch of x10 quantity that has been created by the system.

If you have Advance Batches turned on, you can use a quick filter under the Search bar to see all the items that have active advance batches (i.e those with negative stock that will use up future incoming quantity). If you print a stock valuation, advance batches will be treated as a ‘negative’ quantity for valuation purposes.

 

Solution #3 – ‘Unrestricted Mode’

The second of two ‘Advance Batch’ modes, this option permits SQLWorks to create batches of stock it doesn’t have physically available, with fewer restrictions.

Firstly, these artificial batches are tagged as such behind the scenes to prevent any errors being introduced into the stock valuation. Secondly, when new stock quantity then arrives in from completed manufacturing or purchase order deliveries, this artificial stock quantity figure is absorbed first – reflecting the fact that the real stock was already invoiced out.

However, in this mode there is no upper-limit enforced by the quantity outstanding on existing Works Order or Purchase Orders – allowing the company complete freedom to invoice irrespective of actual stock quantity, or even potential stock quantity.

Adopting this setting has important stock valuation and tax implications, so should only be used with great caution.

 

For ERP and stock control expertise, please contact our team today.

How MRP Revolutionises Purchasing

 

Good news! You’re in charge of a manufacturing business. Design an amazing finished product, buy its component parts, and set your team to work. Make something incredible and the World will surely beat a path to your door. Like so many industrialists before you, you are destined for greatness. As your finished goods are assembled you can watch your genius turn into innovation, skill into added value, and fame into fortune.

Well… maybe. But as your business scales, it becomes harder and harder to keep track of all the materials you need (and when you need them) to keep manufacturing on schedule. Disruptions begin to bite and there’s costly overheads everywhere you look, even underfoot.

Enter the MRP Run – a powerful process that some of the World’s most efficient manufacturing companies use to control purchasing and production. Using intelligent MRP software, even small businesses can organise sophisticated manufacturing operations without mistakes.

 

How MRP Works

Each time you begin an MRP run, SQLWorks scans through all your Sales (and Works) Orders, looking for demand for stock. It calculates which stock is already available, checks if components and materials are needed, and brings back recommendations. Those recommendations may be draft Purchase Orders (‘we need to buy A from Supplier B’) or Works Orders (We need to make X with Y.’)

For you, the human in the driving seat, things have changed. Your job is no longer the drudgery of compiling dozens of order lines, but to review MRP’s findings carefully, sense-check them, and be the authority that approves the next steps.

 

how mrp works

 

But think big! Unlike a human, MRP can scan through hundreds of orders, through multiple levels of Bill of Materials, cross-checking against tens of thousands of stock lines, bring back exact results in moments, and even prepare the paperwork for you to approve outgoing emails.

That automation potentially saves hundreds, even thousands, of person-hours creating routine purchase orders and works orders manually – and revolutionise the logistics behind manufacturing.

 

Key Benefits

There are several key benefits here:

  • Optimised Buying

    The bigger your business, the harder it becomes for one person to ‘see’ the whole picture themselves. Integrated MRP software has a much clearer visibility of both the stock you hold and the demand that’s coming, and can make clear decisions about quantities needed than even the World’s most perceptive purchasing manager.

  • Better Timing

    As long as your Sales and Production teams are logging demand for stock via Sales Orders and Works Orders, MRP can ‘look ahead’ into the future; warning you of stock shortages before they happen and making sure they are avoided. Delays cost money, so become a scheduling champion.

  • A Stress-Free Life

    Well not entirely, but it’s true that MRP can save many hours of staff time doing routine admin. Like other automation, MRP is particularly good at the ‘mundane’ work: volume purchasing that involves lots of lines and SKU codes. While these are not difficult for a human, it’s often not the best use of their time.

 

 

Optional Extras

Depending on how you use MRP we’ve included extra controls to better fit the different kinds of business operations – and help you make better decisions. You can choose how to use all of these to get the most value from our software – or speak with our SQLWorks team, to introduce something entirely new.

Closer Investigation

SQLWorks MRP answers the eternal question of every Purchasing Manager – ‘why do I need this?’ With our investigation button, the system can serve up an exact answer for where the source of demand for a stock item is coming from, what’s been found in stock, and allow the user to easily drill down to review the underlying Sales Order or Works Order.

Flexible time horizons

Businesses can choose to shorten or extend the timescale for how far ahead SQLWorks ‘looks’ when doing your MRP run. Extending the timescale can give your earlier warning of future peaks in demand, helping you prepare earlier – while shortening the timescale helps bolster your cash flow by ensuring you’re only buying what you need imminently.

Demand Filtering

By default each MRP run looks at all demand for stock – across both new sales orders and outstanding works orders – but you can optionally switch this to ‘Customer Orders Only’ – prioritising customer needs in your calculations over any new in-house demand for reserves.

Warehouse Filtering

Your MRP run can be isolated to a single SQLWorks Warehouse for greater accuracy. This is especially important for companies with multiple warehouses either in the UK or overseas, because it helps avoid costly recommendations to move stock between warehouses where the distances are impractical.

MRP reporting

Your MRP run can also be run as a report – and there’s no obligation to create the Purchase or Works Orders MRP recommends. Even if you’re not quite ready to implement MRP yet, you can still use it as a guide to inform your own purchasing decisions, or to test the feature.

Non-Manufacturing

Wholesale, resale and other kinds of companies can still get value from MRP even they’re not doing any manufacturing – because buying and selling remains essential even if stock doesn’t go through any processing.

Thanks for reading! For MRP and manufacturing software expertise, please contact our team today.

Getting Started with Quality Testing

 

We’ve introduced some important quality assurance tools into SQLWorks – allowing users to formalise their quality tests at different points of the stock control lifecycle.

Quality tests can be customised extensively and introduced at various stages of your workflow – including when receiving goods in, when manufacturing finished goods, or whenever you choose to test a batch that is being held in stock. We’ve also included new abilities to generate, store and integrate Quality Certificates – which will be covered more fully in a future blog post.

 

qa test- types

 

About Quality Testing

Quality tests may be created as standalone templates for your business, and can be customised for a wide range of different metrics. Saved tests can be either advisory or pass/fail, and include numerical measurements, dates, text answers and more – as well as specifying a level of precision for measurement, up to five decimal places.

You can assign tests (or a subset) as the default to any stock item in the stock ledger, formalising the ‘official’ set of tests that apply to that item.

 

qa tests 2

 

Quality Testing on Receipt

One of the most useful places to perform quality testing is at goods-in, at the point you receive inbound stock from a supplier. This can help check that you received what you purchase ordered, and that nothing is defective, damaged or missing.

To support this we’ve extended quality testing to the line-level of our purchase order receipt window – where the user can specify not only what goods were received, any variation to quantity, and those goods’ supplier lot number – but also save quality tests applicable to that line.

The correct tests for each line are automatically derived from that stock item’s defaults saved in the stock ledger, and results are automatically saved onto each new batch of stock that is created in the system when you receive the goods in – confirming that new stock has had its quality verified.

 

qa testing goods in

 

Quality Testing Manufacturing

Quality testing is also now available within Works Orders, helping you to verify that your finished goods have been manufactured correctly for sale.

Testing is listed under the ‘Inspection’ tab of a Works Order, and can be completed for each batch of finished goods that will be created by the works order.

Once again, the default tests are drawn directly from those specified on that stock item’s defaults.

 

qa inspection

 

Batch Quality Testing

Alternatively, a quality test may be completed for any given batch of stock via the ‘Batch Info’ tab of the stock ledger.

This is useful when you want to complete quality testing as a standalone process, test a batch at random, or look for something advised by a supplier (such as during a recall.)

SQLWorks gives businesses exceptional traceability over batches, the quality of your component stock, and the quality of your finished goods.

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.